Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 StartedInstalling DNN ...Installing DNN ...Install DNN on server running plesk 9Install DNN on server running plesk 9
Previous
 
Next
New Post
2/6/2011 2:18 AM
 
sara ehrampoush


Joined: 12/5/2010
Posts: 4
I want to install  DNN 05.06.00 on a Server running Plesk 9.2.1  IIS7/SQL2008

1- I have created DB and all it users in plesk
2- Virtual directory with all the permissions and everything
3-copied DNN files to my virual directory folder
4- I did nothing to my web.config connetion string (I think may be that is the problem)
5- Give the permission to  IWPD_xx and IUSR_xx users
6- run the install.aspx
DotNetNuke Installation Wizard appears but the AUTO installation is inactive with warning that says:
The Auto option has been disabled as the DotNetNuke Application cannot connect to a valid SQL Server database. You can continue to use either of the other two Wizard options and configure the Database settings at the appropriate Wizard step.

once I ingnore it and continue with the TYPICAL installation ,at Database connetion configuration I use the database name that I created before on the server as the file name and unchecked the Integrated Security and typed the user name and password of the created DB.
this error appears:

System.ArgumentException: Invalid value for key 'attachdbfilename'. at System.Data.SqlClient.SqlConnectionString.VerifyLocalHostAndFixup(String& host, Boolean enforceLocalHost, Boolean fixup) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.TestDatabaseConnection(DbConnectionStringBuilder builder, String Owner, String Qualifier) at DotNetNuke.Services.Install.InstallWizard.TestDatabaseConnection() at DotNetNuke.Services.Install.InstallWizard.wizInstall_NextButtonClick(Object sender, WizardNavigationEventArgs e) at System.Web.UI.WebControls.Wizard.OnNextButtonClick(WizardNavigationEventArgs e) at System.Web.UI.WebControls.Wizard.OnBubbleEvent(Object source, EventArgs e) at System.Web.UI.WebControls.Wizard.WizardChildTable.OnBubbleEvent(Object source, EventArgs args) at System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) at System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Help me please.
 
New Post
5/3/2011 12:17 PM
 
Paul Turner


Joined: 5/19/2007
Posts: 93
I have the exact same error.

I can install a new dnn instance by going into plesk adding a database under the domain. Then when installing typing in the database and username and password.

However when I try to copy a site from another server into this one with a database in the appdata folder I get the error you mentioned. I have tried various data connection strings and nothing has worked.

Plesk uses the IWPD_xx and IUSR_xx users and even when these have the correct rights it will not work.
Here are a list of things I have tried so far

1/ create a database in plesk then go into the server and use SSMS to copy the data from the original database into this new one. ---- This just errors and will not work and I have tried it several ways.

2/ Copied the database from my old server into the new one attached it to the SSMS and set permissions on it. ---- Because it was not on the original server it would not accept the new permissions.

3/ Tried changing the app pool to the network service one rather than the one setup by plesk and still no luck.

I do have a different port setup on the server but that can not be what is effecting it as if I do a new install and setup the database in plesk and install it with the SQL Server as 127.0.0.1,(Port) then it will install fine.

But I can not install all my sites I have over 50 of them. I need a work around fast.
I asked my supplier they say it is a problem with DotNetNuke. Which I know is bull.
I asked plesk they said there is no reason for this issue. I said Bull.
So now I just like Sara are asking the community for help.
Its almost like plesk stops you from using an sql express database unless it was setup within the control panel. Which is a little crap so any help would be great.
 
New Post
6/3/2011 9:51 AM
 
Paul Turner


Joined: 5/19/2007
Posts: 93
Simple answer to this is as follows.

If you design DNN sites in a development environment using local .\sqlexpress connection strings and then want to upload to the server that plesk is installed on then prepare for a nightmare. I asked parallels the creators of plesk how to fix this issue so I could upload my site and continue to use .\sqlexpress. Short answer is you cannot. Plesk requires you to have added the database in the panel or the other way parallels told me to do it was to go into ssms and then add the database in and assign it an username and password.

My argument was that because all my sites are designed in DNN and I am moving servers that would mean doing this for 200+ Sites which defeats the point of having plesk panel if I had to do everything manually. They basically washed there hands at that point and set the issue to resolved.

Do what I did tell plesk to stick it where the sun don't shine and use Websitepanel it is miles better for windows hosting and I am working with a development team so we can add Linux hosting into the panel next year some time.

So end story is if you want to use plesk you have to do it there way or go else where. Well I do thinks my way not the way a PHP Based company wants me to be.

Hope that helps over people in the future from wasting money and time on this crap.

Thanks
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Install DNN on server running plesk 9Install DNN on server running plesk 9


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