rjrapson

There were a couple of steps

first, after you create your database, make sure you can log into it using the manage link. That insures that the firewall rules are correct.

Next, make sure you link your database to your website and unlink the mysql database that is linked when you create it.

then, drop the wp-db-abstraction in mu-plugins, making sure to move the db.php from that plugin folder to the wp-content folder.

Edit the \mu-plugins\wp-db-abstraction\translations\sqlsrv\translations.php file, the regex on line 726 should be changed

from: $pattern = ‘/LIMIT\s*(\d+)((\s*,?\s*)(\d+)*)(;{0,1})$/is’;
to: $pattern = ‘/LIMIT\s*(\d+)((\s*,?\s*)(\d+)*)$/is’;

otherwise, you won’t see your posts on the main page.

Delete any config.php file in your wwwroot folder

In your browser address bar, type in the following https://yoursite.azurewebsites.net/wp-content/mu-plugins/wp-db-abstraction/setup-config.php

Enter the following: database name
user name, in the format user@dbservername
database host dbservername.database.windows.net
database type PDO SqlSrv
table prefix – whatever you want

click submit. You should get a confirmation page with a Run the Install button. Click that and it should start the WP install.

A note on the database – when you create it, make sure you create it in the same region as your website (east us, west, europe, whatever.) Otherwise, you could incur data expenses as every call will be cross-region and also, it’s much slower. It is possible to move the database if it is created in the wrong region, but it’s a pain and there are other issues as well, especially if you setup multisite WP.

That definitely fixed it.

Seems to be a problem with the SQL Server for php driver, using the pdo_sqlsvr driver works.