How do I make myself an admin in SQL Server?

Question

Make sure that that SQL Server Agent is not running. If started, it will take your only connection. On the Windows 8 start screen, right-click the icon for Management Studio.At the bottom of the screen, select Run as administrator. 27 мар. 2012 г.

In the Object Explorer of SQL Server Management Studio, navigate to the Security folder and expand it. Right-click the Logins folder and choose New Login. The Login - New dialog box opens. Select the General page, and then enter a user name in the Login name text box.

How do I know if I am admin in SQL Server?

You right click sysadmin and click properties to get a list of sysadmins. You can do this for any role, and that's the easy way if you want to verify permissions.

How can add sysadmin role in SQL Server?

Right-click the Logins node and select New Login from the pop-up menu. Click Search next to Login Name and specify the user that you want to assign the sysadmin role to. Specify the Server roles tab and assign the sysadmin role to the new login.

How do I gain access to a SQL Server database?

SQL Server has an emergency back door that you can access by restarting it in single-user mode. When in single-user, you can then add yourself as a login and add the login to the sysadmin group. The restart SQL normally, and you have full access.

Expert · Answer