Enter the SQL Server Host Name as the Server. In an existing SQL Server connection, the host name comes before the instance name in the format HOSTNAME\INSTANCENAME. Find the host name:
In the Object Explorer pane as the top-level object for your database.
In the footer of a query window.
Viewing the current connection Properties and looking for Name or Display Name.
Enter the SQL Server Instance Name as the Database name. Find this name using the same steps listed above for finding the host name.
If you don’t see an instance name in any of these places, then your database uses the default MSSQLSERVER instance name.
Enter your User account name or ID.
Enter your Password.
For the Port:
SQL Server defaults to 1433.
If you can’t connect over port 1433, check the Error logs for the phrase Server is listening on to identify the port number you should enter.
You only need to enter the Domain name if users in multiple domains access your database. Run this SQL query to get the domain name:
Copy
Ask AI
SELECT DEFAULT_DOMAIN()[DomainName];
Select whether to use TLS.
Select whether to Ignore SSL Issues: If turned on, the credential will connect even if SSL certificate validation fails.
Enter the number of milliseconds Stigg should attempt the initial connection to complete before disconnecting as the Connect Timeout. Refer to the SqlConnection.ConnectionTimeout property documentation for more information.
SQL Server stores this timeout as seconds, while Stigg stores it as milliseconds. If you’re copying your SQL Server defaults, multiple by 100 before entering the number here.
Enter the number of milliseconds should wait on a given request before timing out as the Request Timeout. This is basically a query timeout parameter. Refer to Troubleshoot query time-out errors for more information.
Select the Tabular Data Stream (TDS) protocol to use from the TDS Version dropdown. If the server doesn’t support the version you select here, the connection uses a negotiated alternate version. Refer to Appendix A: Product Behavior for a more detailed breakdown of the TDS versions’ compatibility with different SQL Server versions and .NET frameworks. Options include: