Hi Neal,
No Issue.
By default MSDE database gets installed, unless and until you might have not installed Microsoft SQL server 2000/2005.
You can check for the same. Go to Start> Program> Microsoft SQL Server. If you see the same then the machine will be having MS SQL 2000/2005 or it will be having MSDE.
Below is the step to reset the password.
Try out and it I am sure it will work.
Good Luck :smileywink:
Reset the password with the osql command
If the reporting database is a MSDE database, you can use the osql command
To reset the password with the osql command.
On the computer that runs the MSDE database, at a command prompt, type the following command:
osql -U sa -P password -Q "use reporting select user_name from adminuser" -o user_names.txt
where password is the password for the sa user account.
Open the user_names.txt file in a plaintext editor, such as Notepad.
Find the user whose password needs to be reset.
To reset the password, at a command prompt, type the following command:
osql -U sa -P password -Q "use reporting UPDATE adminuser SET password = '6b42f8f5d4e916f55e81c97e0eeafdb1c85fe5bb' WHERE user_name = '<user name>'"
where <user name> is the user name.
Log on to the reporting server with the user name and a password of resetme123.
When prompted, change the password.