Welcome Guest, Login

Page History: SQL Server manual installation to resolve Windows User/Role issues

Compare Page Revisions

6 5 4 3 2 1 0 Current 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Sat, 02 Mar 2013 11:48

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 (link 2 cst ins wiki)
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 Installion in the uppoer 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 checkbox before click on the Next button again
11. Check the checkboxes for Database Engine Services and SQL Server Replication then click Next
12. Set the Named instance to CAREWare then verify the Instance root directy is set to your desired location. (This is best time to specfy another hard drive.) Click Next.
13. Verify the proposed Disk Space Requirements are availalbe then click Next.
14. Using the pulldown menu for Account Name, set the SQL Server Database Engine to NT AUTHORITY\NETWORK SERVICE and then using the pulldown menu for Startup Type set the field to Automatic. The Colllation 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 Mode. 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. (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 confirguration 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 Canel or close any windows related to the installation or it will fail.
19. Verfiy the 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 uppoer right corner of the screen to close the SQL Server Installation.
    

Back to Frequently Asked Questions