I'm trying to re-create a new subcription on my server. When I tried to connect to the the publisher server, i kept getting an error message saying "
SQL server could not retrieve the list of publication for "D..."
An exception occured while executing a transcat- SQL statement or batch. [Microsoft.sqlserver.connectionInfo}
A transport level error has occured when receiving results from the server. [Provide: TCP provide error:0 ] - The specified network name is no longer available] [Microsoft sql server, error 64)
I can ping the publisher server and also connect from my subcriber server using remote desktop. I tried connecting to the publisher server using the sa account.
Is this a permission issue?
View Complete Post