SQL Server 2000 connection Problem

[shsz]

I have had MS SQL Server 2000 Developers edition installed for the last couple of years and it has been working well. I recently installed VB 2005 Express, C# 2005 Express and SQL Server 2005 Express. It installed without any problems and is working. Now my SQL 2000 Server has a connection problem as follows:

Message while trying to connect in Server Management Studio Express (2005)

An error has occurred while establishing 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 connections. (provider: TCP Provider, error 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error 10061)

Message while trying to connect to Enterprise Manager (SQL Server 2000 Developer Edition)

A coonection could not be established to SONY410.
Reason: SSL Security error
ConnectionOpen(SECDoClientHandshake()).
Please verify SQL Server is running and check your SQL Server Registration properties and try again.

The SQL Server Service Manager loads as always and is running. I made sure that all of the protocols are enabled in the SQL Server 2005 configuration manager. The same administrator login is being used thru Windows Authorization for both servers. Any help would be appreciated.

 

[SQLBill]

I'm not using 2005 yet, but I noticed this error message in your post:

this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

So, somewhere in 2005, you should be able to set the 'allow remote connections'. Since the default in 2005 is 'do not allow remote connections', maybe it reset it for your 2000 instance also.

Refer to sp_configure in the BOL. In 2000, the option is: 'remote access'.

-SQLBill



Posting advice: FAQ481-4875

 

[shsz]

Tried all suggestions - No resolution - Finally removed SQL 2000 from PC and re-installed from scratch. This fixed everything - SQL 2000 runs properly and I can access the databases thru SQL 2005 Express. Hope this might be helpful for others.

 

[Dodger67]

I am getting this also with Dev 2005. Same spot. Kinda crappy if I have to uninstall everytime I see it.