locked
IDISPATCH error #3149, Login failed for user 'sa' RRS feed

  • Question

  • I have c++ application which USES ADO to connect to SQL server. Its able to connect to a database(aa_login) in one server(Lets say Server01). When I try the same code in another server(Server02) to connect to a database it fails and gives the Following error

    "IDISPATCH error #3149, Login failed for user 'sa' ".

    Could there be any problem with that server registry. Can someone please help me.

    Tuesday, February 20, 2018 9:57 AM

All replies

  • Can you login into the database where connection is failing via other login or SA using SSMS ?. Can you check SQl Server errorlog there should be more information about why actually the login failed.

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Tuesday, February 20, 2018 10:48 AM