#39319 [NEW]: Problem to connect to SQLSERVER 2005

[luiscervantesjane at hotmail dot com]

From: luiscervantesjane at hotmail dot com
Operating system: WINDOWS 2003
PHP version: 5.1.6
PHP Bug Type: MSSQL related
Bug description: Problem to connect to SQLSERVER 2005

Description:
------------
The web server are running in windows 2003, Version Apache/2.0.55 (Win32)
PHP/5.1.6. And when I try to connect to MSSQL 2005 over windows2003, I
can`t.
If the code move to another server windows 2000, with the same Apache
Version, PHP 5.1.6. The connection is OK.

I belive that there are a problem the connection with SO windows2003 where
are running php.
Thanks

Reproduce code:
---------------
$SERVER="SATURNO\SATURNO";
$USER="USER";
$PASSWD="PASSWORD";
$link = mssql_connect($SERVER, $USER, $PASSWD) or die ("Could not connect
MSSQL");
mssql_select_db($DATABASE,$link) or die ("Could not select database " .
$DATABASE. " in MSSQL");
$query = "Select * form TABLA";

$result = mssql_query($link,$query);
while ($row = mssql_fetch_array($result)){
print $row['ALU_NOMBRE'] . "<bR>";
}

Expected result:
----------------
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
server: SATURNO\SATURNO in C:\WEB\PRUEBAS\SQL2005\index2.php on line 5
Could not connect MSSQL


--
Edit bug report at [url]http://bugs.php.net/?id=39319&edit=1[/url]
--
Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=39319&r=trysnapshot44[/url]
Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=39319&r=trysnapshot52[/url]
Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=39319&r=trysnapshot60[/url]
Fixed in CVS: [url]http://bugs.php.net/fix.php?id=39319&r=fixedcvs[/url]
Fixed in release: [url]http://bugs.php.net/fix.php?id=39319&r=alreadyfixed[/url]
Need backtrace: [url]http://bugs.php.net/fix.php?id=39319&r=needtrace[/url]
Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=39319&r=needscript[/url]
Try newer version: [url]http://bugs.php.net/fix.php?id=39319&r=oldversion[/url]
Not developer issue: [url]http://bugs.php.net/fix.php?id=39319&r=support[/url]
Expected behavior: [url]http://bugs.php.net/fix.php?id=39319&r=notwrong[/url]
Not enough info: [url]http://bugs.php.net/fix.php?id=39319&r=notenoughinfo[/url]
Submitted twice: [url]http://bugs.php.net/fix.php?id=39319&r=submittedtwice[/url]
register_globals: [url]http://bugs.php.net/fix.php?id=39319&r=globals[/url]
PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=39319&r=php3[/url]
Daylight Savings: [url]http://bugs.php.net/fix.php?id=39319&r=dst[/url]
IIS Stability: [url]http://bugs.php.net/fix.php?id=39319&r=isapi[/url]
Install GNU Sed: [url]http://bugs.php.net/fix.php?id=39319&r=gnused[/url]
Floating point limitations: [url]http://bugs.php.net/fix.php?id=39319&r=float[/url]
No Zend Extensions: [url]http://bugs.php.net/fix.php?id=39319&r=nozend[/url]
MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=39319&r=mysqlcfg[/url]

[fmk@php.net]

ID: 39319
Updated by: [email]fmk@php.net[/email]
Reported By: luiscervantesjane at hotmail dot com
-Status: Open
+Status: Bogus
Bug Type: MSSQL related
Operating System: WINDOWS 2003
PHP Version: 5.1.6
New Comment:

The MSSQL extension uses ntwdblib to connect to the server. This
Microsoft library can be configured with Netbios or TCP/IP as the
default library.

Use the Client Network Tools to specify the default protocol and to
create server aliases. A server alias can be defined to use a specific
host name and port numbr and you can use the alias as the first
parameter to mssql_connect().


Previous Comments:
------------------------------------------------------------------------

[2006-10-31 11:03:36] luiscervantesjane at hotmail dot com

Description:
------------
The web server are running in windows 2003, Version Apache/2.0.55
(Win32) PHP/5.1.6. And when I try to connect to MSSQL 2005 over
windows2003, I can`t.
If the code move to another server windows 2000, with the same Apache
Version, PHP 5.1.6. The connection is OK.

I belive that there are a problem the connection with SO windows2003
where are running php.
Thanks

Reproduce code:
---------------
$SERVER="SATURNO\SATURNO";
$USER="USER";
$PASSWD="PASSWORD";
$link = mssql_connect($SERVER, $USER, $PASSWD) or die ("Could not
connect MSSQL");
mssql_select_db($DATABASE,$link) or die ("Could not select database " .
$DATABASE. " in MSSQL");
$query = "Select * form TABLA";

$result = mssql_query($link,$query);
while ($row = mssql_fetch_array($result)){
print $row['ALU_NOMBRE'] . "<bR>";
}

Expected result:
----------------
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
server: SATURNO\SATURNO in C:\WEB\PRUEBAS\SQL2005\index2.php on line 5
Could not connect MSSQL



------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=39319&edit=1[/url]

[luiscervantesjane at hotmail dot com]

ID: 39319
User updated by: luiscervantesjane at hotmail dot com
Reported By: luiscervantesjane at hotmail dot com
Status: Bogus
Bug Type: MSSQL related
Operating System: WINDOWS 2003
PHP Version: 5.1.6
New Comment:

Hi.
Who can I configure this?
Have I to install Client Network Tools in the server web o reconfigure
the Client Network Tools has is installed in the MSSQL.

I have runnig other web server (XP Pro) and move the code in the other
PC and the connection is right. Do you know why..

Thanks


Previous Comments:
------------------------------------------------------------------------

[2006-10-31 15:45:15] [email]fmk@php.net[/email]

The MSSQL extension uses ntwdblib to connect to the server. This
Microsoft library can be configured with Netbios or TCP/IP as the
default library.

Use the Client Network Tools to specify the default protocol and to
create server aliases. A server alias can be defined to use a specific
host name and port numbr and you can use the alias as the first
parameter to mssql_connect().

------------------------------------------------------------------------

[2006-10-31 11:03:36] luiscervantesjane at hotmail dot com

Description:
------------
The web server are running in windows 2003, Version Apache/2.0.55
(Win32) PHP/5.1.6. And when I try to connect to MSSQL 2005 over
windows2003, I can`t.
If the code move to another server windows 2000, with the same Apache
Version, PHP 5.1.6. The connection is OK.

I belive that there are a problem the connection with SO windows2003
where are running php.
Thanks

Reproduce code:
---------------
$SERVER="SATURNO\SATURNO";
$USER="USER";
$PASSWD="PASSWORD";
$link = mssql_connect($SERVER, $USER, $PASSWD) or die ("Could not
connect MSSQL");
mssql_select_db($DATABASE,$link) or die ("Could not select database " .
$DATABASE. " in MSSQL");
$query = "Select * form TABLA";

$result = mssql_query($link,$query);
while ($row = mssql_fetch_array($result)){
print $row['ALU_NOMBRE'] . "<bR>";
}

Expected result:
----------------
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
server: SATURNO\SATURNO in C:\WEB\PRUEBAS\SQL2005\index2.php on line 5
Could not connect MSSQL



------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=39319&edit=1[/url]

[fmk@php.net]

ID: 39319
Updated by: [email]fmk@php.net[/email]
Reported By: luiscervantesjane at hotmail dot com
Status: Bogus
Bug Type: MSSQL related
Operating System: WINDOWS 2003
PHP Version: 5.1.6
New Comment:

The client tools are installed on the MSSQL server by default.
If the Web server and MSSQL server are running on the same box there is
no need for special actions.
If the web server is running on another box you can install the client
tools from the CD on the web server.


Previous Comments:
------------------------------------------------------------------------

[2006-11-02 09:34:45] luiscervantesjane at hotmail dot com

Hi.
Who can I configure this?
Have I to install Client Network Tools in the server web o reconfigure
the Client Network Tools has is installed in the MSSQL.

I have runnig other web server (XP Pro) and move the code in the other
PC and the connection is right. Do you know why..

Thanks

------------------------------------------------------------------------

[2006-10-31 15:45:15] [email]fmk@php.net[/email]

The MSSQL extension uses ntwdblib to connect to the server. This
Microsoft library can be configured with Netbios or TCP/IP as the
default library.

Use the Client Network Tools to specify the default protocol and to
create server aliases. A server alias can be defined to use a specific
host name and port numbr and you can use the alias as the first
parameter to mssql_connect().

------------------------------------------------------------------------

[2006-10-31 11:03:36] luiscervantesjane at hotmail dot com

Description:
------------
The web server are running in windows 2003, Version Apache/2.0.55
(Win32) PHP/5.1.6. And when I try to connect to MSSQL 2005 over
windows2003, I can`t.
If the code move to another server windows 2000, with the same Apache
Version, PHP 5.1.6. The connection is OK.

I belive that there are a problem the connection with SO windows2003
where are running php.
Thanks

Reproduce code:
---------------
$SERVER="SATURNO\SATURNO";
$USER="USER";
$PASSWD="PASSWORD";
$link = mssql_connect($SERVER, $USER, $PASSWD) or die ("Could not
connect MSSQL");
mssql_select_db($DATABASE,$link) or die ("Could not select database " .
$DATABASE. " in MSSQL");
$query = "Select * form TABLA";

$result = mssql_query($link,$query);
while ($row = mssql_fetch_array($result)){
print $row['ALU_NOMBRE'] . "<bR>";
}

Expected result:
----------------
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
server: SATURNO\SATURNO in C:\WEB\PRUEBAS\SQL2005\index2.php on line 5
Could not connect MSSQL



------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=39319&edit=1[/url]