| Author |
Topic |
|
midpitts
Starting Member
12 Posts |
 Posted - 2012-02-06 : 11:56:01
|
I am a student taking a course in SQL Server 2008. I have installed SQL Server 2008 Enterprise on my laptop and created a second instance. I have a database installed and I have worked in the database through managment studios. I closed management studios and am trying to use SQL Server again to access this database. I can't log back into the management studio. I have used the default as well as the instance name and get an error message. I am not connected to a network server... everything is on this laptop. this is the printscreen of the error I get: Thanks for any assistance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
midpitts
Starting Member
12 Posts |
Posted - 2012-02-06 : 13:07:52
|
| sorry the image link isn't working the text of the message is:Cannot connect to..Additional information: A network-related or instance specific error occurred while establishing a connection to the SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: named Pipes Provider, error: 40 – could not open a connection to SQL Server)(Microsoft SQL Server, Error: 2) When I used the name instance I get the same error but it states )(Microsoft SQL Server, Error: 53) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
midpitts
Starting Member
12 Posts |
Posted - 2012-02-06 : 13:31:31
|
| Thanks so much for your help. I am not really sure what I need to start DB2 is the name of my instance.SQL Active Directory helper service not started and has startup type disabledSQL Full-text Filter Daemon Launcher (DB2) is started with startup type manualSQL Full-text Filter Daemon Launcher (MSSQLSERVER) is started with startup type manualSQL Server (MSSQLSERVER) is not started and has startup type automaticSQL Server Agent (DB2) is not started and has startup type manualSQL Server Agent (MSSQLSERVER) is not started and has startup type Manual |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
midpitts
Starting Member
12 Posts |
Posted - 2012-02-06 : 14:15:39
|
| Oh yes I have it for (DB2). It is listed as started. I made the SQL Server (MSSQLSERVER) change to started and it seems to be working properly now. Thanks!! |
|
|
|
midpitts
Starting Member
12 Posts |
Posted - 2012-02-06 : 14:23:42
|
| would it hurt anything if everything listed as SQL was started? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
logging into SQL Server 2008 management studio