sometime we may face problem to change password of sa using sql server management studio. that becasue by default this is not set to SQL server and windows authentication mode. Here the solution to do it step by step.
1.Open the SQL Server express management studio
2.Connect to SQL Server using windows authentication
3.Right click the server name and choose properties
4.Go to security tab. Change server authentication to “SQL Server and Windows Authentication mode”
5.Click OK and restart SQL Server
6.Go to SQL Server studio management express
7.Expand the server and choose security and expand logins
8.Right click on SA, from properties modify the password and confirm password
This changed pass should work.
any solution for great vista ! ?
great! it work’s
Just Wanted To SAy Thank You!
Thanks – well done
(Australia)
I’m sorry to say this didn’t work for me. Annoying me showing two Errors. On first try every time it shows this one:
“A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)”
From the next following times it shows…..
“Login failed for user ’sa’. Reason: The account is disabled. (Microsoft SQL Server, Error: 18470)”
Can anyone help me out that…
Hiii Vexed,
have you got any solution for the sa login problem ..coz im also facing the same problem.
what i observed is after setting the password for the sa login in the status tab of the properties window…if i open it agian the password is getting reset to the default one.
im not able to change the password.
Is it the same case with you ?
Kindly share the solution with me .
Thanks
BTREDDY.
Hi and thanks for the your log.
I try to do that but there is a problem, when I right click the server name , Properties is disable and I can’t click it.
Could you please guide me ?
BTW : I have VS2008 SP1