Solved

PHP Driver and SQL Server on different machines?

Posted on 2013-01-08
5
453 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

738 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