ODBC Connection failing to SQL server 2019 Express

Question

Hello,

I recently updated a machine and installed SQL server 2019 on and it will not allow me to connect to it via ODBC connection.
TCP/IP is enabled
Port 1433 is open and can be pinged

The error that I am getting is connection failed SQL server error 1272.
I don't know what this means and can't seem to find anything on it.

Thank you

Answer 1

Hi @Wyatt ,

Are you using he default instance or the named instance？

Please verity that the SQL Server service is started and port 1433 is not blocked on the firewall between the client and the server

Ensure the database is attached and online

Please check out: Troubleshoot connectivity issues in SQL Server

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.