linked servers in MS SQL

EXEC sp_addlinkedserver @server='LKSRV_SYS', @srvproduct = 'SQLServer OLEDB Provider', @provider = 'SQLOLEDB', @datasrc ='SERVERNAMEHERE'
EXEC sp_addlinkedsrvlogin 'LKSRV_SYS', 'False', 'sa', 'sa', 'SA PASSWORD HERE'
GO

And if you get any errors running the above, because users are associated with the linked server then run this:
sp_dropserver 'LKSRV_SYS', 'droplogins'

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.