Groups | Blog | Home
all groups > sql server clients > september 2007 >

sql server clients : SQL Server 2005 Client on Windows XP


Rogers
9/6/2007 3:15:33 AM
I have a SQL Server 2005 Client on Windows XP and tried to connect SQL
Server 2005 it connect perfactly fine. I also have a SQL Server 2005 into
Windows 2000 and when I tried to connect from Windows 2000 to Database
Server, it gave me connection error. I don't know why its not giving me
through XP box. I also installed MDAC 2.8 but didn't get through.

Please advice

Rogers
9/6/2007 4:09:52 AM
TITLE: Connect to Server
------------------------------

Cannot connect to ISTCL-VSERVER\ISTCLSQL05.

------------------------------
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: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 1326)

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

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

OK
------------------------------

[quoted text, click to view]

Rogers
9/6/2007 4:50:52 AM
Same connection string I am using in XP box it works but not in Windows
2003.

[quoted text, click to view]

Ekrem_Önsoy
9/6/2007 10:44:46 PM
What's the error message and its EventID if possible.

--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT



[quoted text, click to view]
Ekrem_Önsoy
9/6/2007 11:27:09 PM
From this message all I can say you should check your connection string.

--
Ekrem Önsoy
MCBDA, MCTS: SQL Server 2005, MCSD.Net, MCSE, MCT



[quoted text, click to view]
AddThis Social Bookmark Button