SQL2005 between Vista & XP - 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

SQL Server Administration (2005)

SQL2005 between Vista & XP

Author

Topic

nice123ej
Starting Member

48 Posts

Posted - 2007-08-04 : 11:33:27

Hi
I have 2 computers
DESKTOP : runs WinXP and SQL Server 2005
NOTEBOOK : runs Windows Vista and SQL Server 2005

when i try to connect to DESKTOP from NOTEBOOK i get this error

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

Cannot connect to DESKTOP.

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

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

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

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

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

can anyone help me to fix it?!

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-04 : 20:27:52

Did you enable remote access in sql2k5 on desktop?