Symantec Control Compliance Suite 11; how to manually add an SQL Server asset.

Products

• Control Compliance Suite Databases MS SQL SRVR
• Control Compliance Suite Windows

Issue/Introduction

 

Resolution

This howto explains how to populate the fields when adding an SQL server type asset in various scenarios. In this howto the asset in question is not within a domain hence still in a workgroup. If your asset is within a domain you can substitute WORKGROUP for your (netbios) domain name.

Imagine the following possible variables:

Server Host name:   MySQLServer
Workgroup/domain:  WORKGROUP
SQL port:                  2030
DatabaseName:       MyDatabase
InstanceName:         MyInstance
 

You can manually add an SQL Server asset by opening the CCS Console => Manage => Assets => Asset Tasks => Add Assets. After selecting that link you can specify the asset type, in this case SQL Server and set the Classification i.e. the SQL version - once set, click next and you'll be presented with the following dialogue:

Depending on the scenario - these fields need to be populated as follows:

Scenario 1; SQL Server asset: (default instance, default port)

Domain/Workgroup Name: WORKGROUP
Server Name (instance): MySQLServer
Hostname: MySQLServer


Scenario 2; SQL Server asset: (default instance, port 2030)

Domain/Workgroup Name: WORKGROUP
Server Name (instance): MySQLServer,2030
Hostname: MySQLServer

Scenario 3; SQL Server asset: (named instance, default port)

Domain/Workgroup Name: WORKGROUP
Server Name (instance): MySQLServer\myInstance
Hostname: MySQLServer

Scenario 4; SQL Server asset: (named instance, port 2030)

Domain/Workgroup Name: WORKGROUP
Server Name (instance): MySQLServer\myInstance,2030
Hostname: MySQLServer