griffofk - Friday, September 9, 2011 12:49 AM:
Any help with this error would be appreciated...
Trying to access foriegn DB located on same server as Innovator system via method/SQL Process I get the following error:
The server principal "S-1-9-3-1...." is not able to access the database "DB" under the current security context. in SQL: exec stored_procedure
Brian - Tuesday, September 13, 2011 8:44 AM:
Hi Griffofk,
SQL Server does not recognise the Aras Innovator database as a "Trusted Source".
See this link: http://technet.microsoft.com/en-us/library/ms187861.aspx
Basically you need to run this command from SQL Server Management Studio:
ALTER DATABASE YourDatabaseName SET TRUSTWORTHY ON;.
Hope this helps,
Brian.
