| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2008-07-17 : 14:52:42
|
| Can you create a Linked Server using SQL Server 2000 which references tables defined in a SQL Server 2005 database?If so, how does the security configuration work?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-17 : 15:14:01
|
| Yes you can. Try with SQL login. Make sure login exist in both server. |
 |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2008-07-18 : 07:09:43
|
| Thanks Sodeep, it worked! |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2008-07-18 : 11:51:37
|
| I was able to get a connect a SQL Server 2000 db to a SQL Server 2005 db using a Linked Server via SQL authentication. I now want to try to connect using Windows Authenticatin. Can this be done? When I try I get the following message "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.". |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-18 : 12:45:38
|
| Yes you can but Security account delegation has to be setup . |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2008-07-18 : 12:54:09
|
| Where would I look to set security delegation, in SQL Server or is this a Windows setting. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-18 : 12:58:17
|
| See this old post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59204 |
|
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2008-07-18 : 12:59:42
|
| Perfect, thanks |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-07-20 : 07:55:37
|
| Just to make sure i understood it - To use the NT accounts it is set up on the AD levelIn AD there is a setting to flag as" Security account delegation" Then just use linked server setup as normal just like sql login but use the NT login |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-20 : 22:11:56
|
| Linked server in sql2k doesn't work with windows authentication. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-20 : 22:46:06
|
quote:
Originally posted by rmiao
Linked server in sql2k doesn't work with windows authentication.
Not true. we have setup Security account delegation and it is working. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-20 : 23:01:26
|
| Good for you, but never work for me. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-21 : 08:01:14
|
| you have to setup as Tracy mentioned. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-21 : 22:51:46
|
| Tried that long time ago, no luck for me. |
|
|
|
|
Linked Server Question for SQL Server 2000