|
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. |