Re: Any suggestions on this error when trying to connect SQL Server 2000?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 22:06:39 +0530

Hi,

Possibilities for this error are:-

1. SQL Server service may be down or hung
2. Network issue
3. Need to create an Alias using "Client network utility" specifying IP
address and port number. Use this alias to connect.

Thanks
Hari
MCDBA

"zenDebra" <anonymous@discussions.microsoft.com> wrote in message
news:addd01c436ac$ba6088e0$a601280a@phx.gbl...
> SQL State: 08001 Native Error: 17
> State: 1 Severity: 16
> SQL Server Message: [DBNETLIB][ConnectionOpen (Connect()).]
> SQLeat Server does not exist or access denied.

Relevant Pages

  • Re: Scripting creation of server alias
    ... > Does anyone know if there's a way to script creation of a server ... > alias, as you can do using the Client Network Utility? ... Then you can use any programming tool or ...
    (microsoft.public.sqlserver.server)
  • Re: How can I tell what protocols are enabled for the client?
    ... My question is on the Client Network Utility not on the Server Network Utility. ... Based on your reply, even I have only enabled TCP/IP on the General tab of the Client Network Utility, I will still able to connect to an alias which is setup using Named Pipes on the Alias tab of the Client Network Utility. ...
    (microsoft.public.sqlserver.connect)
  • RE: Name of the SQLInstance?
    ... Try using SQL Client Network Utility and creating an alias for your instance. ... The only other way I know of is to rename you machine to 'sqllocal' - that ...
    (microsoft.public.sqlserver.programming)
  • Re: Server alias
    ... "Tom Williams" wrote in message ... > an alias for one of our servers. ... Using the same "Client Network Utility", ... > How can I get rid of it? ...
    (microsoft.public.sqlserver.server)