RECOVERING SQLSERVER "SA" LOGIN PASSWORD


The time may occur that you may forget or lost your sql server “sa” or “sysadmin” login’s password.  This process will give you an opportunity for retaining forgot or lost password of your sqlserver’s “sa” login.

  1. Select “SQL SERVER CONFIGURATION MANAGER” from start menu. 




2. Select SQLSERVER from the left panel and right click on “SQL SERVER (MSSQLSERVER)” from the right panel.  Select stop from the context menu appeared for stopping the sqlserver service.


3. After stopping the service again right click on the SQLSERVER service and select properties.  In properties window select advanced tab.  Now for the startup parameter add “-m;” at the starting position of the string as show in the below diagram.


4. After changing the startup parameter again start the sqlserver service.

5. Now open the command prompt and from here we will create a user with the sysadmin role and by using this users login we are going to change the sa login’s password.

6.Open the command prompt and type “SQLCMD”, So that you will change to the sql prompt.

7.By the following command create new user with name “recovery”
CREATE LOGIN recovery WITH PASSWORD=’dileep1234’
GO
You have finished creating a user now you should assign a role to this user as SYSADMIN by the following command.
Sp_addsrvrolemember ‘recovery’,’sysadmin’
GO



8. Now again stop the SQLSERVER service and go to its properties and remove “-m;” in the startup parameter and againg start the service.

9.Now login to the newly created recovery account and change the password of the “SA” login’s password.

That’s it you have now successfully use this account with your new password.

Comments

Post a Comment

Popular posts from this blog

Dynamically Creating Image in C#.Net

              As per the requirement from one of my client, an image should be generated dynamically by taking the necessary information from the user.  When I went on a search, I came to know that, my crazy DotNet framework provided my two namespaces System.Drawing and System.Drawing.Imaging.  It’s enough to learn three classes from these namespaces - Bitmap and Graphics for generating an image dynamically related to System.Drawing Namespace and FileFormat class is for saving the created image in different file formats and is related to System.Drawing.Imaging Namespace.             Bitmap class is useful to generate a new image and to save it different file formats.  Graphics class is useful to design the image using lines, curves, rectangles, text etc., with colors and everything.  FileFormat class is useful to save the file in a particular or in different formats like Jpeg, Png, Bmp etc.  The default format is png.                         Now lets jump into code.  After
Read more

SENDING MAIL USING OUTLOOK IN VB.NET

INTRODUCTION :-                 One of my clients required a desk top application that maintains contacts in a database and sends emails to the contacts in the database.  They have not provided the credentials and the details of mail server.  So I created an application that uses outlook for sending mails by using the credentials preconfigured by the outlook account.  This application can send email for multiple email accounts and with or without attachments. FEATURES :- ·          Sending mails to multiple email accounts at a time. ·          Using configured outlook credentials. ·          No need of configuring credentials every time. ·          Sending mails with attachments. CODE EXPLANATION :-                 Create new project and add references as follows.  These files can be downloaded or can be achieved by the sample project which is attached with this article. Interop.Microsoft.Office.Core.dll Interop.Outlook.dll Let’s go to code part.  Import the fo
Read more

Data Table Vs List

Data tables are the best data source for many controls in .net environment.  But manipulating data with data tables i.e., when considering large amount of data its a wind up process.  The process will be very slow when we compare the same manipulation with List. For an analysis I iterated 1500 records with some login with data tables and list.  The analysis report is as below With Data Table 1500 Rows Data Table - Processing Time - 2 minutes 44 seconds With List 1500 Items List - Processing Time - 32 seconds Conclusion: For manipulating large amount of data, its better to choose List rather than Data Table.
Read more