Announcement

Collapse
No announcement yet.

Account Reset Console Database Not Available

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Account Reset Console Database Not Available

    Account Reset Console Database Not Available

    Rev: 2
    Date: 09/10/2007

    Problem

    When attempting to open or log into Account Reset Console you receive the following error:

    Account Reset Console Error: Database Not Available
    The Account Reset Console could not access the log database.
    Please notify your system administrator of this error.
    Cause

    Account Reset Console cannot access the SQL database that it is configured to use for logging. This can be because:
    • The database server is down
    • The database server is not accepting network connections
    • Your SQL database is not configured to accept SQL authentication
    • The SQL account used to access the database is locked out
    • The SQL account used to access the logging database has had its password changed and ARC was not updated


    Resolution

    The database server is down:

    Check that the machine running your SQL database is running and that the SQL services are started.
    To check if the SQL services are started in MSDE/SQL 2000:
    1. Open the Services snap-in by opening Services from the Administrative Tools or by typing Services.msc at the RUN menu.
    2. Check that the service called “MSSQLSERVER” (“MSSQL$InstanceName” if using a named instance) is started.


    To check if the SQL services are started in SQL Express/SQL 2005:
    1. Open the Services snap-in by opening Services from the Administrative Tools or by typing Services.msc at the RUN menu.
    2. Check that the service called “SQL Server” (“SQL Server (InstanceName)” if using a named instance) is started.

    The database server is not accepting network connections:

    This applies to installations where the database is on a separate machine than the one running the web application.
    To check if the SQL server is accepting network connections in SQL 2000:
    1. Open the “SQL Server Client Network Utility” from the “Microsoft SQL Server” folder on your [All] Programs menu (available with full installations of SQL 2000).
    2. Be sure to choose the correct SQL instance from the “Instances on this server” drop down list.
    3. Verify that TCP/IP and Named Pipes are listed in the “Enabled protocols by order:” list control box. If they are not, select them form the “Disabled protocols:” list box and click “Enable”.


    4. Click OK once you have added the protocols.
    5. Restart your SQL instance by restarting the service called “MSSQLSERVER” (“MSSQL$InstanceName” if using a named instance).


    To check if the SQL server is accepting network connections in MSDE:
    1. Navigate to “C:\Program Files\Microsoft SQL Server\80\Tools\Binn” (the path will be C:\Program Files\Microsoft SQL Server\{InstanceName}\Tools\Binn if using a named instance) and run SVRNETCN.EXE to use the “SQL Server Client Network Utility”
    2. Be sure to choose the correct SQL instance from the “Instances on this server” drop down list.
    3. Verify that TCP/IP and Named Pipes are listed in the “Enabled protocols by order:” list control box. If they are not, select them form the “Disabled protocols:” list box and click “Enable”.


    4. Click OK once you have added the protocols.
    5. Restart your SQL instance by restarting the service called “MSSQLSERVER” (“MSSQL$InstanceName” if using a named instance).


    To check if the SQL server is accepting network connections in SQLExpress/SQL 2005:
    1. Open the “SQL Server Configuration Manager” from [All] Programs | SQL Server 2005 | Configuration Tools.
    2. Expand “SQL Server 2005 Network Configuration” and select “Protocols for {InstanceName}” where InstanceName is the name of the instance you should be connecting to.
    3. Verify that “Named Pipes” and “TCP/IP” are enabled. If they are not, right-click on the protocols and select the option to ENABLE them.


    4. Select “SQL Server 2005 Services” from the left pane. If you made changes in step 3 you will need to [re]start your SQL services for this instance, otherwise validate the following services are running and their startup type is set to automatic:
    5. “SQL Server” or “SQL Server (InstanceName)”
    6. “SQL Server Browser”


    Your SQL database is not configured to accept SQL authentication
    Account Reset Console uses SQL authentication as its sole means of database authentication. This means if you did not configure your database to allow for mixed mode authentication (both Windows integrated and SQL authentication) then Account Reset Console will be unable to connect to your database.

    Configure your SQL 2000 database to use mixed mode authentication:
    1. Open “SQL Server Enterprise Manager” by navigating to [All] Programs | Microsoft SQL Server.
    2. In SQL Server Enterprise Manager, go to the properties of your SQL server.
    3. On the SECURITY tab, in the “Authentication” area, select to allow both “SQL Server and Windows”.


    4. Click OK.
    5. Right-click on your server in the left pane and choose STOP from the context menu.
    6. After the SQL service has stopped, right-click your server in the left pane and choose START from the context menu.


    Configure your MSDE database to use mixed mode authentication:

    Warning: Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Lieberman Software cannot guarantee that these problems can be solved. Modify the registry at your own risk.
    1. Open regedit.
    2. Modify the value of the LoginMode from 1 to 2.
      • If you installed MSDE as the default instance, the LoginMode subkey is located here: HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlServer\ LoginMode
      • If you installed MSDE as the default instance, the LoginMode subkey is located here: HKEY_LOCAL_MACHINE\Software\Microsoft\{InstanceNam e}\MSSqlServer\LoginMode
    3. Restart your SQL instance by restarting the service called “MSSQLSERVER” (“MSSQL$InstanceName” if using a named instance) and “SQLSERVERAgent”.


    Configure your SQLExpress/SQL 2005 database to use mixed mode authentication:
    1. Open “SQL Server Management Studio” by navigating to [All] Programs | Microsoft SQL Server.

      Note: If you are using SQL Express, SQL Server Management Studio Express will need to be downloaded from Microsoft’s download site, http://www.microsoft.com/downloads.

    2. Choose the correct instance from the “Server Name” drop down list and login to the management studio.
    3. Right-click your server from the left pane and choose properties.
    4. Click the SECURITY link. In the “Server Authentication” area, select to allow “SQL Server and Windows Authentication Mode”.


    5. Click OK.
    6. Right-click on your server in the left pane and choose RESTART from the context menu.

    The SQL account used to access the database is locked out
    Account Reset Console uses SQL authentication as its sole means of database authentication. This means the account used to access the database is only valid in the SQL Server security context not Windows.

    In SQLExpress/SQL 2005, these accounts can be locked out.
    1. Open “SQL Server Management Studio” by navigating to [All] Programs | Microsoft SQL Server.

      Note: If you are using SQL Express, SQL Server Management Studio Express will need to be downloaded from Microsoft’s download site, http://www.microsoft.com/downloads.

    2. Choose the correct instance from the “Server Name” drop down list and login to the management studio.
    3. Under your server, expand SECURITY | LOGINS.
    4. In the details pain (right side), open the properties of the account you have configured in Account Reset Console to access your database.
    5. In the General area, ensure that “User must change password at next login” is NOT selected.
    6. In the Status area, ensure that “Permission to database engine” is set to GRANT.
    7. In the Status area, ensure that “Login” is set to ENABLED.
    8. In the Status area, ensure that “SQL Server Authentication” is NOT Login is locked out.


    9. Click OK to close the user properties. There is no need to restart the database for these changes.

    The SQL account used to access the logging database has had its password changed and ARC was not updated
    Typically, changes to these SQL accounts will not cause Account Reset Console to stop functioning. You would simply log in, update the data source configuration within Account Reset Console and move on.

    However, if the database that is used for logging is changed in SQL before it can be updated in Account Reset Console, you will be unable to log into the website. This behavior is by design as Account Reset Console would be unable to log any actions taken within the tool without this database.

    You have two choices for how to fix this:
    • Reset the password for the account in SQL back to the old value
    • Use Account Reset Console’s Arc Admin Console to update the value used by Account Reset Console for the logging database.


    To use Account Reset Console’s Arc Admin Console to update the value used by Account Reset Console for the logging database you need to identify which data source Account Reset Console is using for its logging database and you need to know the correct SQL account information to access the database.
    1. Open ArcAdminConsole.EXE from [All] Programs | ArcWeb.
    2. Select the link to “Change an Existing SQL Data Source” and the “SQL Administration” dialog will open.


    3. From the ARCWeb Data Source Name drop down list, choose the database identified as the “log database”. This data source will have the option selected to “Make this the log database” at the center of this page.
    4. Type in the correct SQL username and password information.
    5. Click “Configure ARC Data Source” to OK and close this dialog. If the dialog closes without displaying any errors, the configuration change was made successfully.

    Applies To:

    Account Reset Console 4.x
    Last edited by Chris; 10-08-2007, 12:12 PM.
    Support
    support@liebsoft.com
    _________________________

    1875 Century Park East, Suite 1200
    Los Angeles, CA 90067
    http://www.liebsoft.com
    Main: (800) 829-6263
    International: +1 (310) 550-8575
    Fax: (310) 550-1152
Working...
X