The next string
connection perfectly connects to the destination server:
Import pyodbc
cnn = pyodbc.connect('DRIVER={SQL Server};SERVER=MyServer;DATABASE=MyDb;UID=xxxx;PWD=xxxx')
Print ("Conectado")
But when I try to connect to an instance of that server
Import pyodbc
cnn = pyodbc.connect('DRIVER={SQL Server};SERVER=MyServer\MyInstance;DATABASE=MyDb;UID=xxxx;PWD=xxxx')
print ("Conectado")
I get the error:
Error: ('08001', '[08001] [Microsoft] [ODBC SQL Server Driver] [DBNETLIB] The SQL Server does not exist or the server has been denied access to it. (17) (SQLDriverConnect) ')
The point is that I must access that instance of the database to work with the test tables that it has.
How can I solve this?