To add server using sp_addlinkedserver
I tried to insert values from one server to another server and I got the error:
Msg 7202, Level 11, State 2, Line 1 Could not find server 'SNRJDI\SLAMANAGEMENT' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Solution 1:
I got it. It worked fine
Thank you for your help:
EXEC sp_addlinkedserver @server='Servername'
EXEC sp_addlinkedsrvlogin 'Servername', 'false', NULL, 'username', 'password@123'
Solution 2:
Add the linked server first with
exec sp_addlinkedserver
@server = 'SNRJDI\SLAMANAGEMENT',
@srvproduct=N'',
@provider=N'SQLNCLI'
See http://msdn.microsoft.com/en-us/library/ms190479.aspx