If you’re running a PHP Laravel application on an Ubuntu server and trying to connect to a SQL Server database, you might encounter the error message “SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server] TCP Provider: Error code 0x2746”. This error is related to a TLS 1.2 connection issue between the Ubuntu server and the Windows server hosting the SQL Server. This article will guide you through the steps to fix this error.
Confirm Firewall Settings
Firstly, it’s important to ensure that the Ubuntu server’s IP address is allowed through the firewall on the Windows server running SQL Server. The following ports should be open: TCP 1433, 4022, 135, 1434, and UDP 1434. These ports are essential for SQL Server operations.
You can check the firewall settings on the Windows server by navigating to Control Panel > System and Security > Windows Defender Firewall > Advanced Settings.
Configure TLS and SSL Protocol Settings
The error message suggests that the cipher suites supported by the Ubuntu server are not compatible with the SQL Server. You need to configure the TLS and SSL protocol settings on the Windows server.
Microsoft provides detailed documentation on how to configure these settings here.
In brief, you’ll need to:
- Open the registry editor (
regedit.exe) - Navigate to the appropriate registry subkey, which will vary depending on your version of Windows
- Modify or create new DWORD values for
Enabled,DisabledByDefault, andDisabledByDefault
Remember to backup your registry before making any changes, as incorrect modifications can cause serious problems.
Verify Username and Password
Since the connection works from your local machine, it’s likely that the username and password are correct. However, it’s always a good idea to double-check. Ensure that the credentials you’re using in your Laravel application match those set up for the SQL Server database.
Check ODBC Driver Version
Ensure that you have the latest version of the ODBC driver installed on your Ubuntu server. You can download the driver from the Microsoft website.
To check your current version, run the following command in the terminal:
odbcinst -jThis will display information about the ODBC driver, including the version number.
Verify PHP ODBC Extension
Ensure that the PHP ODBC extension is installed and enabled on your Ubuntu server. This extension provides functions for accessing databases via ODBC (Open Database Connectivity) drivers.
To check if the extension is enabled, run the following command in the terminal:
php -mThis command lists all the modules compiled into PHP, and you should see ‘odbc’ in the list.
If the extension is not enabled, you can install it using the following command:
sudo apt-get install php-odbcAfter following these steps, your connection to the SQL Server database from your PHP Laravel application running on Ubuntu should work without any issues. If the problem persists, consider seeking assistance from the Laravel community or consulting the Laravel documentation for further troubleshooting.
To check if the IP address of your Ubuntu server is allowed through the firewall on the Windows server running SQL Server, you can navigate to Control Panel > System and Security > Windows Defender Firewall > Advanced Settings on the Windows server. In the advanced settings, you can check the inbound and outbound rules to see if there are any rules allowing or blocking the IP address of your Ubuntu server.
To configure TLS and SSL protocol settings on the Windows server, you need to open the registry editor (regedit.exe) and navigate to the appropriate registry subkey. The specific subkey will vary depending on your version of Windows. Once you are in the correct subkey, you can modify or create new DWORD values for Enabled, DisabledByDefault, and DisabledByDefault according to the Microsoft documentation. Remember to backup your registry before making any changes.
To verify if the username and password you’re using in your Laravel application are correct, you can compare them with the credentials set up for the SQL Server database. Double-check that the username and password in your Laravel application match the ones provided for the SQL Server database.
To check the version of the ODBC driver installed on your Ubuntu server, you can run the following command in the terminal: odbcinst -j. This command will display information about the ODBC driver, including the version number.
To verify if the PHP ODBC extension is enabled on your Ubuntu server, you can run the following command in the terminal: php -m. This command lists all the modules compiled into PHP, and you should see ‘odbc’ in the list if the extension is enabled. If the extension is not enabled, you can install it using the command sudo apt-get install php-odbc.
