Linked server

Question

Linked server

DBA-640728

SSChampion

Points: 12898
More actions
April 6, 2010 at 4:48 pm

#142438

hi guys, i have a sql server linked server with a couple of catalogs, my question is how do i add another catalog to this existing linked server?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Paul White SSC Guru Points: 150467 More actions · Answer 1

DBA-640728 (4/6/2010)
hi guys, i have a sql server linked server with a couple of catalogs, my question is how do i add another catalog to this existing linked server?

A 'catalog' is just another name for a database.

You can't add a new database using the linked server sub-tree in Object Explorer, you have to connect to the target server and add the database there.

Or have I misunderstood your question?

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

sanketahir1985 SSCarpal Tunnel Points: 4473 More actions · Answer 2

DBA-640728 (4/6/2010)
hi guys, i have a sql server linked server with a couple of catalogs, my question is how do i add another catalog to this existing linked server?

catalog means database only,

so simply u have to go in security pane of linked server and see which Remote login is used for linked server,

then go to the target server and give required rights on new database to this login,then u can access that new Database thru linked server.

Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......

Paul White SSC Guru Points: 150467 More actions · Answer 3

sanketahir1985 (4/6/2010)
...and give required rights on new database to this login...

Just to be clear on this: the login involved is the login used to connect Object Explorer (typically the same login specified in Registered Servers). The permission required to list the database is CONNECT at the database level. Further permissions will be required to enumerate the contents of the 'catalog'.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

NJ-DBA SSChampion Points: 13834 More actions · Answer 4

unless the linked server is configured with a specific login to use--- if you look at the properties of the linked server it will have defined the security context with which is connects to the remote server. Whatever login is being used, needs to have permissions to the databases you want to see on the remote server.

Paul White SSC Guru Points: 150467 More actions · Answer 5

NJ-DBA (4/7/2010)
unless the linked server is configured with a specific login to use--- if you look at the properties of the linked server it will have defined the security context with which is connects to the remote server. Whatever login is being used, needs to have permissions to the databases you want to see on the remote server.

True. Good point.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi