Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...I get Connection To The Database FailedI get Connection To The Database Failed
Previous
 
Next
New Post
1/23/2018 1:34 PM
 

Hello!

When I write http://dnndev.me/ in the browser I get Connection To The Database Failed

This dnndev.me worked for a week ago and I haven't done anything that should cause this problem but obviously I must have done something.

The connection string looks like this 
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
and it's the default connection string.
I If I enter SSMS and use server name =localhost\sqlexpress and try to attach to the C:\Websites\dnndev.me\App_Data\Database.mdf  I get 

The database 'C:\WEBSITES\DNNDEV.ME\APP_DATA\DATABASE.MDF' cannot be opened because it is version 869. This server supports version 663 and earlier. A downgrade path is not supported.Could not open new database 'C:\WEBSITES\DNNDEV.ME\APP_DATA\DATABASE.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

If I now use SSMS again and instead select localhost for Server name and attach to C:\Websites\dnndev.me\App_Data\Database.mdf it works fine.
If I right click on localhost (SQL Server 14.0.1000) and select property I can see that the Name is AF-7BSCGH2\SQLEXPRESS01.
So because its 
SQLEXPRESS01 i tried to change the connection string see below.

So i tried to change the connection string to this 
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress01;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

But it still Connection To The Database Failed,.

As you can see the only change is that I changed in the Data Source from SQLExpress to SQLExpress01 but I still get connection to the Database Failed.
Can somebody guide me in the right direction?

 

//Tony

  

 

 
New Post
1/24/2018 6:46 AM
 
Tony Johansson wrote:

Hello!

When I write http://dnndev.me/ in the browser I get Connection To The Database Failed

This dnndev.me worked for a week ago and I haven't done anything that should cause this problem but obviously I must have done something.

The connection string looks like this 

and it's the default connection string.
I If I enter SSMS and use server name =localhost\sqlexpress and try to attach to the C:\Websites\dnndev.me\App_Data\Database.mdf  I get 

The database 'C:\WEBSITES\DNNDEV.ME\APP_DATA\DATABASE.MDF' cannot be opened because it is version 869. This server supports version 663 and earlier. A downgrade path is not supported.Could not open new database 'C:\WEBSITES\DNNDEV.ME\APP_DATA\DATABASE.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

If I now use SSMS again and instead select localhost for Server name and attach to C:\Websites\dnndev.me\App_Data\Database.mdf it works fine.
If I right click on localhost (SQL Server 14.0.1000) and select property I can see that the Name is AF-7BSCGH2\SQLEXPRESS01.
So because its 
SQLEXPRESS01 i tried to change the connection string see below.

So i tried to change the connection string to this 


But it still Connection To The Database Failed,.

As you can see the only change is that I changed in the Data Source from SQLExpress to SQLExpress01 but I still get connection to the Database Failed.
Can somebody guide me in the right direction?

Is there any log file so I can see why I can't connect to the database.

I'm using dnn series 9

//Tony

  

 

 

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...I get Connection To The Database FailedI get Connection To The Database Failed


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

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

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. 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.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out