An error occurred while establishing a connection with the server. Provider: TCP provider, error: 0-unable to connect due to the active rejection of the target machine .)

When 2005sql is linked, the following error message is displayed:

An error occurred while establishing a connection with the server. When you connect to SQL Server 2005, the default setting does not allow remote connection to SQL Server may cause this failure. (Provider: Provided By TCPProgram, Error: 0-unable to connect because the target machine is actively rejected .)

 

Solution:

This is mainly because some SQL services are not started. You can start the SQL Server service in SQL Server Configuration Manager.