Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Unanswered: Login Failed in Enterprise Manger for SQL 6.5

    When I try to access my SQL Server instance from Enterprise Manager, it always gives a login failed error. The instance is running and applications that use databases host on the instance run with no problems. I just can't administer the existing databases or users. I am running the Enterprise Manager on the same machine that the instance is running on so I don't believe it is a connectivity issue. Please help.

  2. #2
    Join Date
    Mar 2003
    Location
    Reading, UK
    Posts
    70

    Re: Login Failed in Enterprise Manger for SQL 6.5

    check whether u r seeing the correct db r not
    if correct then edit ur sql server registeration
    login with sa/pwd and then check it.

  3. #3
    Join Date
    Mar 2003
    Posts
    2

    Re: Login Failed in Enterprise Manger for SQL 6.5

    Originally posted by pavan_kashyap
    check whether u r seeing the correct db r not
    if correct then edit ur sql server registeration
    login with sa/pwd and then check it.
    When I try to to edit the registration it still fails to connect. I have not changed the sa password. Even when I try to connect using Security Manager the login fails with the sa login.

Posting Permissions

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