Post reply

Login failed for user 'sa'

  • July 5, 2009 at 10:00 pm

    #103778

    Hi everyone,

    I have a problem which I cannot update data in the table, a publication of transactional replication, at subscriber even thought i have a right as a owner of the Database sql server 2000. It shows a message "login failed for user 'sa'". 🙁

    Please kindly help me to give your solution in this problem.

    From Phalla

  • July 7, 2009 at 2:24 am

    #1020918

    Hi, you could try to reset the password for the user sa. Look for the auth mode in SQL Server, must be mixed mode for SQL and Windows users.

    If you connect throw several SQL servers then you could test the user you are using for it. You could connect with the management studio console to your servers with the sa user, if the connection is ok then your statements must work.

  • July 24, 2009 at 2:11 am

    #1029512

    hi

    don't use the uid and password,

    pls insert the

    Integrated Security=True"

    Regards

    Vicky

  • July 29, 2009 at 5:38 am

    #1031558

    Can you check which account your agent is using to connect to the subscriber. This will be under Configure Publisher,Subscriber,Distirbution ...under Tools

    Regards

    Graeme

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

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