| 1
|
Ensure you have uninstalled any other version of SQL Server. |
| 2
|
Install Database Engine Services with SQL Server Replication (all other components are optional). |
| 3
|
If SQL Server 2008 was pre-installed, check the configuration: |
| a
|
Start SQL Server Management Studio 2008. |
| 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. |
| 4
|
If you installed SQL Server 2008, 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. |
| 5
|
Upgrade the SQL Server client tool on all workstations to SQL Server 2008. |
| 6
|
Start SQL Server Management Studio 2008. |
| 7
|
Log in using the sa account. |
| 8
|
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
| 9
|
After the scripts have executed, open the Security node. |
| 10
|
Right-click the newly created BUILTIN\Administrators account, and select Properties > Server Roles. |
| 11
|
Select sysadmin and click OK. |