Dotnetnuke Install error – Net SqlClient Data Provider 15364 on Windows server

Dotnetnuke Install error – Net SqlClient Data Provider 15364 on Windows server

On Windows 2008 R2 server with SQLExpress 2008 R2 creating a dotnetnuke website I was receiving the following error:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 15364
Message: Failed to generate a user instance of SQL Server. Only an integrated connection can generate a user instance. The connection will be closed.

To overcome this I first manually created a database in Microsoft SQL Server Management studio MYSERVER\SQLExpress with the dotnetnuke database name-