Home Forums SQL Server 2008 SQL Server 2008 Administration Linked Server with restricted access RE: Linked Server with restricted access

  • July 9, 2013 at 3:13 am

    #1630691

    Just create the linked server connection and specify the user credentials in the code or in the "Security" page (when using the GUI).

    EXEC master.dbo.sp_addlinkedserver @server = N'{FQDN_instancename}', @srvproduct=N'SQL Server'

    EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'{FQDN_instancename}',@useself=N'False',@locallogin=NULL

    ,@rmtuser=N'{username}',@rmtpassword='########'

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **