Sql-server – How to become an administrator for SQL Server

permissionssql server

Here is the situation:

  1. I Installed VS2013

  2. That comes with SQL Server Express

  3. I am not able to create a DB from VS2013

  4. thinking that it's because of user privilege issues, I Installed SQL Server Management Studio

  5. I have looked to figure out how to give myself Administrator privileges on SQL Server, and nothing has worked so far

  6. I am the administrator of my Windows7

  7. I run the SQL Server Management Studio as Administrator

Still I get error messages about not having permission to perform this action: Error 15247

Any ideas what I need to do to have permission

Link to image.

enter image description here

enter image description here

Best Answer

Since you have made sure that you have SQL Server installed on your machine all is left is to make sure that you follow the following steps to create a database.

1) Go to Server Explorer right click Data Connections and Select Create New Sql Server Database...

enter image description here

2) This will open a pop-up window enter your MachineName\SQLEXPRESS in Server Name section or select a server name from the Drop down list.

3) Enter the New Database Name.. .

enter image description here

And you are good to go.

Related Question