{"id":1765,"date":"2014-09-10T09:03:04","date_gmt":"2014-09-10T09:03:04","guid":{"rendered":"http:\/\/www.isunshare.com\/blog\/?p=1765"},"modified":"2023-04-17T03:22:09","modified_gmt":"2023-04-17T03:22:09","slug":"how-to-access-to-sql-after-lost-sql-server-database-sa-password","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/how-to-access-to-sql-after-lost-sql-server-database-sa-password\/","title":{"rendered":"How to Access to SQL after Lost SQL Server Database SA Password"},"content":{"rendered":"

Maybe you have faced such an issue of losing SQL Server SA password<\/strong><\/a>.\u00a0 SQL Server SA password was ever set for protecting database, however, now it has become a problem for us to login SQL Server and access data in SQL Server. How to access SQL Server no logon password?<\/em><\/p>\n

If you are a computer novice, the easiest way is undoubtedly easy-to-use and safe password recovery tool. SQL Password Genius<\/strong> is one of such effective recovery tools for SQL Server 2000\/2005\/2008\/2012\/2014. Now please see how does it help to access SQL Server when you don\u2019t have SA password<\/strong>?<\/p>\n

First Way: Access SQL Server by Recovery Tool without SA Password<\/h2>\n

Step 1:<\/strong> Download and install SQL Password Genius<\/a> on computer where you run SQL Server.<\/p>\n

Step 2:<\/strong> Run SQL Password Genius and import SQL master database.<\/p>\n

Tips:<\/strong> Please stop SQL Server Service in SQL configuration tool before running SQL password recovery tool. Otherwise, reset lost SQL sa password<\/strong> would be not so easy, perhaps failed at last.<\/p>\n

\"reset<\/a><\/p>\n

Click Open File<\/strong> button on program to browse master file in computer and open it. Master file route would be shown in a file box, and all the users available for this database are listed, see the picture below.<\/p>\n

Step 3:<\/strong> Select SQL Server SA account and reset password.<\/p>\n

Generally, SQL Server SA account is in the first place of user box. User Name and Password status would let us know whether the user’s password should be reset. If its password status is “Unknown” , select “sa” account and click Reset<\/strong> button.<\/p>\n

Instantly, a dialog pops up and asks us to set a new password for it. Type a new password and click OK. Then the new password for sa account would appear in user box.<\/p>\n

\"access<\/a><\/p>\n

Now, exit SQL Password Genius, restart SQL Server Services in configuration tool, you will be able to start SQL Server and access it with sa account and its new password.<\/p>\n

Second Way: Access SQL Server in Single User Mode<\/h2>\n

If you have a member there is a member of the Windows admin group, this way also would help you to access SQL Server with Windows credentials<\/strong>. It can be used for SQL Server 2005\/2008(R2).<\/p>\n

To start SQL Server in single user mode is very simple like the steps below (take SQL Server 2008 as example:<\/p>\n

Step 1:<\/strong> Go to\u00a0SQL Server Configuration Manager<\/strong>\u00a0and click on\u00a0SQL Server 2008 Services<\/strong>.<\/p>\n

\"access<\/a><\/p>\n

Step 2:<\/strong> Click on\u00a0desired SQL Server instance<\/strong>\u00a0and right click go to\u00a0properties<\/strong>.<\/p>\n

Step 3:<\/strong> On the Advanced<\/strong> table enter param ‘-m;<\/strong>‘ before existing params in\u00a0Startup Parameters<\/strong>\u00a0box.<\/p>\n

Make sure that you entered semi-comma after -m<\/strong>. Once that is completed, restart SQL Server services to take this in effect. You would see a message “SQL Server started in single-user mode.”<\/p>\n

Once this is done, now you will be only able to connect SQL Server using sqlcmd utility with Windows authentication.<\/p>\n

Tips:<\/strong> In the whole process, probably you have found there is so much downtime. If you want to make it faster, download PSExec<\/a>.<\/p>\n

How to set SQL Server access with single user mode<\/a><\/p>\n

However, this way is disaster recovery, so only had better be used when no other recovery method is available. It allows Windows administrator override within SQL Server. And it requires following intrusive actions during the process:<\/p>\n

    \n
  1. Stop SQL Server and restart it in single-user mode<\/li>\n
  2. Connect to SQL Server using Windows credentials<\/li>\n<\/ol>\n

    Related Articles:<\/strong><\/p>\n