Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Connecting to linked server
- Thread starter wickedwho
- Start date
Yes you can do that:
1) add a SQL user with db_ddladmin role on the machine you want to connect to.
2) add a linked server on the sql server from where you want to connect and select the user which you use on the server to connect to the linked server (in the properties windows from the linked server you just added) and fill in the user with password you made in step 1). Don't use impersonate!!!!
Good luck, Salsa
1) add a SQL user with db_ddladmin role on the machine you want to connect to.
2) add a linked server on the sql server from where you want to connect and select the user which you use on the server to connect to the linked server (in the properties windows from the linked server you just added) and fill in the user with password you made in step 1). Don't use impersonate!!!!
Good luck, Salsa
- Thread starter
- #3
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
