Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Unanswered: Retrun all rows on Any Table from EM prompts for Username/Password .. Why ?

    Hello -

    I dont know something weired happened on our MSSQL server today. We are able to connect to any Databases from Enterprise Manager from a Remote server.

    Once we logged in and connected to a database on my database server, it keep prompting for the user id and password as we browsing through different tables in that database?

    (Right click on the table then select Open Table -> Return all rows -> and it prompts for password )

    Now when we enter password the contents of Table are displayed and now when we try to see contents of another table in the database it again prompts for password.

    Any Idea whats wrong? How this can be resolved as it was not happening before ..

  2. #2
    Join Date
    Jan 2004
    Weird, I'd try changing the registration of the server in EP and see if that fixes it.

Posting Permissions

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