Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've configured SPNs and delegation on a ServerA and ServerB. I'm trying to connect from my workstation using SSMS to run a query on ServerA that uses LinkedServerB (pointing to ServerB). I'm trying to accomplish this using "Be made using the login's current security context", so that the current logged in user can connect to SSMS, run a query on ServerA that incorporates ServerB. I understand Kerberos has to be used to run queries that require double hops in this scenario.

The linked server created successfully, but when I expand the catalogs of LinkedServerB, instead of showing the catalogs of ServerB, it shows the catalogs of ServerA.

Does anyone have any idea what could be going on for my LinkedServerB to be showing ServerA's catalogs instead of ServerB's? Please let me know if I can clarify anything.

share

migration rejected from stackoverflow.com Sep 27 '13 at 13:28

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Max Vernon, dezso, Paul White, bluefeet, RolandoMySQLDBA Sep 27 '13 at 13:28

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, dezso, Paul White, bluefeet, RolandoMySQLDBA
If this question can be reworded to fit the rules in the help center, please edit the question.

    
Is the servername correctly specified in LinkedServerB setup to be ServerB ? There is no way that SQL Server would show ServerA's catalogs when you specify ServerB. –  Kin Jun 26 '13 at 13:06
    
No other DBA on my team has seen this behavior before but they've all verified it. I wish I could post a screenshot, but I'd have to censor all server and database names. –  lush Jun 26 '13 at 16:53