PHP: Connect to MS SQL Server using Domain user and Password

Question

I have WAMP and am trying to connect to to my SQL Server 2008 database by entering a domain user and password using the following PHP command:

$serverName = "MySQLServer\Instance"; //serverName\instanceName
$connectionInfo = array( "Database"=>"dbName", 
                         "UID"=>"myADUserName", "PWD"=>"MyPassword");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

As I understand it, it is trying to authenticate with a SQL Server created user and not from the Active Directory, so I am getting the following error message:

Array ( [0] => 
   Array ( [0] => 28000 [SQLSTATE] => 28000 
           [1] => 18456 [code] => 18456 
           [2] => [Microsoft][SQL Server Native Client 10.0]
                  [SQL Server]Login failed for user 'myADUserName'. 
                  [message] => [Microsoft]
                      [SQL Server Native Client 10.0]
                      [SQL Server]Login failed for user 'myADUserName'.  
         ) 
        [1] => 
   Array ( [0] => 28000 [SQLSTATE] => 28000 
           [1] => 18456 [code] => 18456 
           [2] => [Microsoft][SQL Server Native Client 10.0]
                  [SQL Server]Login failed for user 'myADUserName'. 
                  [message] => [Microsoft]
                      [SQL Server Native Client 10.0]
                      [SQL Server]Login failed for user 'myADUserName'. 
         ) 
     )

Is this possible in PHP with WAMP?

I've read about changing the log on account in the wampapache service to myADUserName, but the user doesn't have access administrator access on the server to allow this and I wouldn't want to tie one account to all my PHP applications.

Not exactly what I wanted, but I ended up creating a Service Account in the Active Directory and assigning it to the wampapache service so it starts it. — Rick
– Rick, Commented Jan 21, 2014 at 20:11

coding Bott · Accepted Answer · 2014-01-15 09:10:34Z

2

When you assign "UID"=>"myADUserName", "PWD"=>"MyPassword" you are using sql-authentication and not Windows authentication. But you can create that user/pwd combination into the sql-server as sql-login -> SQL Server Authentication.

When you are want to use windows authentication you don't need to specify uid and pwd. the authentication is taken from the running apache process. Of curse that one needs to be run into that windows account.

See Microsoft documentation

Remarks If values for the UID and PWD keys are not specified in the optional $connectionInfo parameter, the connection will be attempted using Windows Authentication. For more information about connecting to the server, see How to: Connect Using Windows Authentication and How to: Connect Using SQL Server Authentication.

edited Jan 15, 2014 at 9:10

answered Jan 14, 2014 at 16:19

coding Bott

4,3871 gold badge29 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pradeep Kumar Over a year ago

When you want to use windows authentication you don't need to specify uid and pwd. +1

Jay · Accepted Answer · 2014-09-02 20:32:40Z

0

It looks strange, but this one worked for me,

$dbName='dB-Name';
$dbUser='User1';
$dbPass='B4X345ZXsaoi0omkLH';

 $connectionInfo = array( "Database"=>$dbName, "UID"=>$dbUser, "PWD"=>$dbPass);

If you are using SQLSERVER this wont work with php 5.5(I'm using this version didn't test any other)

$connectionInfo = array( "Database"=>"DBName", "UID"=>"User1", "PWD"=>"B4X345ZXsaoi0kLH");

answered Sep 2, 2014 at 20:32

Jay

3221 gold badge6 silver badges21 bronze badges

Collectives™ on Stack Overflow

PHP: Connect to MS SQL Server using Domain user and Password

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related