November 23, 2010 at 9:12 am
I assume both of these SQL server instances are not named instances (they are using the default: name of the machine). Have the servers they are running on been renamed?
You stated that both servers connectivity is enabled (TCP/IP & named pipes). shared memory is useful only on the local machine (it is what SSMC will use if enabled). You have to bounce the service for any changes to take effect, hopefully you already have done this.
You have already assured me there is no routing issue so it has to be the name of the server is wrong or the server is not enabled for remote connections. Have you looked in the SQL Server log for any errors?
select * from sys.sysservers see what it thinks is going on.
The probability of survival is inversely proportional to the angle of arrival.
November 23, 2010 at 10:07 am
Thanks for the reply, I entered the query you suggested and the srvnetname, datasource and srvname are the same. IF this helps. I didn't see any error messages in the logs. There where informational messages but they didn't seem to affect this issue.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply