Remote connection to MS SQL – Error using pyodbc vs success using SQL Server Management Studio

by

Try specifying the port:

import pyodbc

server = r"xxxER\xxxSQLSERV"
db = "xxxDB"
user = "xxx"
password = "xxxx"
port = "1433"
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=' + server + ';PORT=' + port + ';DATABASE=' + db +';UID=' + user + ';PWD=' + password)

If you’re still having issues, try using the IP or FQDN of the server.

More Related Contents:

  1. SQL / Pandas equivalent
  2. How to speed up bulk insert to MS SQL Server using pyodbc
  3. Error 28000: Login failed for user DOMAIN\\user with pyodbc
  4. PYODBC–Data source name not found and no default driver specified
  5. pyodbc – How to perform a select statement using a variable for a parameter
  6. Get data from pandas into a SQL server with PYODBC
  7. Writing a csv file into SQL Server database using python
  8. Using SQL Server stored procedures from Python (pyodbc)
  9. pyodbc insert into sql
  10. to_sql pyodbc count field incorrect or syntax error
  11. How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access
  12. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  13. pyodbc the sql contains 0 parameter markers but 1 parameters were supplied’ ‘hy000’
  14. Connecting to SQL Server 2012 using sqlalchemy and pyodbc
  15. pyodbc.connect() works, but not sqlalchemy.create_engine().connect()
  16. How to create a large pandas dataframe from an sql query without running out of memory?
  17. Passing table name as a parameter in psycopg2
  18. Getting the SQL from a Django QuerySet [duplicate]
  19. Using a WHERE ___ IN ___ statement
  20. Django: Adding “NULLS LAST” to query
  21. return SQL table as JSON in python
  22. Output pyodbc cursor results as python dictionary
  23. LEFT JOIN Django ORM
  24. Unable to install pyodbc on Linux
  25. How do I make a composite key with SQL Server Management Studio?
  26. Python, SQLAlchemy pass parameters in connection.execute
  27. How to see the raw SQL queries Django is running?
  28. How to log all sql queries in Django?
  29. How do I connect to SQL Server via sqlalchemy using Windows Authentication?
  30. Python String Formats with SQL Wildcards and LIKE

Leave a Comment