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

  • May 28, 2008 at 6:35 am

    #821130

    SQL ORACLE (5/27/2008)

    Since your three servers are in the same domain, you can use a domain account to link across each other among these three servers. You cannot use an SQL Server account to link Server 1.

    Thanks for the response! Can you help me further, though? I'm trying to figure out EXACTLY how to set that up using linked servers and what criteria needs to be met for the domain account? For instance, does account delegation need to be enabled for this to occur? And do you know any specifics on how the linked server setup would be configured (via enterprise or SQL code)?