Solved

PHP Driver and SQL Server on different machines?

Posted on 2013-01-08
5
454 Views
Last Modified: 2013-01-24
Hello,

Is it possible to install the MS Drivers for PHP for SQL Server on a different machine from SQL Server?  I am installing Drupal 7 and have to use SQL Server Enterprise.  MSSQL Enterprise is not on the same machine as Drupal.

Microsoft PHP Driver

I ask this because in the help section of the driver, it seems to say that both need to be on the same machine.  I don't have that setup available to me.

So is it possible to have them separate?
0
Comment
Question by:Modifier1000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 300 total points
ID: 38756985
The PHP driver is separate from the server so No, it does not have to be on the same machine.  I have SQLSRV20.EXE installed on all my XP machines running PHP here whether they have an SQL Server on them or not.  

It does have to be on the machine where PHP is running.  So it does have to be installed on the Drupal machine.  It is normal to install it in the PHP 'extensions' directory with the other extensions and drivers.
0
 
LVL 46

Assisted Solution

by:tbsgadi
tbsgadi earned 200 total points
ID: 38798167
0
 

Author Closing Comment

by:Modifier1000
ID: 38814996
Thank you!
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 38815126
Glad to assist
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 38815969
Yep, me too.
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question