Post reply

Link server under different domain using SQL server 2000.

  • November 12, 2007 at 1:04 am

    #179263

    Hi,

    I am trying to configured Link server under different domain using SQL server 2000.

    The server S1 Located at X country and S2 Located at Y country. (S1 is main Server)

    I tried DSN connection, which is working fine.

    From Enterprise Manager of S1, I could able to fetch query of S2. But when I am configuring for Link server, I am not able to display the objects of S2 such as tables, views.

    I am getting “Error 17: SQL Server does not exit or access denied”

    Is there any firewall issue for privileges?

  • November 16, 2007 at 2:41 am

    #751746

    i have server located in diffrent country and create linked server within the server.

    I make sure

    1. firewall is open for port 1433, 1434

    2. user have permission to connect to other server..

    Cheers

  • November 16, 2007 at 3:06 am

    #751755

    I hope you are trying to use the option

    "Use current security context" which you fail if you are using a windows account. the best option is to use the security co0ntext with user credentials already provided.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 3 posts - 1 through 2 (of 2 total)

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