How to connect to MS SQL Server database remotely by IP in Python using mssql and pymssql

Question

How can I connect to MS SQL Server database remotely by IP in Python using mssql and pymssql modules. To connect locally I use link = mssql+pymssql://InstanceName/DataBaseName

I enabled TCP/IP Network Configurations. But How can I get the connection link?

Thank you.

Morgan Thrapp · Accepted Answer · 2016-09-02 12:42:53Z

5

You need to create a Connection object

import pymssql
ip = '127.0.0.1'
database_connection = pymssql.connect(host=ip, port=1433, username='foo', password='bar')

If you're using SQLAlchemy, or another ORM that supports connection strings, you can also use the following format for the connection string.

'mssql+pymssql://{user}:{password}@{host}:{port}'

edited Sep 2, 2016 at 12:42

answered Sep 1, 2016 at 16:37

Morgan Thrapp

10k3 gold badges50 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Vadim Kovrizhkin Over a year ago

Can I generate the string for connection something like this: "mssql+pymssql://InstanceName/DataBaseName". I thought I could just replace the string and not change the code. Because this string is in config file.

Morgan Thrapp Over a year ago

@VadimKovrizhkin Are you using SQLAlchemy? How are you using that string?

Vadim Kovrizhkin Over a year ago

Yes, it is SQLAlchemy. It is legacy code. I just have this string in the config file.

Morgan Thrapp Over a year ago

@VadimKovrizhkin Then use the second chunk of code I edited in.

Collectives™ on Stack Overflow

How to connect to MS SQL Server database remotely by IP in Python using mssql and pymssql

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related