Connecting to sql server 2000 in a lan

Hi there,

I have 2 servers on our compny'ssql server does not exist or access denied lan, one with fixed ip and the other one with internal ip. I installed SQL server 2000 on the one with internal ip and I want to access it from the other server. when I want to register sql server instanse , I can see the name of that instance in the list but I can't register it. I keep reciving this error : sql server does not exist or access denied!

Could any one told me what to do?

http://www.connectionstrings.com/

|||

Hi,

According to your problem, the following suggestion may be helpful to you.

1, Does firewall exist in your local network? Please adjust your security level of the Firewall.

2, When connecting to the db server, be sure that the SqlServer is running as well as the 1433 port is opening.

3, Have you installed service pack for your SqlServer2000? Because the port of TCP/IP and UDP is denied due to some security known issue on those edition without service pack.

Thanks.

Connecting to MSDE

I am trying to connect to a MSDE database on server from my desktop using query analyzer. I keep getting the generic "SQL Server does not exist or access denied'

I have verified the following:
- the login/password is valid because when I access osql from server I can gain access
- the registry for Loginmode appears OK - set to 2 - mixed mode

What else do I need to check...

Thanks, kgaskeDid MSDE install as a named instance? Check the service, and see if it is listed as MSSQL$foo. If it is, you connect as servername\foo.|||No MSDE is not a named instance. Checked the service..|||Can you connect to the server from the server? Maybe no network protocols were enabled.|||Can you connect to the server from the server? Maybe no network protocols were enabled.

I'll second this; what version of MSDE is it? What's the operating system. By default, MSDE 2000 installed on WXP or Win2003 will not enable IP connections. You have to install SP3 (minimum) or SP4. I also recall (from some dim memory) that by default, MSDE does not enable anything but shared memory (ie, localhost) connections.

Regards,

hmscott

connect to sql server via aps page ado :(

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

This the error message that i get when connect the sql server via asp page using ado.

the sql server is a default instance on a fail over cluster.

name pipes is enabled both on server network and at client network

any help.

--sanjayNormally, this occurs when you have not granted access to the iusr account that iis uses. Also, the following article list several other areas:

article (http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q306518&)

Let me know if you need further assistance.

Good luck.|||Originally posted by sanjay_kumar_r
Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

This the error message that i get when connect the sql server via asp page using ado.

the sql server is a default instance on a fail over cluster.

name pipes is enabled both on server network and at client network

any help.

--sanjay

Guys,

I have this same problem...

Until yesterday averything is fine but since today I receive this error message.

Any help?

What does it means: "Normally, this occurs when you have not granted access to the iusr account that iis uses"?
I have just the "sa" usar in SQL...
What I need to check?|||I found the error.

My firewall blocked the dllhost.exe .
I give the permition and everything is fine again...