Connection To The Database Failed in DNN

Question

I am trying to install DotNetNuke, I created a virtual machine with Window Server 2008, and followed the video series to install DotNetNuke.

When I run the InstallerWizard I am getting this error: "Connection To The Database Failed"

Note that when I didn't find the account iss apppol/dnndev.me so I added my virtual login account as a database owner, I even created an account but still nothing.

I am frustrated with this, I've spent 3 days trying to solve it, as I don't know a lot in IIS.

How are you configuring SQL Server? Express or are you connecting to an existing DB? — Chris Searles, May 14 '13 at 14:43
when i opened SQL studio manager i will get WIN-O10UIAC9FNG\SQLEXPRESS in the server name which the first one is my machine name, and then i created a DB and add the account as an owner to this DB — Noora, May 16 '13 at 10:46
i removed this account and added NETWORK SERVICE for all the application pool and Site folder and as a database owner, the page is loaded first part only in database part i getting error Database Connection Error — Noora, May 16 '13 at 11:44
Can you post the connection string from your web.config? (Just make sure it doesn't include any passwords or public IP addresses). — Chris Searles, May 16 '13 at 12:14
i tried to modify the connection string in site web.config, but still i am getting the connection error, i changed it as follow, is that write?? note that my DB name is dnndev.me — Noora, May 16 '13 at 13:16

score 0 · Answer 1 · answered May 14 '13 at 10:19

0

Are you trying to setup using SQL server express? In case of express version, I suggest you setup AppPool identity as ApplicationPoolIdentity and have "Load User Profile" as "True".

answered May 14 '13 at 10:19

Ashish

1,171
11
12

thank you for the reply, but where can i setup the AppPool Identity? – Noora May 14 '13 at 11:16
Check the APPLICATION POOL in IIS to see what account it is running under – Chris Hammond May 14 '13 at 14:01
its running under ApplicationPoolIdentity – Noora May 16 '13 at 10:48
i changed it to NETWORK SERVICE account – Noora May 16 '13 at 13:19
When you are having AppPool Identity - you will need to have correct folder permissions. Executed following from command prompt ------ icacls C:\MyWebSitePath /grant "IIS APPPOOL\MyAppPoolName":(OI)(CI)(F) – Ashish May 21 '13 at 05:15

score 0 · Answer 2 · answered Sep 22 '16 at 15:21

Had the same error when I was trying to set up the website locally. Mine was due to the user identity in the Application Pool was wrong. This is what I did to solve it:

1) In IIS, go to your site, click on Basic Settings, or Advanced Settings, and find the Application Pool name.

2) In IIS, under Application Pools tree branch on the left, select your site's Application Pool, and click on it.

3) Click on Advanced Settings, then click on Identity. Set the account's user name and Password.

score 0 · Answer 3 · answered Dec 19 '16 at 05:57

0

Change your Application Pool Identity as NetworkService

Open IIS (Run-> inetmgr) and follow the steps from screenshot below.

IIS -> Change Application Pool Indentity for DNN Site

answered Dec 19 '16 at 05:57

Imran Athar

469
5
8

Connection To The Database Failed in DNN

3 Answers3