Environment

Webserver - Running IIS8 on Server 2012

SQL Server - Running SQL2012 on Server 2012

The installation appears to be successful, but when connecting to the site via the browser to configure the site, (ie. http://www.<sitename>.com/dotnetnuke/) I get the following prompt. I've filled out the following.

"Configure database connection"

Select Database : SQL Server 2005/2008 Database

Server : <Servername>\<Instancename>

Database: <Database Name>

Integrated Security : Checked

Run as DBOwner : Checked

Object Qualifier : <Prefix>

When I Click next, I get the following error.

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: -1
Message: 

And yes, the message field is blank in the error, that is not a typo.

Firewall is not blocking the two servers from communicating, and they are both on the same Network.

Anyone have any ideas?

Thanks.

TCP/IP Protocol is enabled on the SQL Server for sure. As offsite users connect using the management console remotely.

I'm not sure what you mean by client? do you mean the webserver?

Not sure if you still need help with this but i did it a little different to get it to work. Steps are listed below.

** Create a user account you will be using in AD users and computers (For security reasons i didnt not use a domain admin account)

Since it is a domain infrastructure im working in, on the IIS server i did the following:

• Go to Advance settings on the application pool you are using > for the Identity Switch it to custom > enter in credentials Ex: DOMAIN\USERACCOUNT & password

On the SQL 2012 server i did the following:

• Create your Database (Name it wht you would like to call it)
•  Create a new login under SECURITY > LOGINS (if you created a new user add that one, or existing user account)
• Go to the properties of the user added in previous set and USER MAPPINGS to the correct database and give it db_owner rights
• on the SQL Firewall add exeptions for both inbound and outbound for the sqlserver program (i had to use dynamic ports exepetions - http://technet.microsoft.com/en-us/li...) 

* Make the user has modify rights to the root Dotnetnuke extracted files folder

You should be fine after that.