SQL alias connection refused from remote system

Situation:

There is an SQL 2012 server and a view remote Server requiting Connection to to this SQL  database Server.

Problem / Error:

No connection could be made because the target machine actively refused it.

SQL Server with alias shows an error when connecting from remote server via alias name.

Local connection ist working.

Solution:

The connection is working when the sql instance is added to the alias name(aliasname\instance). Adding the instance name to the alias in sql server configuration did not help .

This entry was posted in Fix IT and tagged . Bookmark the permalink.

Comments are closed.