I am suffering with a stupid problem.

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 2005 Forums

SQL Server Administration (2005)

I am suffering with a stupid problem.

Author

Topic

toolbox
Starting Member

6 Posts

Posted - 2007-06-18 : 20:09:58

Dear Sql server experts
I am suffering with a stupid problem in login into SQL server using SQL authentication method

Well here is the case.
When I start SQL server management studio of sql server 2005
A connect to server dialog comes up with 3 enabled combo box's for server type , server name and authentication
If I connect to server via windows authentication then every thing goes fine but when I use the damn

sql authentication so this alert occurred "Login failed for user 'toolbox', The user is not associater with a trusted SQL Server connection."
Even with sa.
Does any body has idea what to do? How to fix it? Please.

this is the alert when i use "sa"
TITLE: Connect to Server
-
Cannot connect to myserver
-
ADDITIONAL INFORMATION:
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

toolbox
Starting Member

6 Posts

Posted - 2007-06-18 : 21:32:06

i got it
it was my mistake
if you ever face this problem the open ssms, right click the server name, then select properties
go to security and change to sql server and windows authentication mode for server authentication

that's it