linux php connect to Server 2008 running MS SQL Server Express

Question

i can connect from client PC to SQL Server Express using the following creds. in mgnt sudio:

server: 192.168.44.96\sqldb
auth: windows auth
user name: domain\user
pw: 1234!

Have a LAMP server trying to connect to the above SQL server, here's what the PHP looks like:

$server = '192.168.44.96\sqldb';
$username = 'domain\user';
$password = '1234!';
$database = 'testing123';
$connection = mssql_connect($server, $username, $password);
if($connection != FALSE){
    echo "Connected to the database server OK<br />";
}
else {
    die("Couldn't connect" . mssql_get_last_message());
}

if(mssql_select_db($database, $connection)){
    echo "Selected $database ok<br />";
}
    else {
    die('Failed to select DB');
}

the page displays 'couldn't connect' and the error.log says "unable to connect ot server: 192.168.44.96".

I have also set mssql.secure_connection = On in php.ini and restarted apache2.

any thoughts?

thanks!

We did this at my workplace, and we ended up hosting PHP on a windows box because theres no good drivers for MSSQL on Linux. We got it working but it took 30 secs to connect etc.. — Andreas Stokholm
– Andreas Stokholm, Commented May 21, 2012 at 21:52

Christian Specht · Accepted Answer · 2012-05-21 21:48:15Z

1

I can't comment on the PHP part, I only know SQL Server.
But I can tell you: That's not how Windows authentication works.
You can't use Windows authentication and then pass user name and password explicitly to the server. You need to do one of these:

Use SQL Server authentication and pass user name and password explicitly
Use Windows authentication and do not pass user name and password - you will connect automatically with the active Windows user.

Since you're using a Linux server, I'm pretty sure that you can't use Windows authentication. So you have to use SQL authentication (which needs to be enabled on a fresh SQL Server installation), and you have to create an user on the SQL Server.

answered May 21, 2012 at 21:48

Christian Specht

36.6k16 gold badges132 silver badges190 bronze badges

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

3 Comments

dan Over a year ago

is there any way to modify the current sql server instance to use mixed mode auth?

Christian Specht Over a year ago

Yes, see this SO question: stackoverflow.com/questions/1393654/…

dan Over a year ago

awesome! changed to mixed mode, added an sql user, connected using sql auth and the new user creds. works great! Thanks!

YvesR · Accepted Answer · 2012-05-21 21:48:46Z

0

If you have a default sqlexpress installation you probably need to configure your sql server to allow remote access connections. Also I don't know if you can connect with windows auth. At your sql server you can also setup sql authentication and use uid=;pwd=.

answered May 21, 2012 at 21:48

YvesR

6,2829 gold badges46 silver badges75 bronze badges

Collectives™ on Stack Overflow

linux php connect to Server 2008 running MS SQL Server Express

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related