Cannot connect to server in sql server 2008

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

General SQL Server Forums

New to SQL Server Administration

Cannot connect to server in sql server 2008

Author

Topic

SKRL
Starting Member

1 Post

Posted - 2014-11-15 : 05:59:38

hi ,

I am new to SQL Server, I just tried to install sql server in my laptop running in WINDOWS 8.1.

I have installed from below link.
http://www.microsoft.com/en-us/download/details.aspx?id=1695

After the installation while first time to connect it,it says an error "Cant connect to SERVER NAME".

I have to install any other supporting files ? I need to do any other things?

TITLE: Connect to Server
------------------------------

Cannot connect to NEW.

------------------------------
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: 53)

Thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-15 : 13:13:10

Check if the SQL Server service is in a started state.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-15 : 13:13:55

Also, you may have it installed it as a named instance, so the name to connect with might be servername\instancename. Often times, Express edition is SQLEXPRESS, so servername\SQLEXPRESS.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources