In my PHP page I have the following:
$sql = mssql_connect ("xx.xx.xx.xx:xxxx", "xx", "xxxxxx");
$conn=mssql_select_db("xx", $sql);
Since both servers are within your local network, you should be able to
connect as follows:
$connection = mssql_connect('SERVERNAME','username','password') or die
('Cannot connect to server');
$database = mssql_select_db("my_database_name", $mssql_connection) or die
('DB selection failed');
Possible SQL Server issues:
Unless your internal network does not trust your other servers, you
should not have to use ip:port. Just use the servers actual name.
I would also put in the "or die" statements so you know if you are failing
connecting to the server or to the DB.
Also, make sure the username/password you are using to connect is setup in
MSSQL Server as a valid user for your database.
Possible PHP issues:
In your php.ini file make sure that extension=php_mssql.dll is uncommented
You should only have mssql.secure_connection = Off set to On if you are
trying to use NT Authentification.
On 6/12/07, Edward Kay <edward@xxxxxxxxxx> wrote:
> All:
>
> I can't seem to connect to a SQL Server database with PHP. I have read
the
> php.net documentation and so many other forums on the Internet that my
> eyes were literally blood shot. Today I thought I would try this route.
>
> I have PHP and Apache installed on my local machine. They work fine as I
> created another application with them (and MySQL) that worked as
> expected/designed. I want to connect to MS SQL Server 2000 that rests on
> another machine here at work. I can reach the tables and do whatever I
> want with them from my machine through SQL Query Analyzer. (The other
> machine runs a Windows Server. So I am trying to connect from one
Windows
> box to another Windows box.) So I know that I can connect to the tables
> (and the machine that they rest on) from my machine. It is just that I
get
> the following error when I load my PHP page: "Warning: mssql_connect()
[[
> http://localhost/development_files/ordertrackno/where_is_it.php/fu
> nction.mssql-connect
> ]function.mssql-connect]: Unable to connect to server: . . . "
>
> In my PHP page I have the following:
> $sql = mssql_connect ("xx.xx.xx.xx:xxxx", "xx", "xxxxxx");
> $conn=mssql_select_db("xx", $sql);
> etc
>
> I have tried replacing the semicolon with a comma as some have said. I
get
> the same error. I have tried replacing the quotation marks with an
> apostrophe and I get the same error.
>
> I have the Client tools installed on my machine. (I should mention that
> they are not installed on the Apache on my machine as I could not get
them
> to install from the SQL Server disk to that location--only to the
> hardrive.). Again, they connect to the database. I can query the
database
> from my machine. I have the latest ntwdblib.dllinstalled in the php,
> php\extension, apache\bin, and system 32 directories.
>
> What else . . .
>
> I have tried setting the msssql.secure_connection to both off and on and
I
> still get the same error.
>
> I have ensured that TCP/IP and Named Pipes are enabled in the SQL
> Configuration tool.
>
> I have asked the network guy to help out but no luck there.
>
> Again, I am at a loss and need to get this up and running. Any
suggestions
> would be appreciated.
> > Thanks.
>
> Tommy
>
Do you have any firewall software running on your local PC? (e.g.
ZoneAlarm)
This could be blocking the connection from Apache but allowing it for your
other SQL client tools...
Edward
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
