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
SQL ORACLE
One Orange Chip
Points: 27807
More actions
May 28, 2008 at 2:44 pm
#821473
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.