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.