Hi to all
I have MSVS2005 DVD pack in which i have SQL Server upgradable
pack.While i trying to upgrade my SQL Server2000 TO 2005 i'm getting
error like "Unable connect to server. Reason: 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 ".But i'm sure about
this error message that i used appropriate instance and server.But i
cant able to install.So kindly tell me to go a head

RE: Help me out by NoSpamMgbworld

NoSpamMgbworld
Fri Feb 03 08:48:49 CST 2006

1. SQL Server 2005 install more secure. Open the configuration tool and turn
on TCP/IP or named pipes (or both). On a production machine you will want to
think this through a bit more, but this is good for development.

2. If you are getting at the computer remotely, you may also need to turn on
the SQL Browser service.

Follow those 2 and you should be fine.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************


"Anniyan" wrote:

> Hi to all
> I have MSVS2005 DVD pack in which i have SQL Server upgradable
> pack.While i trying to upgrade my SQL Server2000 TO 2005 i'm getting
> error like "Unable connect to server. Reason: 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 ".But i'm sure about
> this error message that i used appropriate instance and server.But i
> cant able to install.So kindly tell me to go a head
>
>