Post reply

How to add another administrator

  • February 10, 2015 at 1:51 am

    #295314

    I recently bought a Surface Pro 3 and installed SQL Server on it. I added the current user as sysadmin. Later I created other accounts.

    Now I have the problem that I forgot to add the other accounts to the role sysadmin. And for some strange reason, I can't log on with the original account anymore (this was a email account that the Surface uses; this problem is posted in another forum).

    So I can't logon to SQL Server with my local account. I tried to run setup again, hoping that I could add administrators there. But I can't get past the Features page. That gives me an error telling me I haven't selected anything. But the checkboxes are greyed out.

    Has anyone any idea on how to solve this?

  • February 10, 2015 at 4:39 am

    #1776574

    See http://www.mssqltips.com/sqlservertip/2465/how-to-connect-to-sql-server-if-you-are-completely-locked-out/

    and https://msdn.microsoft.com/en-us/library/dd207004.aspx

    -- Gianluca Sartori

  • February 11, 2015 at 2:19 am

    #1776846

    Thanks Gianluca. It worked. I had to add another account since the link with the original account had become corrupt. But with the new account I removed the first and added it again as sysadmin. It works now.

  • February 11, 2015 at 8:18 am

    #1776947

    Glad I could help

    -- Gianluca Sartori

  • February 14, 2015 at 4:49 am

    #1777656

    hie

    Below I am mentioning the steps you need to perform that may help you with this situations.

    1 - SQL Server and SQL Serve Agent services in SSMS are needed to be stopped first .

    2 - Go on Start then on Run and click on cmd and press 'OK' button and navigate to SQL Server's Binn directory.

    3 - Run 'sqlservr -m' command , this will start your SQL server in single user mode after entering into SQL server Binn directory.

    Note:- This process may need time, as soon the SQL server is in single user mode " Recovery is completed.This is a international message only. No user action required.

    4 - Now open a new command prompt window, use sqlcmd utility to connect to your SQL server instance:-

    Use -S parameter along with full name (if you have named your instance). Also can you use E switch for trusted connections. And fortunately if you are a Windows local administrator you will get access to the server.

    5 - Now you can add BUILTIN\Administrators group to the instance and can create a login as you are connected to the server as SYSADMIN rights. You can also add DBA Windows domain group in your admin login.

    6 - Assign roles to your created login.

    7 - Now you can access to SSMS and connect the instance using newly created login.

    I hope that these steps will help you. Feel free to ask.

    Thanks & Regards

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply