Endpoint Protection

 View Only

  • 1.  User name is disabled or locked

    Posted May 27, 2009 11:34 PM
    I have "Symantec Coprate V10.1.5.500" when i try to make a report
    give me massage "User name is disabled or locked" whenever I try to log on as "admin".
    how can i solve this problem?


    Thanks


  • 2.  RE: User name is disabled or locked

    Posted May 28, 2009 01:19 AM
    Are you still able to log on to the System Center?


  • 3.  RE: User name is disabled or locked

    Broadcom Employee
    Posted May 28, 2009 01:23 AM
    Hi,
    not sure if you are facing the error while you login into ssc or the reporting server?

    if its SSC , you can use the iforgot.exe ( available in tools folder of symantec - under orogram files to reset it).

    for reporting server, i'm sure there is somewhere mentioned in the forum, at this moment i'm unable to find the one.


    Cheers
    Pete! 


  • 4.  RE: User name is disabled or locked

    Posted May 28, 2009 01:26 AM
    For the Reporting Server, I think you can change that through the database. I'm not sure about this. :(


  • 5.  RE: User name is disabled or locked

    Broadcom Employee
    Posted May 28, 2009 01:29 AM
    gosh, i found it on forum, which has worked


    https://www-secure.symantec.com/connect/forums/how-change-reporting-server-password

    *************

    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.

    ***************
    hope it works for you as well :-0

    Cheers
    Pete!


  • 6.  RE: User name is disabled or locked



  • 7.  RE: User name is disabled or locked

    Posted May 30, 2009 10:55 AM
    i can to logon to System Center, but when i try to logon to reporting server give me this massage "User name is disabled or locked"

    Thanks all


  • 8.  RE: User name is disabled or locked

    Broadcom Employee
    Posted May 30, 2009 02:18 PM
    did ya follow these steps?


    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.



  • 9.  RE: User name is disabled or locked

    Posted May 30, 2009 03:53 PM
     To change the password from the command line on MSSQL Server or MSDE: for reporting server 

    Open a command shell by selecting "Start"-->"Run...", and typing "cmd.exe" in the "Run" dialog box.
    Change to the directory in which the MSSQL or MSDE utilities are stored (this is ususally C:\MSDE\binn, C:\MSSQL7\binn, etc., but YMMV).
    Issue the following command where <newpassword> is the password you have chosen:
    osql -U sa -P "" -Q "sp_password NULL,<newpassword>,sa"
    I've had several instances where I needed to reset the sa password and this has saved the day every time.

    https://www-secure.symantec.com/connect/forums/symantec-system-center-reporting-server-password-issues