Hello,

Make sure you have the rights to access the remote server or the server you are trying to linked. You also should consider creating login for the linked server.

Query Format:

-- Create Linked server

EXEC master.dbo.sp_addlinkedserver

@server = N'Server Name',

@srvproduct=N'SQL Server'

-- Create Login for the linked server

EXEC master.dbo.sp_addlinkedsrvlogin

@rmtsrvname=N'Server Name',

@useself=N'False',

@locallogin=N'Local User Name',

@rmtuser=N'Remote User Name',

@rmtpassword='Remote Password'

Let me know if you still having problem with this.