vendredi 23 janvier 2015

SSMS login fail to Linked Server


i have one server with SQL server 2012 standard on cloud environment and one linked server with sql express on remote location connected with VPN , im using transactional replication


every time when internet conection is dropped and regain on remote location, i try to connect with SSMS im getting error



"A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (Microsoft SQL Server, Error: 64)


For help, click: http://ift.tt/15loZEp


The specified network name is no longer available"



But when i test the connection in server object/linked server, the connection is ok and the replication is running


one resolution was to restart the cloud server and everything is normal i can connect to remote server via ssms, but this is no resolution for me


can somebody help me with this one





Aucun commentaire:

Enregistrer un commentaire