We help IT Professionals succeed at work.

Linked Server: Database not in catalog

425 Views
Last Modified: 2012-08-13
A database isn't showing up in the catalog of a linked server.  I've checked and the user set up in the linked server connection is a member of the datareader role and has view schema rights to that db.  What else can/should I check?  I've ran into this before but can't remember what I did to fix it.  

This is a 2008 to 2008 server.
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.