| 1 | Install Database Engine Services with SQL Server Replication (all other components are optional). |
| 2 | If SQL Server was pre-installed, check the configuration: |
| a | Start SQL Server Management Studio. |
| b | Log in using the sa account. This will verify that the Mixed Authentication Mode is being used. |
| c | Right-click the server and select Properties. |
| d | Ensure that the Server Collation is set to SQL_Latin1_General_CP1_CS_AS. |
| e | Click the Advanced tab. |
| f | Ensure the Degree of Parallelism is set to 1. |
| 3 | If you installed SQL Server (that is, if it was not pre-installed), change the following options: |
| a | Change the Server Collation to SQL_Latin1_General_CP1_CS_AS. |
| b | For Authentication Mode, choose Mixed Mode. |
| c | Specify the sa account password. |
| d | Change the Degree of Parallelism to 1. |
| = | Note: Leave all other options at their default values. |
| 4 | Upgrade the SQL Server client tool on all workstations to SQL Server 2008. |
| 5 | Start SQL Server Management Studio 2008. |
| 6 | Log in using the sa account. |
| 7 | Execute the following scripts to create a new BUILTIN\Administrators account: |
EXEC master.dbo.sp_grantlogin @loginame = N'BUILTIN\Administrators'
EXEC master.dbo.sp_defaultdb @loginame = N'BUILTIN\Administrators ', @defdb = N'master'
EXEC master.dbo.sp_defaultlanguage @loginame = N'BUILTIN\Administrators ', @language = N'us_english'
GO
| 8 | After the scripts have executed, open the Security node. |
| 9 | Right-click the newly created BUILTIN\Administrators account, and select Properties > Server Roles. |
| 10 | Select sysadmin and click OK. |
