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 .. :(Weird, I'd try changing the registration of the server in EP and see if that fixes it.

Retrieving SA password

The people who originally setup the databases on our server have left and didn't pass on the password for the SA username. Is there anyway of extracting the SA password if I have access to SQL Server Enterprise Manager? I want to avoid resetting the password otherwise I the existing programs that rely upon that login name may not function problem. If anyone has any ideas I'm willing to give it a go.

Thanks.Howdy

Firstly - its not good practice - as you have just found - to have sa running any apps - you should change them asap to use another user ID ( and then you wont have this problem again ;-) , but I suspect I am now preaching to the converted....).

Check this out...

http://www.nextgenss.com/products/sqlcrack.htm

Cheers,

SG

Retrieve password for sa

Is it possible to retrieve the password for sa?
ThanksNo, you can only change it (See sp_password in the BOL)
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:A96AA25C-847F-4596-8D91-DA862A8708B0@.microsoft.com...
> Is it possible to retrieve the password for sa?
> Thanks

Retrieve password for sa

Is it possible to retrieve the password for sa?
ThanksNo, you can only change it (See sp_password in the BOL)
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:A96AA25C-847F-4596-8D91-DA862A8708B0@.microsoft.com...
> Is it possible to retrieve the password for sa?
> Thanks