Navigation¶

• FAQ
• Feature Explorer
• All CAREWare documentation
• All Pages
• Create Account
  

Quick Search
»

SQL Server manual installation to resolve Windows User/Role issues

The help desk will need to review the SQL Server log of the installation in order to confirm the exact reason of a failed SQL Server installation. These logs are located by default at C:\Program Files\Microsoft SQL Server\MSSQL10.CAREWare\MSSQL\Log . Please zip all logs together and email to the CAREWare Help Desk.

Normally this issue is caused by an inability of the SQL Server installation to assign the current Windows user permission to install the required service. Manual installation of SQL Server 2005 or 2008 is then required in order to do so. The following procedure will walk you through this process.

1. Download the full CAREWare setup file from the HRSA CAREWare website for your PC's architecture (32-bit or 64-bit).
2. Extract the setup files, but do not run the installation when prompted.
3. Go to C:\CW_Setup and run SQLEXPR_x86_ENU.exe or (insert 64 exe name). (If prompted to allow application to Continue click Yes.)
4. Click on "Installation" in the upper left corner.
5. Click on "New SQL Server stand-alone installation or add features to an existing installation".
6. Verify all Setup Support Rules have passed before clicking on "OK". If any warning or failures occurred, then resolve before proceeding.
7. Click "Install".
8. Verify all Setup Support Rules have passed before clicking on "Next". If any warning or failures occurred, then resolve before proceeding.
9. Check the button for "Perform a new installation of SQL Server 2008" then click "Next".
10. Click "Next" on the Product Key screen then check the "I Agree" check box before clicking on the "Next" button again.
11. Check the check boxes for Database Engine Services and SQL Server Replication then click "Next".
12. Set the Named instance to "CAREWare" then verify the Instance root directory is set to your desired location.
    Note:This is best time to specify another hard drive. Click "Next".
13. Verify the proposed Disk Space Requirements are available then click "Next".
14. Using the pull down menu for Account Name, set the SQL Server Database Engine to NT AUTHORITY\NETWORK SERVICE and then using the pull down menu for Startup Type set the field to "Automatic". The Collation tab will be left to default.
    Note: This step resolves the Windows user issue described above.
15. On the Database Engine Configuration screen set the Authentication Mode to "Mixed Mod"e. Provide a unique 9+ character password containing upper & lower case characters, 2 numbers, & 2 alphanumeric symbols. Add the proper SQL Server administrators using the "Add..." or "Add Current User" buttons. All stand-alone installations of SQL Server can simply use the "Add Current User" button). Click on the "Data Directories" tab. Verify all locations are correct then click "Next".
    Note: This is a perfect time to separate data and log files to separate hard drives or directories if desired.
16. Leave the Error and Usage Reporting default then click "Next".
17. Verify all Installation Rules have passed before clicking on "OK". If any warning or failures occurred, then resolve before proceeding.
18. Verify all configuration options have been set as correctly before clicking on "Install". Note: The installation may take 20-30 minutes to complete on older hardware. Do not click on "Cancel" or close any windows related to the installation or it will fail.
19. Verify all features were installed successfully on the Installation Progress screen before clicking "Next". If any warning or failures occurred, then resolve before proceeding.
20. A copy of the Summary Log can be saved before clicking "Close".
21. Click on the red X in the upper right corner of the screen to close the SQL Server Installation.
    

Once the installation of SQL Server has completed successfully the CAREWare Data Tier setup file will need to be run in order to complete the instance configuration for CAREWare.

1. Go to C:\CW_Setup and run DatabaseInstaller.exe. (If prompted to allow application to Continue click Yes.)
2. Leave the installation type as Domestic if installing in the United States or one of its territories. Otherwise check International for all other locations. Click "Next".
3. Leave the check box checked for "Check here if you already have an instance of SQL Express..." and highlight the SQL Server Instance named "CAREWare" in the detected SQL Server instances box. Click "Next".
4. Provide the SA password then click "Next".
5. Allow the installation of the CAREWare tables, fields, user, and role to complete successfully. Once completed click "Finish". When prompted to overwrite the existing businessTierSettings.XML file, then click "Yes". If prompted to install Management Studio 2008, then click "No".
   

Once the above steps have completed successfully you will be able to login to CAREWare using the default user name and password. The restoration of backups files can now occur either within CAREWare or by using Management Studio.

Back to Installation

Back to Frequently Asked Questions