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 |
|
eashoori
Starting Member
22 Posts |
 Posted - 2009-01-15 : 18:24:56
|
| Hi everyone,We have Server A, Production server, Physical box (SQL 2005)Server B, Production server, Physical box (SQL 2000)Server C, test server, virtual (mirror image of Server A, SQL 2005)Server A is nicely connected (linked server) to server B with credentials. Server C which is supposed to be mirror image, doesn't create the linked server using the same .Is it because of DNS, distribited transaction coordinator, active directory, kerberos? What should I or our system engineers be looking for?ANY IDEA will be greatly appreciated. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 18:29:23
|
| Its due to Security Account Delegation.Search for it. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
eashoori
Starting Member
22 Posts |
Posted - 2009-01-15 : 18:38:28
|
| sodeep and tkizer thanks for the information, where should I be looking for security account delegation? Is that in Active Directory? I As for the error, it is listed under the linked server but has no catalog and table. also once try to query second server, it gives back error that it is not connected to db |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
eashoori
Starting Member
22 Posts |
Posted - 2009-01-15 : 18:47:44
|
| sorry, the developer had go to meeting on the server and tried to query, now I don't have it with me. what is strange is that I can't create a linked server either from or to this server. Does it have anything to do with it being VM? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Can't create Liked Server in SQL5K?