I've created a WordPress site from the Azure Gallery, and successfully converted it to use SQL Azure for the database. The single instance website works fine.
I'm now trying to convert that site to Multisite, using sub-directories, not sub-domains because I figured it would probably be much easier in an Azure setting, and I'm not having any success. I made the necessary change to the wp_config to allow Multisite, and I can run the Network Setup. I turned on debugging because it wasn't working, and When the setup page loads, I get this error, three times:
WordPress database error: [[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'wp_site'.]
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE ''wp_site''
once above the dashboard, and twice after the header "Create a network of WordPress sites", but the page loads.
When I click on install, I get this error:
The page cannot be displayed because an internal server error has occurred.
I've tried it with both 3.4.1 that is installed when the WordPress site is created, and after upgrading to 3.4.2.
If I re-run network setup, it tells me that a network is already installed and the database error messages increase to 4 after the header. The multisite database tables appear to all be created.