Post reply

Linked server mix security same network

  • March 21, 2006 at 9:13 am

    #167348

    Hi all,

    I have set up two SQL 2000 servers A and B.

    They are both in the same network.

    IP A : 10.5.85.129

    IP B : 10.5.85.65

    Both their security mode is Mixed and both have an 'sa' user with a blank password.

    I add linked server B to server A setting the security to user 'sa' and vice versa.

    However, if I try to run a query in query analyzer from server A on server B like 'select * from B.DB.dbo.tbl_test' I get the above error.

    When I look on the internet, I always find that my security mode should be mixed but that is the case.

    Both servers run W2003.

    It seems that I have a security problem somewhere but I can't find what I do wrong.

    Urgent help please. Thanks.

  • March 21, 2006 at 9:28 am

    #627917

    Hello Tom,

    Please go through the Books Online for this topic

    linked servers, security

    Thanks and have a nice day!!!


    Lucky

  • March 21, 2006 at 10:07 am

    #627933

    also check this one out

    http://support.microsoft.com/kb/839279

  • March 22, 2006 at 2:15 am

    #628029

    Hi Tom

    I hope you resolve your problem, but in the meantime you really really should have a password on those sa accounts.  The spida and sasser worms - amongst others - exploit that vulnerability.

    Cath

  • March 22, 2006 at 11:45 am

    #628178

    Could not find your error

    Tom

Viewing 5 posts - 1 through 4 (of 4 total)

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