how to find sa password

[Anonymous]

Dear all

Today I need to import a library to ADMS 2011, but I forget SA password. Do you know how to find it?

[JamesMcMullen]

Have you tried the default sa "AutodeskVault@26200"?  Else, I am unsure how you can get the sa password.  You can probably reset it if you set up a mixed SQL environment.  You will probably be prompted to type it in when you do a couple operations inside ADMS Console since it would be a different password.

-Jim

[Anonymous]

as you said I try to default password, but it remain. I think somebody modiy modified it for data security. Do you give a detail solution about it. At the same time I do not know why it need to SA account after launch "import" command. In the past I did directly completed the job through administrator account, never use sa.

[JamesMcMullen]

Is it possible to get a better understanding on what you are trying to do and where the sa prompt is coming from?  Normally I see that when you try to restore a backup from a machine that had a different sa password than the one you are trying to do the restore.

-Jim

[minkd]

See <http://blog.sqlauthority.com/2009/08/04/sql-server-forgot-the-password-of-username-sa/>.

-Dave