Quick Tip: No connection could be made because the target machine actively refused it

Your users get the below error when connecting to SQL Server that has been running fine all along.

Reason:

What could be the reason? Quite simple. Check to see if the service is running and start it if it is not!

StackOverflow always has the answers for all the other kinds of configuration issues that might cause this error on a new installation but this quick tip is to ensure that you do not overlook the obvious.

Complete Error:

TITLE: Connect to Server
——————————

Cannot connect to MyBusinessServer.

——————————
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to 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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476

——————————
BUTTONS:

OK
——————————

Advertisement