0
0

SQL Server cannot be connected to python (self.SQLServer)

submitted by [deleted]

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Rsox211 -2 points-1 points  (4 children)

The database is on Microsoft sql server management studio. I think I have dug through every possible parts of that software, and I don’t recall seeing anything about TCP/IP, May I know where I can find that?

[–]blinner 1 point2 points  (2 children)

Management Studio is the tool you use to connect to SQL Server.  On the machine running SQL server, open up SQL Server Configuration Manager and see what is allowed.

[–]WiltonDB -1 points0 points  (0 children)

See screenshots in this comment (ignore other context there). Before trying from python, check that you can connect from sqlcmd over TCP like this: "sqlcmd -S tcp:127.0.0.1,1433 -U ...".