Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hellodoh
Starting Member
3 Posts |
 Posted - 2010-01-15 : 05:22:08
|
| I took my SQL Server 2008 offline because I was trying to do something... Now I can't log in to it using SQL Server Management Studio anymore. "The server was not found or was not accessible." I'm not sure exactly what I did, but whatever I did, I need to undo it.I recall right-clicking on the connection in Management Studio and hitting "Stop". I was still logged in and would be able to "Start" it again, but didn't. I then closed SMSS and now I can't log in to the database again.Any help appreciated. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-15 : 05:28:15
|
| Use Administrative Tools : Services to re-start the SQL Service on that machine? |
 |
|
|
hellodoh
Starting Member
3 Posts |
Posted - 2010-01-15 : 05:32:02
|
| Thanks, but that didn't help. I also tried restarting the computer. |
|
|
|
hellodoh
Starting Member
3 Posts |
Posted - 2010-01-15 : 07:15:56
|
| Never mind, I was connected to the completely wrong computer (remote desktop). |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-15 : 07:18:14
|
| Note that restarting the computer might not help - e.g. if the service has been changed to NOT start automatically.I assume the service is now running then?Anything in the SQL Error logs when it restarted that sheds any light? That file is ERRORLOG - mine is in this path:x:\MSSQL\MSSQL10.MSSQLSERVER\MSSQL\Logthere will also be ERRORLOG.1, ERRORLOG.2, ... which will be from previous sessions.Look out for any DMP Dump files in that folder too - which will be crash-dump-analysis data - and might indicate a Procedure that was running at the time of a crash, and which might therefore be the cause. |
|
|
|
|
|
|
Unable to connect to stopped SQL Server 2008