user not associated trusted SQL Server connectio

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

user not associated trusted SQL Server connectio

Author

Topic

Vishakha
Starting Member

40 Posts

Posted - 2007-01-30 : 00:48:07

Hello,
Here is my problem,
I need to connect to sql server 2005 from my java application
I am getting this errror
user not associated with a trusted SQL Server connection
which is fine as I was using "Windows authenticaton" mode

Now the problem when I try to enable sa account, in Management Studio it doesn't give me any error, but when I try to connect using "sa" account, using management studia, I am getting the same "trusted connection" error
On the similar lines, I created a new login, which I could create successfully.
I tried connecting to studio using sql server authentication mode, I am getting the same error
"Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)"

FYI -- I also created credentials for the windows user name that I use to connect to.
Configuration of my machine is windows 2000, sql server 2005.

Please help as I can't think of trying anything else.

This is a standalone machine.

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-01-30 : 00:54:05

Is your sql server configured for mixed mode?
Make sure your sql is configured for mixed mode to use sa acount or any sql account..

MohammedU