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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Install Issue

Author  Topic 

uffan
Starting Member

3 Posts

Posted - 2010-11-22 : 16:36:54
Hi all,

I installed SQL Server 2008 on my computer but I am unable to connect to the database engine through Management Studio. In Computer Management under SQL Server Configuration Manger, SQL Server (SQLEXPRESS) is running. Is there a way I can verify that the database engine is installed correctly and that it is running?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-22 : 16:38:05
What error are you getting?

If it says that it is running, then everything should be fine.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

uffan
Starting Member

3 Posts

Posted - 2010-11-22 : 16:43:21
I am not sure how to check to see if it is running. Below is the error message it give me.

TITLE: Connect to Server
------------------------------
Cannot connect to (local).
------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to 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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-22 : 16:55:37
Try connecting with: YourHostName\SQLEXPRESS

Where YourHostName is the name of your computer (assuming that's where SQL is installed).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

uffan
Starting Member

3 Posts

Posted - 2010-11-22 : 17:16:38
Work perfect, thank you very much!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-22 : 17:30:04
You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -