00195488_Install_SQLExpress2005_manual.pdf - 第49页
Installation of SQL 2005 Express Edition 02/2011 US Fig. 3-32: Server connecti on properties - General Note: Maximum worker threads value: Unlike t he SQL Server 2000 setting which was “255”, this value is set to zero by…
Installation of SQL 2005 Express Edition 02/2011 US
The following dialog appears:
48 / 54
Fig. 3-31: Server connection properties - General
→ Select the Processors option- page on the left side
The following window appears:
Installation of SQL 2005 Express Edition 02/2011 US
Fig. 3-32: Server connection properties - General
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 that the option “Use Windows fibers (lightweight pooling)” is not selected
→ Click the OK button.
3.4.3 Optional Settings
Proxy account setting
After installation you may enable the proxy server account option, needed for some SIPLACE products.
This setting is needed when you have to use an account with other permissions 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
Express
The following dialog appears:
Fig. 3-33: The "Connect to Server" dialog box of Management Studio
→ Select your Server- and Instance name and specify the Windows Authentication
→ Click the Connect button.
49 / 54
Installation of SQL 2005 Express Edition 02/2011 US
After connecting successfully, the following dialog appears:
50 / 54
Fig. 3-34: SQL Server Management Console
→ Right- click on your server connection on the left side and select Properties
2
Fig. 3-35: select Server connection properties