I am getting an error on SQL Server 2012. Whenever I am trying to connect with with the database, I get this error: Cannot connect to the database. ERROR [08001] [Microsoft] [ODBC SQL Server
Hi all, I am connecting to my PostgreSQL dB using ODBC for Power BI. When I tested my connection in ODBC, it worked fine. When I tested the connection again in my IDE, it worked fine. When I am trying to establish connection to Power BI, it returns this error message: TCP/IP connections on port 5431?
For what it's worth, I started getting this error on a connection that had been previously working. It turned out that the MSSQL$SQLEXPRESS service had somehow got stopped.
There could be several reasons you get these error messages. Follow the below steps to see if you can resolve the issue. Ping the physical server where SQL Server is installed from the client machine to make sure it is on the network.
When trying to use the latest SQL Server 18 driver, the ODBC connection setup throws the below error: SQLSTATE=08001 - SSL Provider: The certificate chain was not issued by an authority that is not trusted
Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Use SQL Server logs to work out what port it's running on, or see if it is failing because the port is in use. I believe this question and answer will help you. Thank you for your advise. We are managed to connect the server by IP address and tcp port, example 10.150.109.10,1433.
There could be several reasons you get these error messages. Follow the below steps to see if you can resolve the issue. Ping the physical server where SQL Server is installed from the client machine to make sure it is on the network.