EXEC sp_addlinkedserver @server='alias', --the name of the linked server
@srvproduct='',
@provider='SQLNCLI',
@datasrc='.',--the data source
@provstr='Integrated Security=SSPI';
The other suggestions I found, used the same approach, but with a different provider. SQLNCLI worked for me.
No comments:
Post a Comment