Cisco Cisco Agent Desktop 8.5 Guía De Instalación
Configuring Microsoft SQL Server 2005 for CAD 8.5
March 31, 2014
45
■
On the Authentication Mode window, select the Windows Authentication
Mode option.
Mode option.
■
On the Collation Settings window, keep the default collation (Dictionary
order, case-insensitive, for use with 1252 Character Set).
order, case-insensitive, for use with 1252 Character Set).
2. Complete the installation wizard.
3. Apply the latest available updates and service packs for SQL Server.
4. Choose Start > Programs > Microsoft SQL Server 2005 > Configuration
Tools > SQL Server Surface Area Configuration.
5. Click Surface Area Configuration for Features. There is configuration
information for each SQL instance installed. Select the configuration for the
named instance CAD is using.
named instance CAD is using.
■
For the Ad Hoc Remote Queries component, select the Enable
OPENROWSET and OPENDATASOURCE support check box.
OPENROWSET and OPENDATASOURCE support check box.
■
For the xp_cmdshell component, select the Enable xp_cmdshell check
box.
box.
6. Click OK to save your settings.
7. From SQL Server Surface Area Configuration, click Add New Administrator.
The SQL Server 2005 User Provisioning Tool (
) is displayed.
Figure 1.
SQL Server 2005 User Provisioning Tool