I have spent about a day on this trying to figure it out but for some reason I can't locate the issue.
I am attempting to run this python from Kali
For some reason the query is returning no results. Am I missing something obvious?
CODE:
import _mssql
server = '192.168.1.83'
user = 'sa'
password = 'password123'
print 'connecting'
connection = _mssql.connect(server=server,user=user,password=password,database='WebApp')
print connected
sqlQuery = "SELECT * FROM dbo.users"
print connection.execute_row(sqlQuery)
print connection
OUTPUT
Connecting
Connected
Making Query
None
<Open mssql connection at 0x7fc1a954d6b0>

osqltool without any issues? Is tcp/ip enabled?print connectedline that threw an error as connected wasn't defined. I'd check the network protocol configuration in the SQL Server Config Mgr to make sure the correct transport is enabled.