• Thank you. The Browser service is running as started and on automatic on remote server called Server1. I have changed the name to just server1 but i get the below error a slightly shorter one though.

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Program Location:

    at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

    at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd)

    at Microsoft.SqlServer.Management.Smo.LinkedServer.TestConnection()

    at Microsoft.SqlServer.Management.SqlManagerUI.LinkedServerProperties.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult)

    ===================================

    Login failed for user 'xxxxxxxxx'. (.Net SqlClient Data Provider)