ZK ADMS ICLOCK SERVER DOWNLOAD DRIVER

Scroll down to the IPAll section, clear the value next to TCP Dynamic Ports and set the value for TCP Port to 1433 and click OK.īy default, SQL Server will choose a random port number each time it starts, but the JDBC driver expects SQL Server to be listening on port 1433.Click OK.Right-click on TCP/IP and choose Properties.In the right pane, right-click on TCP/IP and choose Enable.Under the SQL Server Network Configuration node, select Protocols for (servername).Launch the SQL Server Configuration Manager.It must be provided in plaintext in labkey.xml or in your mssql.properties file later.Īfter you've installed SQL Server, you'll need to configure it to use TCP/IP. Keep track of the user name and password Lab Key Server uses it to authenticate to SQL Server. To enable this feature on SQL Server Express, select the Custom installation option and proceed through the wizard accepting defaults until the Database Engine Configuration step. You can also use the Developer Edition, details may differ slightly from instructions in this topic.ĭuring installation, configure Microsoft SQL Server to accept both Windows Authentication and SQL Server Authentication, ('Mixed Mode'), and specify a user name and password for the administrative account. Note that the Express Edition has database size limitations that generally make it inappropriate for production deployments. If you don't have a licensed version of Microsoft SQL Server, you can download a free Express Edition. If you already having a licensed version of Microsoft SQL Server in a supported version, follow the installation instructions considering the requirements outlined for installing an express edition below.

Zk adms iclock server download