Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wisertime
Starting Member
28 Posts |
 Posted - 2008-08-26 : 17:34:15
|
| I am scripting out all of my linked servers on a 2000 system to a 2005 system. While testing I noticed that it creates the link fine but under security it is setting the connections not defined to be made "using the login's current security context", rather than bringing over the explicit remote login that is specified on the source link. Is there a way to do this. I have just been scripting it out, but is there a gui or something? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-26 : 19:01:34
|
| Can't you map to the login you like to use? http://www.codeproject.com/KB/database/ScriptLinkedServers.aspx |
 |
|
|
wisertime
Starting Member
28 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-26 : 20:07:34
|
| Transfer that login to SQL 2005 and try if it works. |
|
|
|
wisertime
Starting Member
28 Posts |
Posted - 2008-08-26 : 20:13:18
|
Its an Oracle login. It connects to a linked Oracle view. I think that it's just not possible to do from 2000 to 2005. I'll have to ask around until I find someone who knows the password.quote:
Originally posted by sodeep
Transfer that login to SQL 2005 and try if it works.
|
|
|
|
|
|
|
Scripting out Linked servers