_ADO - Domain Authentication

[twillster]

@mLipok, having a problem with your ADO UDF.

Here's my code.  I'm just taking your API example and checking to see if I can get it to work for what I need.

#include-once
#Tidy_Parameters=/sort_funcs /reel
#AutoIt3Wrapper_Au3Check_Parameters=-d -w 1 -w 2 -w 3 -w- 4 -w 5 -w 6 -w 7

#include "ADO_API.au3"

_Setup()

_Main()

Func _Main()
    ; now to execute query you should only do a "ONE LINER" to get ArrayOfArray :)
    Local $aResult_1 = _ADO_API("select * from dbo.[Site] WHERE Code = '1423'")

    ; if you want to show the result you should use ADO.au3 function
    _ADO_Recordset_Display($aResult_1,'$aResult_1')

EndFunc

Func _Setup()
    Local $sDriver = 'SQL Server'
    Local $sDatabase = 'VLAN_Name'
    Local $sServer = 'SQL.domain.local'
    Local $sUser = 'domain.local\testuser'
    Local $sPassword = 'this domain password'


    ; SetUP internal ADO.au3 UDF COMError Handler
    _ADO_ComErrorHandler_UserFunction(_ADO_COMErrorHandler)

    ; first you must SetUp Connection String
    _ADO_API_ConnectionString('DRIVER={' & $sDriver & '};SERVER=' & $sServer & ';DATABASE=' & $sDatabase & ';UID=' & $sUser & ';PWD=' & $sPassword & ';')

EndFunc

 

When I run it I get this error:

Quote

 

###############################
ADO.au3 v.2.1.15 BETA (1100) : ==> COM Error intercepted !
$oADO_Error.description is:     [Microsoft][ODBC SQL Server Driver] Login failed for user 'domain.local\testuser'.

$oADO_Error.windescription:     Exception occurred.

$oADO_Error.number is:     80020009
$oADO_Error.lastdllerror is:     0
$oADO_Error.scriptline is:     1100
$oADO_Error.source is:     Microsoft OLE DB Provider for ODBC Drivers
$oADO_Error.helpfile is:     
$oADO_Error.helpcontext is:     0
###############################

 

 

I suspect that it's related to the fact that I'm trying to use a domain account instead of a local SQL account, but I need to be able to authenticate as a domain user since I don't know any of the local account passwords.  I have full rights to the database.  Am I missing something in how I initiate the connection?

Edited May 8, 2019 by twillster

[twillster]

And I did just get verification that it's because it's a domain account on the SQL server's logs:

Login failed for user 'domain.local\testuser'. Reason: Attempting to use an NT account name with SQL Server Authentication. [CLIENT: 192.168.0.25]

So the question is, how can I use a domain account to authenticate instead of local SQL credentials?  I haven't been able to find anything in the forums pointing anyone in that direction.

 

[FrancescoDiMuro]

@twillster

Maybe this could be helpful

[mLipok]

From here

https://www.connectionstrings.com/microsoft-ole-db-provider-for-sql-server-sqloledb/

You are using this

https://www.connectionstrings.com/microsoft-ole-db-provider-for-sql-server-sqloledb/standard-security/

 

But you should use this

https://www.connectionstrings.com/microsoft-ole-db-provider-for-sql-server-sqloledb/trusted-connection/