Hi,
While connecting remote SQL server through upgrade advisor I am getting the below errors:
Error: Unable to connect to server. Reason: An error has occurred while establishing a 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Pls let me know if anyone has faced this issue and know how to fix.
Thanks in advance
-Shriniwas
just go to sql server surface area configuration and choose surface area configuration for services and connections then under mssqlserver-->database engine>choose remote connections and in right side page choose local and remote connections and using named pipes and tcp or 1st option with only tcp
No comments:
Post a Comment