Help - Search - Members - Calendar
Full Version: IIS and MYSQL Problem
Neowin Forums > Windows Support > Windows NT4/2000/2003/2008 Server
adav
Hello

I need help blush.gif


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.gif

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

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.gif

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

Please Help me! blush.gif Where am i going wrong? wacko.gif
garethevans1986
QUOTE
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
QUOTE(ChocIST @ May 13 2005, 11:53)
Sounds like you are putting the wrong username and password in.

ChocIST
[right][snapback]585913047[/snapback][/right]


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.gif
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. sleeping.gif

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.gif

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.gif

Au revoir! wink.gif
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.