Verify the SQL Server Synchronization Instance

The tests listed in this topic are focused on verifying that the SQL Server synchronization instance is installed and setup. Ultimately the validation test of a SilhouetteConnect successfully performing a sync with SilhouetteCentral proves the synchronization instance is working.

1: Verify the version

To verify that the SQL Server Synchronization instance is running you can open the Windows command prompt as an administrator and run the following command:

sqlcmd -S .\SILHOUETTE -Q "SELECT @@version"

The above command should return the version of SQL Server being used for as the synchronization instance. The specific output will vary based on your deployment but should report the expected version number. The output should be similar to:

Microsoft SQL Server 2014 (SP3-GDR) (KB4583463) - 12.0.6164.21 (X64)

Nov 1 2020 04:25:14

Copyright (c) Microsoft Corporation

Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 19043: )

2: Verify the assignment of the sysadmin role

To verify the assignment of the sysadmin role to either Authenticated Users or specifically to the IIS Apppool identity, use the following command to list principals with the sysadmin role:

sqlcmd -S .\SILHOUETTE -Q "SELECT name FROM master.sys.server_principals WHERE is_srvrolemember ('sysadmin',name) = 1 and is_disabled = 0"