00196604_Install_SQL2008Server_manual.pdf - 第26页

Installation of SQL Server 2008 02/2011 Edition After connecting successful ly, the following dialog is displayed: Fig. 3-34: SQL Server Management Console → Right- click on your server con n ection on the left side and …

Installation of SQL Server 2008 02/2011 Edition

Note:

Maximum worker threads value: Unlike the SQL Server 2000 setting which was “255”, this

value is set to zero by default which causes SQL Server 2008 to automatically configure this

value at startup.

→ Ensure “Use Windows fibers (lightweight pooling)” is not selected.

→ Click the OK button.

3.3.2 Optional Settings

Proxy account setting

After installation you may enable the proxy server account option, needed for some SIPLACE products,

like SIPLACE Explorer.

This setting is needed when you have to use an account with permissions other than the configured SQL

service account for executing specific tasks. A more detailed description can be found in the Microsoft

Knowledge Base:

http://support.microsoft.com/?id=kb;en-us;890775

→ Click Start – Programs – Microsoft SQL Server 2008– SQL Server Management Studio

The following dialog is displayed:

Fig. 3-33: SQL Server Enterprise Manager

→ Select your Server- and Instance name and specify the Windows Authentication.

→ Click the Connect button.

Installation of SQL Server 2008 02/2011 Edition

After connecting successfully, the following dialog is displayed:

Fig. 3-34: SQL Server Management Console

→ Right- click on your server connection on the left side and select Properties

Fig. 3-35: Server connection properties

Installation of SQL Server 2008 02/2011 Edition

The following dialog is displayed:

Fig. 3-36: Server connection properties - General

→ Select the Security option- page on the left side.