How to connect SQL server 2005 to Server.

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 2005 Forums

SQL Server Administration (2005)

How to connect SQL server 2005 to Server.

Author

Topic

codezero
Starting Member

3 Posts

Posted - 2009-04-18 : 13:46:50

I have Installed SQL Server 2005, Whenever I am trying to connect to server I a getting an error
"Cannot connect to servername"
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

Actually I want to know what should I put in the Server name field - My computer name or anything else. Please help as soon as possible and guide me how can I run sql server 2005 in my system.

codezero
Starting Member

3 Posts

Posted - 2009-04-18 : 23:41:38

Pease help me out..

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-04-19 : 01:20:04

Put your hostname.

Domini1116
Starting Member

3 Posts

Posted - 2009-04-20 : 15:27:00

CodeZero,
I am fairly new at this, but hope this help you somehow
Your PC name should be the name of the server. When opening SQL server, I think it should be defaulted to the PC name (In this case Pc name = Server name).
Make sure that your system has a PC name so it could be retrieved.
Are you using windows authentication or SQL Authentication?
Are you signing in to SQL Server from the server itself or connecting thru another computer on the network?

Wellingthon Gonzalez

svicky9
Posting Yak Master

232 Posts

Posted - 2009-04-21 : 07:10:20

When Installing if you have given the Instance a name then the connection will be

a. Go to start-->run--services.msc.Check the SQl server services...In the Parenthesis the Instance name should be displayed if you select named instance in the installation

below

SQL SERVER(MSSQLSERVER) --> Then Type your machine name
else
SQL SERVER(InstanceName) --> then Type MachineName/InstanceName

Hope this helps

http://www.sqlserver007.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources