If want to use integrated security = true with SQL and WBI

If using SQL AyaNova database, and you want to have your config.txt use integrated security = true instead of the sa username and password, you will need to create a SQL user ASPNET (or NETWORK SERVICE) user and assign permissions to the AyaNova database.

Otherwise when you enter in the URL for WBI that has integrated security = true in its config.txt you will get either of the following errors:

WBI was unable to start, most likely this is due to a configuration error.
Double check your settings in the config.txt file as outlined in the documentation.
The error message is:
Cannot open database “AyaNova” requested by the login. The login failed.
Login failed for user ‘COMPUTERNAME\ASPNET’

or

WBI was unable to start, most likely this is due to a configuration error.
Double check your settings in the config.txt file as outlined in the documentation.
The error message is:
Login failed for user ‘NT_AUTHORITY\NETWORK SERVICE’

Below are the steps to create the user in SQL Express on a Windows XP station - it would be fairly the same if using SQL Server or other operating system:

Open SQL Express Management Studio
Expand Security
Right-click on Logins → select New Login…
Click on the Search button for Login Name
Click on Advanced and than Find Now so it lists all possible existing names
Select ASPNET (you may also or have to select NETWORK SERVICE)
Select OK
Select OK
Click on User Mappings for this new SQL user
Checkmark the Map box for the AyaNova database in the “users mapped to this login”
Checkmark db_owner, db_securityadmin as well as the existing public
Click on OK to create this new user in SQL
Now restart SQL (open Services and restart SQL Express) - or reboot the entire computer
On login, open a web browser and enter your local url to WBI to bring up the WBI login

  • Joyce