[clicker666]

Originally Posted by blubyu

clicker666 and spy1309, do a favor for me. Go into your php folder and open up your php.ini file. Find the following line:

error_reporting = E_All

comment out that line by puting a ';' in front of it (without the quotes).

A few lines above it find this line and uncomment it:

error_reporting = E_All & ~E_NOTICE | E_STRICT

Save the file and restart your IIS. Then open up the phpberrystats index page. This should give an additional line or two of errors along with the Unable to Connect to Database line. From the additional information we should be able to tell what is wrong. I hope

Here's the results:

PHP Strict Standards: date() [function.date]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Halifax' for '-4.0/no DST' instead in C:\Inetpub\wwwroot\phpberrystats\includes\html_header.php on line 21 

PHP Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 10.0.0.2 in C:\Inetpub\wwwroot\phpberrystats\includes\common_funcs.php on line 27 

PHP Warning: mssql_select_db() [function.mssql-select-db]: Unable to connect to server: (null) in C:\Inetpub\wwwroot\phpberrystats\includes\common_funcs.php on line 28 

PHP Warning: mssql_select_db() [function.mssql-select-db]: A link to the server could not be established in C:\Inetpub\wwwroot\phpberrystats\includes\common_funcs.php on line 28

[blubyu]

Ok. This is telling us that you can't connect to the server. Which means it doesn't have anything to do with the username, password or database name. Now we need to find out why you can't connect to the server.

I can't remember if you have tried, but can you change your ip number in your config.php file to 127.0.0.1 and see if that makes a difference? If I remember right you are running both php and the bes software on the same server.

[clicker666]

Same error with 127.0.0.1.

[blubyu]

Is there any kind of software firewall installed on that server? Something is not letting the php software talk to the SQL software.

One more thing. Is your SQL database listening on the default port of 1433 or has it been changed? I just discovered that my code just assumes that the database is running on the default port

I just did some more reading on SQL express. This is how you find out what port it is using (I guess it doesn't always use the default port):

Don´t use the standard MS-SQL port (1433), use the MS-SQL dinamic port under SQL Server Configuration Manager -> SQL Express Protocols -> TCP/IP properties -> IP Adresses -> IPAll

If the port it is using is not 1433, then that is the problem and I know how to fix it.

[clicker666]

Originally Posted by blubyu

Is there any kind of software firewall installed on that server? Something is not letting the php software talk to the SQL software.

One more thing. Is your SQL database listening on the default port of 1433 or has it been changed? I just discovered that my code just assumes that the database is running on the default port

I just did some more reading on SQL express. This is how you find out what port it is using (I guess it doesn't always use the default port):

Don´t use the standard MS-SQL port (1433), use the MS-SQL dinamic port under SQL Server Configuration Manager -> SQL Express Protocols -> TCP/IP properties -> IP Adresses -> IPAll

If the port it is using is not 1433, then that is the problem and I know how to fix it.

Bingo - port is 1278.

[clicker666]

Originally Posted by clicker666

Bingo - port is 1278.

I wonder if that is because I have three instances (or whatever they are called now a days) running. (Backup Exec, Bid2Win, and SQLExpress (BESMgmt lives here).))

[blubyu]

From what little I read it sounded like SQLExpress doesn't use the default SQL port. I don't know didly about SQL so I don't know if this is true or not. But..........I think we can fix it.

Go into the includes directory in the phpberrystats folder and open up the common_funcs.php file. Look for this line:

$connect=mssql_connect(DBHOST,DBUSER,DBUSERPW);

And change it to this:

$connect=mssql_connect('yourserverip:1278',DBUSER,DBUSERPW);

By default, when a port isn't specifed it uses the default port (in this case 1433). In the config.php file I ask for the default DB port but I have now discoved that I don't use it anywhere

The above line should try and connect to your server ip at port 1278. Once I know it works for you I will spend some time and make use of the DBPORT variable in the config.php.

[clicker666]

No love, sorry. Exactly same error. I've tried 127.0.0.1, localhost, and 10.0.0.2.