DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.

Forums
Search Forums

Advanced Search Topics Posts

Install Wizard can't find database connection

Forums > Installing DNN Platform

Sort:

You are not authorized to post a reply.

Author

Messages

Jim Anthony

New Around Here

Posts:6

7/12/2021 1:33 PM

Hi,

Using nvQuickSite to install dnn 9.9.1 on Windows Server 2016 in a domain with a local SQL Express 2017 database.

nvQuickSite installed, the site and database, but when the dnn Installation Wizard starts, the database section, displays a message box:

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

Database Connection Error

Changing the radio button from default to custom, has no affect.

The connection string ( wrapped in angle brackets) in the web.config is

add name="SiteSqlServer" connectionString="Server=ServerName;Database=DatabaseName;User ID=DBUser;Password=dbUserPwd" providerName="System.Data.SqlClient"

Using SSMS, I can connect to the database using the credentials in the web config file. The user has dbo access to the database. The created database appears empty.

I checked folder permissions for the nvQuickSite created app pool, it has read/write/modify access to the website directory

.Net version 4.7.2 installed on server.

I have deleted and recreated with nvQuickSite a couple of times, with the same result.

Any ideas of other thinds to try?

Thanks.

Sebastian Leupold

Veteran Member

Posts:539

7/12/2021 8:44 PM

By default, SQL Serer express installs a named instance and the connection string would be "server=".\sqlexpress;database=..."

Jim Anthony

New Around Here

Posts:6

7/13/2021 12:39 AM

Thank you Sebastian for the reply,

I tried changing the server name to the default name instance. With that set, calling the install wizard results in an application error. Resetting it back to server name, the install wizard loads.

I copied the connection string with the server name to another application and was able to connect to the database. I believe my database to be good.

Sebastian Leupold

Veteran Member

Posts:539

7/13/2021 7:11 AM

ok, if you installed SQL Server Express as default instance, you may use server name (or . for localhost),
Did you enable TCP/IP protocol for both, SQL server and client? did you double check database name, user name and password?

Jim Anthony

New Around Here

Posts:6

7/13/2021 10:53 AM

Thanks Sebastian, Yes to all.

But, your prompting got me thinking in a different direction, client connectivity. When I change the radio button for the SQL connection from Default to Custom, nothing happened, the error message remained. Not being familiar enough with the install wizard, I did not recognize this as a browser problem. I have been running the install on the Windows Server 2016 default browser ( a version of IE, that I can't identify ) . Apparently, that browser does not like the Install Wizard, when I connected via Chrome from a remote machine, same error for the default database, but changing the option button to custom allowed me to enter the correct database credentials and the install wizard ran as expected.

Thanks again for the help.

Joe Craig

Veteran Member

Posts:1236
Veteran Member

7/13/2021 3:15 PM

When the Installation Wizard appears, choose "Custom" as the database connection. If you specified "Windows Authentication" for the SQL connection, then choose "Integrated" in the custom section. Make sure that the correct SQL server is specified, along with the correct database. The should be pre-filled by nvQuickSite, you can correct them if needed.

Joe Craig
DNN MVP
Patapsco Research Group

Jim Anthony

New Around Here

Posts:6

7/13/2021 9:43 PM

Thanks Joe.

Turns out this was a server browser compatibility problem, not displaying the Custom settings of the install wizard. Using Chrome from a remote workstation, displayed the Custom settings properly and allowed the installation to complete.

Sebastian Leupold

Veteran Member

Posts:539

7/14/2021 8:11 PM

I am glad you were able to soft it out and install DNN successfully.

You are not authorized to post a reply.

These Forums are dedicated to the discussion of DNN Platform.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy.
No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved