Timeline for How to become an administrator for SQL Server
Current License: CC BY-SA 3.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 9, 2015 at 19:29 | comment | added | user1298925 | I found this answer in SO which solved my problem. [enter link description here][1] [1]: stackoverflow.com/a/4188404/1298925 | |
| Jan 9, 2015 at 19:28 | comment | added | user1298925 | I found this answer that solved my problem [Answer to Admin Lockout by AlexS][1] [1]: stackoverflow.com/a/4188404/1298925 | |
| Jan 7, 2015 at 8:37 | history | migrated | from stackoverflow.com (revisions) | ||
| Jan 6, 2015 at 23:06 | comment | added | user1298925 | Let us continue this discussion in chat. | |
| Jan 6, 2015 at 23:01 | comment | added | user1298925 | I am one step closer by adding MachineName\SQLEXPRESS / However now the error message says: CREATE DATABASE permission denied in database 'master. | |
| Jan 6, 2015 at 22:59 | comment | added | M.Ali | I am not the one who voted it but this question has been asked before many times and if you search online you will find plenty of references about this issue and it is a very basic connectivity issue. | |
| Jan 6, 2015 at 22:57 | comment | added | user1298925 | I was not allowed to edit my comment for 5 minutes, thus my dealy in response. I have doen exactly as you suggested in your answer and I am getting the error message that I added to my original question. I was thrown off by the person who has voted my question as off topic to be closed, I don't understand some of these closure votes. I hope the question stays open because I can't see the problem with it | |
| Jan 6, 2015 at 22:53 | comment | added | M.Ali |
did you select the server name from the drop down list? Error suggests that you are selecting the wrong server name. If you didnt have any sql server installed before the chances are that this SQL Server in a default instance, in that case you will need to only enter the MachineName , if it is a named instance then you will have enter the MachineName\SQLEXPRESS in server name section.
|
|
| Jan 6, 2015 at 22:46 | comment | added | M.Ali |
Just make sure that is it running, if it isn't running then right click go into properties and set it to start Automatic and then start the services.
|
|
| Jan 6, 2015 at 22:44 | answer | added | M.Ali | timeline score: 2 | |
| Jan 6, 2015 at 22:44 | comment | added | user1298925 | 1- Would you say its running? it just says it started though. | |
| Jan 6, 2015 at 22:34 | comment | added | M.Ali | 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? | |
| Jan 6, 2015 at 22:33 | comment | added | Pieter Geerkens | @user1298925: SQL Server Agent service is not necessary for basic operations on the DB Engine, making it a red herring for your current issue. SQL Server itself is running, so that is fine. | |
| Jan 6, 2015 at 22:27 | comment | added | user1298925 | I included the error message in my original question. It looks like one is started (not running) and one stops right after starting | |
| Jan 6, 2015 at 22:14 | comment | added | M.Ali |
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)
|
|
| Jan 6, 2015 at 22:12 | comment | added | user1298925 | The express version got installed automatically with Visual Studio 2013 . I see it in Control Panel | |
| Jan 6, 2015 at 22:09 | comment | added | M.Ali | Did you actually install SQL Server ? | |
| Jan 6, 2015 at 22:04 | history | asked | user1298925 | CC BY-SA 3.0 |