June 10, 2003 at 7:58 pm
Everytime I do, (using SQL Query Analyzer), I get a message like this
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
I already modified the password using EM. Still no luck. Please help.
"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett
June 10, 2003 at 10:12 pm
SQL Server has to be configured with 'windows and SQL Server' authentication. You can do it from EM --> Propereties --> security tab.
May 2, 2004 at 2:36 pm
I have the same problem but I've tried by creating a new account with owner rights to all databases and I still get the following error when connecting with query analyzer
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16, State1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply