How do you add an administrator user to SQL Server 2008?
If you're doing it via T-SQL:
Granting a Windows Login the ability to connect to SQL Server:
If SQL Server-based login:
After that, you can do one of two things. You can add it to the membership of the sysadmin fixed server role using sp_addsrvrolemember:
or you can grant the login CONTROL SERVER permissions:
Before that I think we need to be able to login to SQL Server first. I have experienced being a server administrator, but I couldn't login since SQL Server was installed by a Domain Admin account.
So you might need to start SQL Server with command-line option
and then do as K. Brian Kelley said, or connect via management studio, as suggested by Jeff (the login will succeed)
More step-by-step instructions can be found in SQL Server 2008: Forgot to add an administrator account?
For completeness, the GUI method
From SQL Server Management Studio, under the Security / Logins folder for the database, right click Logins and select New Login:
Be sure to use the full
Hmm, there are two different things this could mean.