title: Create a Linked Server Using a Windows Account in SQL Server
body: <p>There are multiple applications on SQL Server which I am trying to connect to from a Single SQL Server. Instead of creating multiple SQL User ID we thought of creating a single Windows Service Account and use that to connect to other SQL Servers. </p>
  
  <p>The issue is I dont know if I can configure a Linked Server to take the credentials of a Windows Service account.</p>
  
  <p>Points: </p>
  
  <ol>
  <li>Access has been given to the Windows user account</li>
  <li>SQL Servers are on Different domains</li>
  </ol>
  
  <p>Is there a best approach to read from multiple sources within the organization other than linked servers?</p>
  
  <p>Update:</p>
  
  <p>Please find below code I am trying to use to create a Linked Server:</p>
  
  <pre><code>USE [master]
  GO
  
  EXEC sp_addlinkedserver     
       @server=N'serverinstance',   
       @srvproduct=N'',  
       @provider=N'SQLNCLI',   
       @datasrc=N'serverinstance.domain.local'; 
  
  GO
  
  EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'serverinstance'
                                  , @useself = N'TRUE'
                                  , @locallogin = N'Domain\NTAccount' 
                                --, @rmtuser = N'user'
                                --, @rmtpassword = N'pass'
  GO
  </code></pre>
  
  <p>The linked server still fails. I do not want to use any SQL Server User Auth. </p>