How to get login in SQL server 2005 using 'sa'

Question

0.00/5 (No votes)

See more:

Dear Gents,
I have installed Sqlserver 2005 and management studio also.
i can login in SQL server 2005 using windows authentication but i m not able to get login using 'sa' even i have already enables 'sa' in SQL server and changed its passowrd also. after changing password even i restarted service also but no use.
One thing i have noticed that even i have changed password but once i re-open SQL server 'sa' properties then that changed password is not there but its showing password with different (default) length of characters.

i m getting error 'Login failed for user 'sa'. user is not associated with trusted SQL server connection. Erro 18452'

thanks

Posted 31-Mar-11 0:42am

usmanmughal

Updated 31-Mar-11 0:44am

Wild-Programmer

v2

Add a Solution

Comments

Wild-Programmer 31-Mar-11 6:44am

Did you install SQL server using the mixed mode authentication???

usmanmughal 31-Mar-11 7:21am

Actually i have installed visual studio .net 2005 and then i installed management studio. i dont remember about mixed mode that this option wqas there or not.

2 solutions

Solution 1

open SQL Server Management Studio Express and log in as a local administrator with a trusted connection...

navigate to the Security->Logins node of the Object Browser and select the sa login... rx click-->Properties.... in the Status tab verify the Login is Enabled property has been set.

Posted 31-Mar-11 0:45am

Ramalinga Koushik

Comments

Tarun.K.S 31-Mar-11 7:13am

Good answer.

[no name] 31-Mar-11 9:53am

Thanks Tarun.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Keith Barrow · Accepted Answer · 2011-03-31T01:38:00

You need to ensure that the server is in Mixed Authentication Mode:

In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.

Instructions lifted from here[^]