Linked Servers

Add Linked server and Logins !!

EXECUTE sp_addlinkedserver @server = N'BSQ-SQlxxxxx\xxxxx',

@srvproduct = '',

@provider = N'SQLOLEDB',

@datasrc = N'BSQ-SQLxxxxx\xxxxxx',

@catalog = N''

select * from sys.servers;

create logion Just for read access in Remote SERVER as SQL SERVER Authentication.

assign only db_datareader,public role and In userMapping only Databases you wanted to give access to read .

EXECUTE sp_addlinkedsrvlogin @rmtsrvname = 'BSQ-SQlxxxxx\xxxxx',

@useself = 'false',

@locallogin = 'DOMAIN\hem.p',

@rmtuser = 'HM_ReadONLY',

@rmtpassword = 'xxxx'

EXECUTE sp_droplinkedsrvlogin

@rmtsrvname = 'BSQ-SQlxxxxx\xxxxx' ,

@locallogin = 'DOMAIN\hem.p'

You can see your Linked server at SSMS-->Object Explorer --> Source sql Instance-->Server Objects --> Linked Servers.

That's It!!

Done!!

Cheers !!