SQL Server Installation Verification

Verify whether or not SQL Server is properly installed, configured for TIBCO MDM, and running successfully.

Type the following sqlcmd statement on the command line:

sqlcmd -S SQL Server name -d database name -U mdm db user name -P mdm db user password -q "Select NAME from ENTERPRISE where ID=0"

Ensure that the statement returns TIBCOCIM.