IIS and MYSQL Problem

[adav]

Hello

I need help :blush:

I am setting up a website locally using IIS and the main html core of the website is fine.

The problem starts with my forum. I have installed the latest build of MySql for Windows and PHP was already installed.

I think i have setup Mysql correctly with a guide on the vbulletin website

but it seems that IIS cannot communicate with MySQL. :cry:

I am positive that i am entering the correct values :yes: but i get this error when connecting with Vbulletin :wacko: :

Step 2) Connect to the database

Attempting to attach to database

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:\forumshosting\vb307\includes\db_mysql.php on line 140

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.

I have also tried with an old free copy of IPB 1 and phpBB but i get similar error messages! :cry:

From this i'm absolutally positive that its the communication between MySQL and IIS that is the problem

Please Help me! :blush: Where am i going wrong? :wacko:

[garethevans1986]

The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.

Sounds like you are putting the wrong username and password in.

ChocIST

[Josh]

you might also want to confirm that you have named pipes on

[adav]

Sounds like you are putting the wrong username and password in.

ChocIST

585913047[/snapback]

They are definitally the correct usernames and passwords, i created the accounts locally and with full permissions.

I've also given the ISUR_Server user full exectute rights in the hosting and mysql folders.

What are named pipes? :blush:

[Josh]

IUSR does not need ANY privilages in that folder... remove them for security reasons. Google MySQL and Named Pipes. And you SHOULD be using MySQL 4.1.11... if you're not, download the new binaries...

[Mattimeo]

Yea...I would remove the security that you set on the IUSR account now...that is a very bad thing to have. Make sure you have the named pipes thing on.

[adav]

After doing all the above .... my situation is still no good. :sleep:

I have tried all i think is humanly possible and it still doesnt work.

Poo.

I have heard that most of the BB packages are configured for Linux and Apache, so i'm going to go down that street now :happy:

Good Bye Windows Support forum, thanks for all the aboves help, and now i am probably going to introduce my trouble to the Linux Server forum :shifty:

Au revoir! ;)

[garethevans1986]

Ive got mySQL, PHP and IIS to work properly on IIS 5.0, 5.1 and 5.2.

I cant see why you want to even touch Apache lol

ChocIST