SQL Server Connection Problems

views:

101

answers:

SQL Server Connection Problems

I have one server out of three which cannot connect to our sql server 2000 using the FQDN but can connect using the non FQDN. None of the the other servers are having this problem.

This problem occurs under ADO connections to a SQL Server 2000 database.

The database has encryption turned on. I don't want to turn it off.

Does anyone have any ideas of what to look at?

Notes: You can ping or telnet to the sql server using both FQDN and non FQDN. The other two servers are working fine and all servers are on the same subnet. All the servers are running Windows 2000.

What error do you get?

Probably the certificate used to encrypt the connection (the server SSL cert, possible self signed) has the simple, non-qualified, name of the machine as subject. The client thus rejects the cert when it attempts to connect, breaking the connection.

Remus Rusanu 2009-08-13 23:13:20

Microsoft OLE DB Provider for SQLServer: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

GordyII 2009-08-13 23:32:01

Network is fine because you can connect using the NON FQDN.

GordyII 2009-08-13 23:32:38

See what certificate is that server using. http://support.microsoft.com/kb/316898/ has step-by-step procedures on how to find the used certificate (in the Troubleshooting section), as well on how to replace it.

Remus Rusanu 2009-08-13 23:40:29

The certificate is valid. If there is a certificate on the client side, can that affect the connection, or does only the certificate on the server side affect it?

GordyII 2009-08-14 00:03:04

Is valid, but who is it issued to? The **Issued To** in the certificate viewer is for the FQDN or for the simple machine name? How is this compared with the other machines where FQDN works?

Remus Rusanu 2009-08-14 00:06:09

Interesting it is registered to our domain as such. *.mine.com.All the machines are something.mine.com. All the other machines work fine and they are something1.mine.com etc.

GordyII 2009-08-14 00:15:11

Do all clients have this problem, or only one? Ie. can other clients connect to fqdn on this server?

Remus Rusanu 2009-08-14 00:23:45

ansaurus

tags:

views:

answers:

SQL Server Connection Problems

related questions