Help me out

3 Feb 2006 11:34 AM

Anniyan

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

3 Feb 2006 2:48 PM

Cowboy (Gregory A. Beamer) - MVP

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!
***************************

Show quote

"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
>
>