Adding a new user to SQL Server

Posted on August 9, 2011 by ambilykk

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.

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.

View all posts by ambilykk →

This entry was posted in SQL and tagged SQL. Bookmark the permalink.

2 Responses to Adding a new user to SQL Server

Maiganamurthy.A says:

September 8, 2011 at 10:56 am

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

Reply
- ambilykk says:
  
  September 8, 2011 at 12:47 pm
  
  Hi Maiganamurthy
  
  You can find my workflow related articles from My Articles tab.
  I have a series of articles on Windows Workflow Foundation 4.0.
  
  Regards
  Ambily
  
  Reply