Hi Neal,

 

Login to the reporting server with Admin, go to the the admin tab on the top.

 

Select the User administration and there you can change the password.

 

:smileyhappy:

 

Rgrds,

SAM

Hi Sam,

 

Thanks for the info, I have tried to login to the reporting server with the Admin account with a blank password but this does not work. The message is "Invalid user name or password".

 

What can I try next.

 

Thanks, Neal...

same issue here... this sux. I found another thread:

 

 

Hi Neal,

 

I think you have forgotten the Username & PAssword for admin login..

 

Further, can you please let me know are you using Microsoft SQL server 2000/2005 or embedded database.

 

If you are using Ms SQL 2000/2005 then it is very easy to reset the password rather then for embedded Database.

 

Do let me know the above details.

 

Rgrds,

SAM

Hi ExShire,

 

In your case you have login either with wrong username o password for 3 attempts, hence you are getting the issue.

 

Do you remember your admin password or not.

 

If you have remember then it will be much more easy to reset the login attempt.

 

Also let me know whether you are using MS SQL 2000 / 2005 or Embedded database.

 

Do let me know with the above details.

 

Rgrds,

SAM

Hi Sam,

 

I did manage to get in by using "Admin" and the password that I use for the Windows Administrator account. I then added a new admin account for "administrator".

 

There is something strange happening, I logged out of Reporting Services and then tried to log back in but was unable to get in with either account. It seems to be hit and miss as to when I can actually log in. If I try again the next day I can get in but sometimes it takes several attempts.

 

Not sure what is going on.

 

Any thoughts?

 

Thanks, Neal...

Hi Sam,

I believe that it is using the embedded database. How can I tell?

Thanks, Neal...

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.

Hi Sam

 

Im having the same problem , i ran the command as you suggested and it comes up as 0 rows affected , We also went into Sql server 2005 manager and reset the password in the password field and we are still unable to log in. Still comes up as username disabled or locked.

Do have anything else we can try ?

 

Ken

 

HI Dude,

 

Please go through the below steps to reset the password from Micorosft SQL server 2005.

 

Also you must install Microsoft SQL server Management studio before going to the below steps...

 

Reset the password in Microsoft SQL Server Enterprise Manager

If you use Microsoft SQL Server for the reporting database, you can reset user passwords in Microsoft SQL Server Enterprise Manager.

To reset the password in Microsoft SQL Server Enterprise Manager

1)<SCRIPT></SCRIPT>        In Microsoft SQL Server Enterprise Manager, expand the server that runs Reporting Server.

2)       Expand Databases.

3)       Expand Reporting.

4)       Click Tables.

5)       In the right pane, right click on the adminuser table, click <SCRIPT></SCRIPT> Open Table and then click Return all rows.

6)       Find the user in the user_name table whose password needs to be reset.

7)       Replace the existing string in the password table with 6b42f8f5d4e916f55e81c97e0eeafdb1c85fe5bb.

8)       Close the adminuser table

9)       Click on File and Save and close the window.

10)       Log on to the reporting server with the name and password of resetme123.

11)   When prompted, change the password.

I tried the same for 8-9 times and it works for me everytime..:smileywink:

Do let me know how it goes..

Rgrds,

SAM

 

Hi Ken,

 

Please let me know your PM , i will be sending you the snapshot which will help you.

 

Rgrds,

SAM

 

 

Hi Sam,

 

Perfect 100% works for me.

 

Appreciate for your great support.

None of the fixes that we tried worked, ones that we found here, on Google, ExpertsExchange, etc.  

 

There is no way that we found to "reset" the password once the admin account had been locked out, unless the individual users had adminstrator access to the dashboard.

 

So we ended up uninstalling and reinstalling the System Centre and the Reporting services.  Then we created individual accounts for each person who was going to be accessing the reporting dashboard.  Then only used the Admin account unlock individual accounts.  We actually had this happen more than once so the decision was made not to use the (built-in) admin account for reporting dashboard access anymore.   You can give the individual users admin access. 

 

Hope that this helps.