[GH-ISSUE #22] Can Not Connect To Sql server #9

Closed
opened 2026-02-26 01:32:52 +03:00 by kerem · 2 comments
Owner

Originally created by @uditvishnoi on GitHub (Jan 18, 2016).
Original GitHub issue: https://github.com/jeffknupp/sandman2/issues/22

Hey , i am not bale to connect to Sql server database , i am new to python . I am getting this error

File "pymssql.pyx", line 639, in pymssql.connect (pymssql.c:10246)
sqlalchemy.exc.InterfaceError: (pymssql.InterfaceError) Connection to the database failed for an unknown reason.

I am using this commmand to connect to sql server
sandmanctl mssql+pymssql://username:password@servername/database

Originally created by @uditvishnoi on GitHub (Jan 18, 2016). Original GitHub issue: https://github.com/jeffknupp/sandman2/issues/22 Hey , i am not bale to connect to Sql server database , i am new to python . I am getting this error File "pymssql.pyx", line 639, in pymssql.connect (pymssql.c:10246) sqlalchemy.exc.InterfaceError: (pymssql.InterfaceError) Connection to the database failed for an unknown reason. I am using this commmand to connect to sql server sandmanctl mssql+pymssql://username:password@servername/database
kerem closed this issue 2026-02-26 01:32:52 +03:00
Author
Owner

@filmackay commented on GitHub (Jan 18, 2016):

Personally, I would use pyodbc instead. newer things (AlwaysOn availability etc.) are really only supported with ODBC.

What platform are you connecting from?

<!-- gh-comment-id:172580198 --> @filmackay commented on GitHub (Jan 18, 2016): Personally, I would use pyodbc instead. newer things (AlwaysOn availability etc.) are really only supported with ODBC. What platform are you connecting from?
Author
Owner

@jeffknupp commented on GitHub (Jan 22, 2016):

This doesn't appear to be a sandman issue, but rather an issue with the underlying database library. Are you able to connect to your database using the library in the "normal" way?

<!-- gh-comment-id:173974558 --> @jeffknupp commented on GitHub (Jan 22, 2016): This doesn't appear to be a sandman issue, but rather an issue with the underlying database library. Are you able to connect to your database using the library in the "normal" way?
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/sandman2-jeffknupp#9
No description provided.