0

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

Improve this question
15
  • Did you actually install SQL Server ?
    – M.Ali
    Commented Jan 6, 2015 at 22:09
  • The express version got installed automatically with Visual Studio 2013 . I see it in Control Panel
    – user1298925
    Commented Jan 6, 2015 at 22:12
  • Go to run type Services.msc and then try to find SQL Server (MSSQLSERVER) in the list of services and make sure it is running. If it is express then it may say something like SQL Server (SQLEXPRESS)
    – M.Ali
    Commented Jan 6, 2015 at 22:14
  • I included the error message in my original question. It looks like one is started (not running) and one stops right after starting
    – user1298925
    Commented Jan 6, 2015 at 22:27
  • 1
    Ok so one thing is established that you have sql server and it is running, now how are you trying to create a database from Visual Studio?
    – M.Ali
    Commented Jan 6, 2015 at 22:34

1 Answer 1

Reset to default
2

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.

Improve this answer
3
  • I am one step closer by adding MachineName\SQLEXPRESS / However now the error message says: CREATE DATABASE permission denied in database 'master.
    – user1298925
    Commented Jan 6, 2015 at 23:00
  • Are you logged in as an account with Admin rights on your pc? if so use use "Windows Authentication" to connect to sql server.
    – M.Ali
    Commented Jan 6, 2015 at 23:11
  • Yes I am logged in with Administrator rights. I am clueless why this thing is not working. But I am looking all over internet
    – user1298925
    Commented Jan 7, 2015 at 14:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.