CODEWITHSUNDEEP
asp.netsql-serverinstallationdatabase-connectiondotnetnuke
Firoz Khan
Firoz Khan

Reputation: 666

Dnn Installation,Unable to connect to database. installWizard.aspx

I am installing donnetnukes. below errors is showing.

"No valid default database connection detected. Standard Database setup option is unavailable"

ERROR: DotNetNuke requires SQL 2008 (express or full product) to work.

screenshot: https://lh4.googleusercontent.com/-bODakjneIYg/UiMEjieEGxI/AAAAAAAAA4U/HkN5Wq_oZyk/w620-h553-no/Untitled-3.png

Upvotes: 0

Views: 6000

Answers (4)

alireza nikoughadam
alireza nikoughadam

Reputation: 21

I had such a problem. If use the custom option and then active the SA user and password in your SQL server, you will be able to continue the process.

The reason is that this wizard gets the IIS pool user as a default one. Hence, if you create a user, you will be able to connect to that specific user & password without any problem.

I hope you find this text helpful.

Upvotes: 0

wechel
wechel

Reputation: 595

Another thing that got me - I installed on Windows Server 2012 and the site wasn't trusted in Internet Explorer.

There must be some client scripts that need to run at start-up which are blocked.

Upvotes: 0

dardawk
dardawk

Reputation: 466

The error is not as straight forward as you may think, Chris. If you're sure you have at least SQL Express 2008 or later installed, ensure 3 other things.

Go to your Sql Sever Config Manager and

  1. Ensure SQL Server 2005 is uninstalled
  2. Ensure that SQL Server Browser is running.
  3. Ensure that under SQL Sever Network Configuartion --> Protocols both Named Pipes and TCP/IP is enabled.

If you have trouble enabling SQL Server browser, first stop the SQL Server (SQLEXPRESS) services, right click on the SQL Server Browser --> Properties --> Services Tab --> Start Mode set to "Automatic". Then you can restart both services. This will not work if you do not stop the SQLEXPRESS Server. At least it did not for me. :)

Upvotes: 3

Chris Hammond
Chris Hammond

Reputation: 8963

That error is straightforward, you either need to install SQL Express, using the defaults (not a named instance), or you need to provide the IP address, database name, and user connection info for the SQL server you are using.

Upvotes: 1

Related Questions