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