Hi there,
Very interesting article. I was attempting to add a linked server and wanted to confirm something.
I did not create a mapped login and instead specified the remote login and password for the option "Be made using this security context".
I can connect successfully - however - when attempting to expand the "catalogs" folder, I receive the error: "Cannot obtain the schema rwoset "DBSCHEMA_CATALOGS" for OLE DB provider "SQL Server" for linked server "(null)". The provider supports the interface, but returns a failure code when it is used"
ANy ideas? I would appreciate any help.
Also, I then attempted to create a login on the SQL Server and then tried to map it - but it gave me an error "Access to the remote server is denied becuase no login-mapping exists."
I created a login on the sql server called "root" and then mapped it to the remote server with username "root" along with password - but no joy.
Any help would be appreciated.
thanks,
KS