Dear list,
I am hoping this is a php issue, because we have tried everything
else :(
We have 2 ms sql databases running on the same box. One is a named
instance of MSSQL2005 and the other is the default MSSQL2000 db.
We are connecting to it from a separate linux box running php5.
We have no problem connecting to the default database using
mssql_connect(), but we can't connect to the MSSQL2005 db.
The named instance is XYZ2005.
The connect strings we are using are mssql_connect('192.168.1.208',
$user,$pw) for the default which works, and mssql_connect
('192.168.1.208\XYZ2005', $user1,$pw1) for the named instance.
The error we get is "Unable to connect to server: 192.168.1.208
\XYZ2005".
We are able to connect to the named instance using Access and the
same connection credentials, so we know thy are correct.
Does anyone have any clues as to why this isn't working?
Thanks for any suggestions.
steve
