Note: This article describes the setup for SQL Server Windows Authentication for non-Azure SQL Server instances. For Azure-based SQL Server with Windows Authentication, use QuerySurge's Connection Extensibility option.
Configuring QuerySurge Connections: SQL Server with Windows Authentication
When you create a QuerySurge Connection, the Connection Wizard will guide you through the process. Different types of QuerySurge connections require different types of information.
For a SQL Server Connection with Windows Authentication (also called integrated authentication), you will need the following information (check with a DBA or other knowledgeable resource in your organization):
- Server Name or IP address of the SQL Server (e.g. sqlsvr1.myserver.com, or 192.168.0.255)
- The port for your SQL Server database (1433 is the default port)
- The Database name
- You will need to make sure that the proper Windows authentication dll is deployed on your driver boxes
Launch the Connection Wizard
- Log into QuerySurge as an Admin user.
- To configure a Connection, select Configuration > Connection in the Administrative View tree (at the left).
- Click on the Add button at the bottom left of the page to launch the Connection Wizard. Click Next.
- Provide a name for your connection. Select SQL Server as the Data Source. Click Next.
Because this option requires you to deploy both a SQL Server JDBC driver and the proper integrated authentication .dll to each Agent, this choice is listed in the Vendor drivers. For details on deploying the driver and dll, see Setup for SQL Server Windows Authentication. Click Next.
- Once you have selected your Data Source, select Windows Authentication. The Wizard will tell you what information you are likely to need in order to create your Connection. Once you have collected this information, you are ready to click Next.
- Provide the connection information to your database. This includes the Server name or IP address, the Port (the default port for your database product will automatically populate), the Database name. Credentials are picked up from Windows and are not provided here. Click Next.
Required fields for your Connection Type are marked by an *.
- Click on Test Connection.
Note: You must have an Agent running with the driver for this Connection deployed in order to test the Connection.
- Save the Connection.
Congratulations! You’ve created a QuerySurge Connection. Again, make sure that you have deployed the driver and authentication .dll for this connection to all your QuerySurge Agents (see #4 above).