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 Administration (2000)
 loggging in with sa

Author  Topic 

uniquegodwin
Starting Member

12 Posts

Posted - 2006-02-11 : 03:35:49
Hello,
Im using sqlserver 2005 express edition..
And Im also using SQL sever management studio.
Im having a problem logging into sql server using the sa account.
I tried going into the management studio using windows authentication and changing the password of sa and seeting a password 'new'.I changed it.but still,I cant login using sa.
Can someone please help me with it.
Thanks so much

Godwin

uniquegodwin
Starting Member

12 Posts

Posted - 2006-02-11 : 03:40:57
The error message Im getting while logging in is...The user is not associated with a trusted sqlserver connection.Please help me..please,Thanks
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-02-11 : 03:51:01
ease up on the cross posting.

did you configure SQL Server in mixed mode? See this for more info http://msdn2.microsoft.com/en-us/library/ms143705.aspx


EDIT:
corrected link



-ec
Go to Top of Page

uniquegodwin
Starting Member

12 Posts

Posted - 2006-02-11 : 04:05:20
Hello,
Thanks for the quick reply eyechart...sorry for the cross posting..It was very urgent :)
ok,now this is what I see :(

Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-02-11 : 07:36:40
Have you run the Surface Config Area tool ?

----------------------------------
'KH'

everything that has a beginning has an end
Go to Top of Page

uniquegodwin
Starting Member

12 Posts

Posted - 2006-02-12 : 09:49:14
What is that? How do I run that? Im using sql server 2005 express edition.
Go to Top of Page
   

- Advertisement -