If you want to create CaseMap SQL cases from existing CaseMap SQL templates, you need to configure SQL Server in order for this to work successfully.
1. | Open Microsoft SQL Server 2005. |
2. | Click Configuration Tools. |
3. | Click SQL Server Surface Area Configuration. |
4. | In the SQL Server 2005 Surface Area Configuration dialog box, click Surface Area Configuration for Features. |
![SQL Server 2005 Surface Area Configuration SQL Server 2005 Surface Area Configuration](ac_sql_server_2005_surface_area_config_box_zoom16.png)
5. | In the Surface Area Configuration for Features dialog box, click to expand Database engine. |
![Surface Area Configuration for Features Surface Area Configuration for Features](ac_sql_server_2005_enable_adhoc_zoom16.png)
6. | Click Ad Hoc Remote Queries. |
7. | Select the Enable OPENBROWSE and OPENDATASOURCE support check box, then click OK. |
|
1. | Open Microsoft SQL Server Management Studio 2008. |
2. | Logon to SQL Server Server Management Studio. |
3. | In the Object Explorer pane, right-click on the server name (root node). |
![Object Explorer pane > Facets Object Explorer pane > Facets](ac_sql_2008_facets_zoom23.png)
4. | Click the Facets option. |
5. | In the Facet drop-down listing, click Surface Area Configuration. |
![View Facets View Facets](ac_sql_2008_view_facets_zoom15.png)
6. | In the View Facets box, click in the right column for AdHocRemoteQueriesEnablednow until it displays True. |
|