May 18, 2009 at 6:23 am
Hi,
I try to Upgrade Sql 2000 to Sql 2005 the same instance and succeed. After upgradation try to run the my Dynamics GP then I got the following error Message
You're attempting to log in from a data source using
trusted connection. Update the Sql Server settings for this data source to disable trusted connections and try login in again.
I am able to connect 'sa' and other users not possible to connect. SQL Authentication Mixed Mode.
How can I solve this problems pls help me
May 18, 2009 at 6:29 am
mohamedek (5/18/2009)
Hi,I try to Upgrade Sql 2000 to Sql 2005 the same instance and succeed. After upgradation try to run the my Dynamics GP then I got the following error Message
You're attempting to log in from a data source using
trusted connection. Update the Sql Server settings for this data source to disable trusted connections and try login in again.
I am able to connect 'sa' and other users not possible to connect. SQL Authentication Mixed Mode.
How can I solve this problems pls help me
Check the SQL Server Surface Area Configuration / SQL Server Configuration Manager. For more info see SQL BOL.
May 20, 2009 at 2:18 pm
Hi
check this link
http://www.windowsecurity.com/articles/SQL_Server_2000_Authentication.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply