Qué sinónimo debo modificar para que EvoWorkFlowUser se conecte a otra base que no sea la estandar EvoConfig, por ejemplo EvoConfigAseinfo

En ASEINFO Evolution está configurado con bases de datos que se llaman EvoDataAseinfo, EvoConfigAseinfo. Tenían version 1.5, y la actualice a version 1.7

ya modifiqué las conexiones en la herramienta de configuración y ya recree los sinónimos de EvoDataAseinfo y EvoConfigAseinfo, sin embargo, al conectarme me da el siguiente error, qué otro sinónimo debo configuraR?

The server principal "EvoWorkflowUser" is not able to access the database "EvoConfig" under the current security context. System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The server principal "EvoWorkflowUser" is not able to access the database "EvoConfig" under the current security context. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Objects.Internal.ObjectQueryExecutionPlan.ExecuteTResultType at System.Data.Objects.ObjectQuery1.GetResults(Nullable1 forMergeOption) at System.Data.Objects.ObjectQuery1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Aseinfo.VH4.General.Services.SeguridadContenido.SeguridadContenidoService.GetCompaniasAutorizadasDeUsuario(String username) in c:BuildAgentwork5ed3bec7206feb61VH4GeneralServicesSeguridadContenidoSeguridadContenidoService.cs:line 48 at Aseinfo.VH4.UI.Web.Controllers.AccountController.Login(String txtUsername, String txtPassword, Boolean chkRememberMe, String returnUrl) in c:BuildAgentwork5ed3bec7206fe

basedatos conexion evodataworkflowuser

asked 03 Jun '13, 15:28

Juan Carlos Soria
1.1k●171●179●185
accept rate: 41%

One Answer:

oldest newest most voted

En mi caso, se volvió a ejecutar el script de creación de sinónimos, cambiando el sufijo respectivo.

set nocount on use EvoConfig


DECLARE
@esquema varchar(50),
@nombre varchar(50),
@base varchar(200)
DECLARE C_SYNO CURSOR FOR
select b.name esquema, a.name nombre, 'EvoData.'+b.name+'.'+a.name base
     from sys.synonyms a
   join sys.schemas b on b.schema_id = a.schema_id 
   order by b.name, a.name
SELECT 'USE EvoConfig'
OPEN C_SYNO
FETCH NEXT FROM C_SYNO INTO @esquema, @nombre, @base
WHILE @@FETCH_STATUS = 0
BEGIN
print 'IF  EXISTS (SELECT * FROM sys.synonyms WHERE name = N'+''''+@nombre+''''+')'
SELECT 'DROP SYNONYM '+@esquema+'.'+@nombre
union all
SELECT 'CREATE SYNONYM '+@esquema+'.'+@nombre+' FOR '+@base
FETCH NEXT FROM C_SYNO INTO @esquema, @nombre, @base
END
CLOSE C_SYNO
DEALLOCATE C_SYNO
DECLARE
@esquema varchar(50),
@nombre varchar(50),
@base varchar(200),
@EvoConfig varchar(100),
@EvoData varchar(100),
@Sufijo varchar(100)
set nocount on
Set @Sufijo = ''
use EvoData
DECLARE C_SYNO CURSOR FOR
select b.name esquema, a.name nombre, 'EvoConfig.'+b.name+'.'+a.name base
     from sys.synonyms a
   join sys.schemas b on b.schema_id = a.schema_id 
   order by b.name, a.name

SELECT 'USE EvoData'+@Sufijo OPEN C_SYNO FETCH NEXT FROM C_SYNO INTO @esquema, @nombre, @base WHILE @@FETCH_STATUS = 0 BEGIN SELECT 'IF EXISTS (SELECT * FROM sys.synonyms WHERE name = N'+''''+@nombre+''''+')' union all SELECT 'DROP SYNONYM '+@esquema+'.'+@nombre union all SELECT 'CREATE SYNONYM '+@esquema+'.'+@nombre+' FOR '+@base FETCH NEXT FROM C_SYNO INTO @esquema, @nombre, @base END CLOSE C_SYNO DEALLOCATE C_SYNO

link

answered 03 Jun '13, 16:52

Juan Carlos Soria
1.1k●171●179●185
accept rate: 41%

edited 03 Jun '13, 17:27

Fernando Paz ♦♦
17.3k●8●16●35

Your answer

toggle preview

community wiki

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Evolution en BitBucket

En este sitio puede acceder al código fuente, centro de descargas y reportar bugs, propuestas y mejoras para Evolution.

Evolution en JIRA

En este sitio puedes sugerir nueva funcionalidad para Evolution, o puedes votar por la funcionalidad ya propuesta por otros usuarios.

Tags:

basedatos ×4
conexion ×2
evodataworkflowuser ×1

Asked: 03 Jun '13, 15:28

Seen: 7,109 times

Last updated: 03 Jun '13, 17:27

Qué sinónimo debo modificar para que EvoWorkFlowUser se conecte a otra base que no sea la estandar EvoConfig, por ejemplo EvoConfigAseinfo

Follow this question

Evolution en BitBucket

Evolution en JIRA

Related questions