While connecting the SQL server using python script from powershell showing mentioned error

Question

Connection failed: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]SQL Server Network Interfaces:  (-1983577846) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0); [08001] [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. 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. (-1983577846)')

Answer 1

Hi @Anandhswarupp,

When connecting to a SQL Server instance, you may encounter one or more of the following error messages. This article provides some steps to help you troubleshoot these errors, which are provided in order of the issues from simple to complex.

A network-related or instance-specific error occurred while establishing a connection to SQL Server

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

In addition to Olaf's answer, if you are connecting to a named instance, you need to double the backslash.

Answer 3

Server is not found or not accessible. Check if instance name is correct

Mainly as the error message says.

Can you connect to SQL Server using tools like SSMS with the same credentials?