Adding a new user to SQL Server

We faced an issue with SQL server login recently. The user is an Administrator in the SQL Server box, but don’t have access to the SQL Server. The user who have access to the SQL got disabled. How the Administrator can add a new user or himself in SQL Server?

We followed the following steps to add the new user without SQL login

1. Stop the SQL Server service.

2. Run the SQL Server service in single mode using [default instance]
“C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\sqlservr.exe” -c -m

3. Start the management studio and Connect to the instance.
4. Add the user login in Security
5. Stop the SQL Service again and re-start it.

Advertisements

About ambilykk

I am a Technology Evangelist on Microsoft Technologies. I am carrying the passion on Microsoft technologies specifically on web technologies such as ASP .Net and Ajax. My interests also include Azure and Visual Studio. Technology adoption and learning is my key strength and technology sharing is my passion.
This entry was posted in SQL and tagged . Bookmark the permalink.

2 Responses to Adding a new user to SQL Server

  1. Maiganamurthy.A says:

    hi friend,
    i read all your blog messages , and all are very useful one,
    if you know something about windows workflow foundation, kindly share with me,
    my mail id is “mai.mailpage@gmail.com”.

    Thank you friend,
    Maiganamurthy.A

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s