.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

unable to login sqlserver authentication

Posted By: parthiban     Posted Date: August 16, 2012    Points:5   Category :Sql Server
unable to login sqlserver authentication..how to retreive password or create new sa login

Responses
Author: Deco             
Posted Date: August 16, 2012     Points: 20   

retrieving sa login's password is easy if you are using sql server 2005 or above

Please follow the below steps to retrieve or rest you existing password

1) Login to sql server using windows authentication

2) Expand the Sql Server Instance in Sql Server Management Studio

3) Expand "Security"

4) Right click over the "sa" and click Properties

5) In "General" Page, you will have the Password and confirm password textboxes.

6) Give the new password and uncheck the Exisiting Password field and hit ok.

now you can login to sa login with the new password that you have set.



Regards,
Deco
Author: Baimey Rajesh             
Posted Date: August 28, 2012     Points: 20   

Please do respond if the answer helps.
That will be helpful for others who visit the forum.

We have a good team to help out. Please do respond if you get the help.

Thanks
Baimey



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend