That looks like your IIS user doesn’t have permission to write in the wp-sqlsrv/wp-content folder.
Most people just give permission to the entire wp folder. To do that, right click on wp-sqlsrv, go to the Security tab and give full control to the IIS_USR. It should propagate to all the files and directories inside your WordPress installation.
Yes I added IUSR permissions and it fixed the issue; however, it only works with 3.4.x and below. In 3.5.2 it simply doesn’t create the tables correctly in the database. I get a false success page and when I start using 3.5.2 I get all kinds of SQL error statements. I haven’t tried to do the manual upgrade for 3.4 to 3.5 just yet but it seems the only way to upgrade at this point.
In my case I have spent 2 full days trying to sort it out with all kind of WP versions and can’t get pass the wp-db-abstraction/setup-config.php?step=2 that comes out blank.
Can’t find any error anywhere, nothing in the logs.
Have tried everything but I’m out of clues.
Wondering what happened to the distribution pointed here: http://wordpress.visitmix.com/download
Not available in sourceforge anymore 🙁
In the end WP 3.3.2 would at least show a message saying that it wasn’t connecting to the database. Happened to be that the SQL Server was set up for Windows Authentication only, so login was failing.
Once sorted that, I tried with the latest version of WP (3.5.1), latest version of the plugin (1.1.4) and PDO Sqlsrv driver and all working like a charm. Taking some time too believe it after such a tremendous pain.
The only thing that I haven’t been able to sort are the pretty URLs. The web.config file described here (http://blog.building-blocks.com/installing-wordpress-on-windows-using-sql-server-2008-r2-part-2) gives me a 500 Internal server error but I can live without that and might figure it out later on.
Cheers!
A question for you miguelgd. You say that you installed the latest version of wp (3.5.1) with the plugin for sqlsrv. Dont you get any error/warning messages when logged in at the dashboard. I have done as yuu but i get this warning messages = Warning: mysql_free_result(): supplied resource is not a valid MySQL result resource in
.
Hi Sanny,
It might be caused by a non supported plugin. I have had the same problem with many that don’t use the abstraction layer and call MySQL functions directly.
I would suggest to try deactivating your plugins one by one and see if you find which one is causing the warning.
Hope it helps!
Thanks for the fast reply, but i get this warning message on a fresh new installation i.e. i haven’t installed any plugin at all.
I found what i was doing wrong. When creating the wp-config.php I selected the wrong db-type. Now when using, pdo_sqlsrv, everything works properly.