PDA

View Full Version : Impex cannot connect to MSSQL


Forsyth-Online
Thu 15th Jan '09, 8:44pm
When running impex we are getting the following error message:

mssql_query() [function.mssql-query]: Unable to connect to server:

Impex is installed in the same folder as my forum. What do I need to do to get a connection?
Jerry
Thu 15th Jan '09, 8:45pm
What do I need to do to get a connection?

Configure MSSQL to allow connections from where ever the PHP is that is running ImpEx.

Typically the issue is that it's on a remote server and databases by default only allow connections from localhost for security.
Forsyth-Online
Thu 15th Jan '09, 8:52pm
Okay, I have one of the programmers from .org running the impex for me. Where would the "php" be running from? From him or from my server? Thank you for your help.
Jerry
Thu 15th Jan '09, 8:53pm
Okay, I have one of the programmers from .org running the impex for me. Where would the "php" be running from? From him or from my server? Thank you for your help.

The server that is running ImpEx, as that is the PHP process that needs access to the MSSQL database to read the data -> process it -> write to the vBulletin MySQL database.