Results 1 to 6 of 6

Thread: linked servers

  1. #1
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Unanswered: linked servers

    I have to link servers using sql server 2000 standard edition....
    for anyone who has done this..... upon linking the servers using the other options radio button choice.... is it suppose to show all the databases for that server under the drop down....
    its only showing tables and views... which i get an error 7339 or error 17:

    can anyone assist...or lead me in the right direction.....
    thanks,
    jonathan

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    http://support.microsoft.com/kb/814398
    http://support.microsoft.com/default.aspx/kb/241267
    If you google on error 7399 you would get relevant forum posts too.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123
    I resolved the issue

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    How ?
    George
    Home | Blog

  5. #5
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123
    permissions on the standy server did not match or map to the prod box......
    under the security tab i changed the option being made using this security context to begin made using the login's current security context

  6. #6
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    ahhhh...yes.

    The ole' security issue...
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •