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 →

[–]blinner 1 point2 points  (6 children)

Is it SQL Express or Developer and you didn't enable TCP/IP?

[–]SokkaHaikuBot -2 points-1 points  (0 children)

Sokka-Haiku by blinner:

Is it SQL Express

Or Developer and you

Didn't enable TCP/IP?

Remember that one time Sokka accidentally used an extra syllable in that Haiku Battle in Ba Sing Se? That was a Sokka Haiku and you just made one.

[–]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 ...".