Connection failure to MSSQL on remote machine, using mssql_connect() 2

[DanLW]

I am failing to connect to a MSSQL database on a remote machine using mssql_connect().

$db = mssql_connect (‘<remote db server name>’, ‘<username>’, ‘<password>’);
if (!$db)
{
  echo “connection failure”;
}
else
{
  echo “connection successful”;
  mssql_close();
}

// returns “connection failure”

I can connect successfully when the application sits on the same box as the MSSQL database.

$db = mssql_connect (‘<local server name>’, ‘<username>’, ‘<password>’);
if (!$db)
{
  echo “connection failure”;
}
else
{
  echo “connection successful”;
  mssql_close();
}

// returns “connection successful”

I can connect successfully to the database on the remote machine using odbc_connect() WITH A DSN.

$db odbc_connect (‘<dsn to remote db server>’, ‘<username>’, ‘<password>’);
if (!$db)
{
  echo “connection failure”;
}
else
{
  echo “connection successful”;
  odbc_close();
}

// returns “connection successful”

Fails when connecting to the database on the remote machine using odbc_connect(), WITHOUT A DSN

$db odbc_connect (‘<remote db server name >’, ‘<username>’, ‘<password>’);
if (!$db)
{
  echo “connection failure”;
}
else
{
  echo “connection successful”;
  odbc_close();
}

// returns “connection failure”

APPLICATION SERVER
Microsoft Windows Server 2003
Standard Edition
Service Pack 1

IIS 6.0

PHP 5.0.4

REMOTE DATABASE SERVER
Microsoft Windows Server 2003
Standard Edition
Service Pack 1

Microsoft SQL Server 2005
Microsoft SQL Server Management Studio 9.00.3042.00

Any assistance greatly appreciated.

Dan

 

[jpadie]

there are good user comments in the php manual for mssql_connect() that will probably help you.

 

[DanLW]

Problem solved - a work around at least. Not able to connect to an instance of SQL Server by using an anonymous login.

Several days of RTFM and Google searches - happy at last!

Solution at
[URL unfurl="true"]http://support.microsoft.com/default.aspx?scid=kb;en-us;839569[/url]