Tweet
Hi,
I am trying to connect to a mssql server using NT-Authentication.
The server is configured to accept connections from my Windows Login User Name (user).
However the connection is refused, because odbc seems to use my computer name rather than the user name for authentication:
Connection error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'domain\computername'.
I was expecting that the user name: 'domain\user' would be used
(the computername does not really make any sense).
is there a way to change the behavior?
regards, Chris
I am trying to connect to a mssql server using NT-Authentication.
The server is configured to accept connections from my Windows Login User Name (user).
However the connection is refused, because odbc seems to use my computer name rather than the user name for authentication:
Connection error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'domain\computername'.
I was expecting that the user name: 'domain\user' would be used
(the computername does not really make any sense).
is there a way to change the behavior?
Code:
$user = "";
$pass = "";
$tbl = "table";
$dsn = "DRIVER={SQL Server Native Client 10.0};Server=***.***.***.***;Database=test;Trusted_Connection=yes;";
$db=odbc_connect($dsn,$user,$pass);