How to install SQL Server

Introduction

This topic explains the process of downloading and installing Microsoft SQL Server 2008 Express R2 from the Microsoft website.

1. Open your web browser.

2. Go to http://www.microsoft.com/downloads/en/details.aspx?FamilyID=967225eb-207b-4950-91df- eeb5f35a80ee

3. Click Continue.

4. If you want to register select Yes otherwise select No and click Continue.

5. There is no obligation to register with Microsoft.

• For 32 bit machines, click Download next to the x86 version
• For 64 bit machines, click Download next to the x64 version

5. Click Save. Save the file somewhere you can easily access it (for example, on the Desktop).

6. Double-click the SQLEXPRWT_x86.exe (or SQLEXPRWT_x64.exe) download.

The relevant files will extract:

7. Select the New installation or add shared features option.

8. Click Next and select I accept the licence terms box.

9. Click Next and click Select All.

10. Click Next and select the Named instance option.

11. Type the required SQL instance name into the Named instance box.

12. By default the PTP Accounts Production uses an instance name of PTPACCOUNTS.

13. From the drop-down box next to SQL Server Browser select Automatic.

14. Click Use the same account for all SQL Server services.

15. In the Account Name drop-down box select NT AUTHORITY\SYSTEM.

16. Click OK and then Next.

17. Select the Mixed mode (SQL Server authentication and Windows authentication) option.

18. Enter a password and password confirmation.

19. Click Add Current User and click Next.

20. Click Next.

21. Once the install is complete, click Close.

Back to top

Configuring the SQL Server for network use

If this is for use as a network version of PTP Account Production, then the SQL Server needs to be configured for network use.

1. Click Start.

2. Go to All Programs – Microsoft SQL Server 2008 R2 – Configuration Tools – SQL Server Configuration Manager

3. On the left-hand side, go down to SQL Server Network Configuration – Protocols for PTPACCOUNTS

• In this case PTPACCOUNTS is the instance name from above.

4. Right-click on Named Pipes and select Enable.

5. Right-click on TCP/IP and select Enable.

6. On the left-hand side, go up to SQL Server Services.

7. Right-click on SQL Server (PTPACCOUNTS) and select Restart.