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