I'm upgrading an old DNN site. Currently on version 6.2.8 and upgrading to 7.4.2
I initially had an error saying my asp.net was on 2 and should have been on 4. This was rectified after changing to the correct application pool.
Now I get this error:
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty. Source Error:
An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Source File: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config\machine.config Line: 258 Click here to show additional error information: Exception Details: System.Configuration.Provider.ProviderException: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty. Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ProviderException: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.] System.Web.Util.SecUtility.GetConnectionString(NameValueCollection config) +11710487 System.Web.Security.SqlRoleProvider.Initialize(String name, NameValueCollection config) +256 System.Web.Configuration.ProvidersHelper.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +671
I've seen this forum: https://www.dnnsoftware.c...hreadpage/1 and they suggest adding a sql connection string. - but I already have a connection string which declares my sql server and its credentials. (if I didn't then the site would not have been running previously in version 6?)
* It also referes to my machine.config file, yet all the online help suggests amending web.config?
I'm confused.
Did you have 1 or 2 connection strings in the DNN 6 web.config. I'd recommend making a clean install of 7.4.2 and checking the connection strings for that version. Offhand guess is that you should change LocalSsqServer to SiteSqlServer wherever it appears ...
I have one connection string which looks like this:
< connectionStrings> < remove name="LocalSqlServer" / > < add name="SiteSqlServer" connectionString="Data Source=***;Initial Catalog=MyWebsite;User ID=MyID;Password=myPWD" providerName="System.Data.SqlClient" / > < / connectionStrings>
i have another dnn site on another server which uses DNN 9. I've compared it with that web.config and it does not have this line: < remove name="LocalSqlServer" / >
If i remove this line which is above the connection string - it then returns an asp.net permission error:
dnn Access to the path 'C:........map.xml' is denied.
so perhaps i should keep this line omitted and persue the asp.net permission error. (we did have a permission issue in the last upgrade last week but that was sorted and I think we use Network Serive not ASP.NET)
Did you try re-setting the NTFS right for the folder?
i did get rid of this line : < remove name="LocalSqlServer" />
and permissions have been replaced on all child objects on the folder...
and the installation is now running.... (fingers crossed)
thanks.
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:
Awesome! Simply post in the forums using the link below and we'll get you started.