Python pymssql - Connecting to Named Instance

Question

I'm trying to connect to a SQL Server named instance from python 3.4 on a remote server, and get an error.

File "C:\Scripts\Backups Integrity Report\Backup Integrity Reports.py", line 269, in
conn = pymssql.connect(host=r'hwcvcs01\HDPS', user='My-office\romano', password='PASS', database='CommServ')
File "pymssql.pyx", line 636, in pymssql.connect (pymssql.c:10178)
pymssql.OperationalError: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed\n')

Other SQLs are connected without a problem. Also I manage to connect to the SQL using the Management Studio, from the same remote server.

Tried different ports, tried to connect to the host itself rather than the instance, and also tried pypyodbc. What might be the problem?

Answer 1

For a named instance that looks like this:

myhost\myinstance,1435

You can connect via pymssql with the following:

pymssql.connect(host='myhost', server='myinstance', port='1435', user='user', password='pw')

Answer 2

According to the pymssql documentation on the pymssql Connection class, for a named instance containing database theDatabase, looking like this: myhost\myinstance You could connect as follows: pymssql.connect(host=r'myhost\myinstance', database='theDatabase', user='user', password='pw') The r-string is a so-called raw string that does not treat the '' as an escape.