connection issue - SQL Server Forums

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

Express Edition and Compact Edition (2005)

connection issue

Author

Topic

Jon.key
Starting Member

5 Posts

Posted - 2007-09-10 : 18:25:26

I am running SQL Express on server 2003.
there are 5 PC that connect to a database
but only 2 can connect and the other 3 are saying that the database does not exist I can ping the server name fine.
I have tried sql server managment studio on the 3 pc and still can not connect

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-10 : 19:12:25

Please post the exact error messages.

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

Jon.key
Starting Member

5 Posts

Posted - 2007-09-10 : 19:19:34

Cannot connect to SERVER\SQLEXPRESS.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-10 : 19:27:24

I am not familiar with that error. Is that what you are getting when you attempt to connect to SERVER\SQLEXPRESS from Management Studio?

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

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-09-10 : 19:30:36

quote:
Originally posted by Jon.key

Cannot connect to SERVER\SQLEXPRESS.

that does not look like it is the exact error message.

-ec

Jon.key
Starting Member

5 Posts

Posted - 2007-09-10 : 20:04:44

I can see the database when I browse from the manager i can see the instance but when I click server\sqlexpress I get this

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

Cannot connect to SERVER\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-10 : 22:35:23

Do you use same protocol to connect to sql server on all 5 PCs? Can you ping the server from those 3 PCs?

Jon.key
Starting Member

5 Posts

Posted - 2007-09-10 : 22:56:28

I can ping the server and I can view the C$ on the server
all the PC use the same protocals

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-10 : 23:08:06

Tcp/ip? Specified correct port number? Can you post connection string used?

Jon.key
Starting Member

5 Posts

Posted - 2007-09-11 : 10:22:34

The Port is 1433 and I am new to SQL so I do not know the connection string.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-11 : 11:45:49

Try connecting with SERVER\SQLEXPRESS,1433 as the server name on the clients that are getting this error.

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

MassiveOverkill
Starting Member

20 Posts

Posted - 2007-09-21 : 06:58:45

Is the firewall on the other PC's that cannot connect. Is SQL Browser running on the them? Do you have TCP/IP and/or named pipes enabled on those PC's in Management Studio Express? Have you tried connecting via IP name/instance as well as NetBIOSname/instance?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources