Endpoint Protection

 View Only
Back to discussions
Expand all | Collapse all

How to change Reporting Server password?

  • 1.  How to change Reporting Server password?

    Posted Apr 10, 2008 11:31 AM
    Hi,
     
    I have a client with SAV 10.1.7.7000 installed. No one knows the password to log in to the reporting server. I have tried all of the username/password combinations that we use.
     
    Is there a way to reset this account password?
     
    Any assistance would be greatly appreciated.
     
    Thanks, Neal...


  • 2.  RE: How to change Reporting Server password?

    Posted Apr 18, 2008 02:36 AM
     
    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


  • 3.  RE: How to change Reporting Server password?

    Posted Apr 18, 2008 10:20 AM
    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...


  • 4.  RE: How to change Reporting Server password?

    Posted Apr 18, 2008 05:13 PM
    same issue here... this sux. I found another thread:
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     
    My SAVCE 10.1.5.5000 Reporting server reports ""User name is disabled or locked" whenever I try to log on as "admin".  I've never changed the password, and no one else has access to do so either.
     
    How do I resolve this?
     
    Thanks,
    Bob. 

    Bob
     
    This is what I got from Symantec Support:

    To unlock accounts

    Log on as an administrator on the database server.

    Execute the following command from a command window:

    osql -E

    On the osql prompt enter the following lines (the first two lines end with a semicolon):

    use Reporting;

    update adminuser set Locked='' where user_name='USERNAME'; <--THIS is NOT CORRECT

    go

    exit

    Replace USERNAME with the name of the user to be unlocked.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    OK TechSupport ive tried searching for the real KB article to no avail.. Why don't you just tell us HOW TO ACTUALLY FIND THE ARTICLE??????



  • 5.  RE: How to change Reporting Server password?

    Posted Apr 21, 2008 12:06 AM
     
    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


  • 6.  RE: How to change Reporting Server password?

    Posted Apr 21, 2008 12:09 AM
    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


  • 7.  RE: How to change Reporting Server password?

    Posted Apr 22, 2008 10:57 AM
    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...


  • 8.  RE: How to change Reporting Server password?

    Posted Apr 22, 2008 11:49 PM
    Hi NEal,
     
    It doesn't matter whichever account you use for login.
     
    But i think u have forgoteen your password.
     
    If you have enter wrong username & password it will give u a message "Invalid username or password"
     
    If you enter wrong username & Pawssword for 3 attempts then it will give u a message " User account is locked."
     
    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


  • 9.  RE: How to change Reporting Server password?

    Posted Apr 24, 2008 10:22 AM
    Hi Sam,
    I believe that it is using the embedded database. How can I tell?
    Thanks, Neal...


  • 10.  RE: How to change Reporting Server password?

    Posted Apr 25, 2008 04:39 AM
    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.



  • 11.  RE: How to change Reporting Server password?

    Posted May 13, 2008 04:33 AM
    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


  • 12.  RE: How to change Reporting Server password?

    Posted May 13, 2008 04:46 AM
     
    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



  • 13.  RE: How to change Reporting Server password?

    Posted May 14, 2008 09:06 AM
    Hi Sam

    OK , i tried it , but im using SQL Server Management Studio , i log in as sa
    Expand the databases , then expand the Reporting Database
    Click on tables and then on the right hand side i right click on adminuser table and choose open table
    (i dont see a click on Return all rows option)
    I go to the password field and then change the password to 6b42f8f5d4e916f55e81c97e0eeafdb1c85fe5bb.
    Close the admin table and then click on save all

    Tried logging in and still get username disabled or locked

    Ken


  • 14.  RE: How to change Reporting Server password?

    Posted May 14, 2008 09:29 AM
     
    Hi Ken,
     
    Please let me know your PM , i will be sending you the snapshot which will help you.
     
    Rgrds,
    SAM
     
     


  • 15.  RE: How to change Reporting Server password?

    Posted May 19, 2008 06:23 AM
    Hi Sam

    Your solution worked 100% , if you have the correct Database :smileyhappy: the solution will work

    Thank you very much
    :smileyvery-happy:

    Sinisterza





  • 16.  RE: How to change Reporting Server password?

    Posted May 22, 2008 03:35 AM
    Hi Sam,
     
    Perfect 100% works for me.
     

    Appreciate for your great support.



  • 17.  RE: How to change Reporting Server password?

    Posted Jun 15, 2008 10:11 PM
    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.
     


  • 18.  RE: How to change Reporting Server password?

    Posted Aug 07, 2008 12:08 PM

    We have an MSDE setup for our reporting server and I tried the method listed at the bottom of the first page, seemed to work however I still get the error "User name is disabled or locked" when I try to login.

     

    Any other things I can try besides removing and re-installing the reporting component?

     

    Thank you
    Gary

     

    EDIT

     

    I went back and re-read all the info, realised I had the answer all along and was able to reset the locked status!  Thanks to all for the information contained herein, it has been a real life saver!!!

    Message Edited by MisterV on 08-07-2008 09:23 AM


  • 19.  RE: How to change Reporting Server password?

    Posted Aug 26, 2008 09:39 AM

    For those of you with a locked out problem, and are running MSDE.

     

    Just do as mentioned earlier in the thread to get the username, if also needed reset the password.

     

    To unlock the account just write the following syntax in a command prompt, where you replace <password> and <username> The result .txt is just there for you to verify that it was successful.

     

    osql -U sa -P <password> -Q "use reporting update adminuser set locked='off' where user_name = '<user name>'" -o result.txt

     

     

    Good luck