Comment on page
Microsoft SQL Server
This documentation will guide you through the process of connecting to a Microsoft SQL Server database. To establish a successful connection, you will need to provide specific connection details and, if necessary, configure additional settings.
The "Data Source Name" is a user-defined name for your database connection. You can use any name you prefer to help you identify this connection within your system.
The "Server" is the address or hostname of the Microsoft SQL Server you want to connect to.
The "Port" specifies the port number for the SQL Server instance. The default port for SQL Server is 1433.
The "User" is the username you use to authenticate with the SQL Server.
The "Password" is the corresponding password for the user specified above.
The "Database Name" is the name of the SQL Server database you want to connect to. Ensure that you have the appropriate permissions to access this database.
The "Character Set" option is optional and allows you to specify the character encoding for your database connection. The default character set is UTF-8. You can change this setting if your database requires a different character set.
You have the option to use SSL for secure communication with the SQL Server. By default, this option is unchecked. If you wish to enable SSL, you can check the "Use SSL" checkbox.
By default, the "Verify SSL Certificate" option is checked. This means that the SSL certificate presented by the SQL Server will be verified for authenticity. If you want to bypass SSL certificate verification, you can uncheck this option. However, it's advisable to keep SSL certificate verification enabled for security reasons.