00195487_Install_SQL2005Server_manual.pdf - 第44页
Installation of SQL Server 2005 Edition 02/2011 US 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 a…
Installation of SQL Server 2005 Edition 02/2011 US
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 2005 to
automatically configure this value at startup.
→ Ensure “Use Windows fibers (lightweight pooling)” is not selected.
→ Click the OK button.
3.4.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 2005– 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.
43 / 48
Installation of SQL Server 2005 Edition 02/2011 US
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
44 / 48
Installation of SQL Server 2005 Edition 02/2011 US
The following dialog is displayed:
Fig. 3-36: Server connection properties - General
→ Select the Security option- page on the left side.
The following dialog is displayed:
45 / 48