King Computer Solutions
spacer
03.27.2011

Dotnetnuke install error .Net SqlClient Data Provider 15364 on Windows 2008 server with SQLExpress 2008 R2

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-