Home Forums SQL Server 7,2000 Security Linked server setup issue - Windows Authentication Configured SQl 2000 server to Mixed Authentication Configured SQL 2000 Server RE: Linked server setup issue - Windows Authentication Configured SQl 2000 server to Mixed Authentication Configured SQL 2000 Server

  • Here is the outline of the setup

    1. Create a domain account (You may ask your windows team to create it in the Active Directory);

    2. Grant necessary permissions in these three SQL Servers;

    3. Use sp_addlinkedserver to build the link between servers.