February 17, 2010 at 10:08 pm
Hi,
I have SQL server 2005 installed on my machine. I am able to log on to server using windows authentication, but when I try to use SQL server authentication, using user as 'sa' and the default paswrd, It gives me error as "Login failed for user 'Sa'. This user is not associated with a trusted SQL connection.
How do I know passwrd for user sa.
Thanks in advance.
February 17, 2010 at 10:18 pm
What is the authentication mode for this server? From the error it seems that you are using Windows authentication mode. If you want to use SQL logins it needs to be set in mixed mode. More info about the error can be found here. It's a page for SQL 2000 but the idea is the same. To change the authentication mode have a look at this from MSDN.
-Luke.
February 17, 2010 at 10:39 pm
Is this your local desktop? Or is it a server that is used by several people?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 17, 2010 at 10:53 pm
Thanks a lot..
my problem got solved now:):)...
February 17, 2010 at 10:54 pm
Would you mind divulging how you solved it?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 18, 2010 at 2:18 am
Hi,
I have changed the authentication mode of my sql server.
earlier it was selectd as "Windows Authentcation".. have changed it to SQL Server and Windows Authentication Mode...
February 18, 2010 at 10:46 am
Thanks for posting back. Good to know it is working now.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply