Learn DNN / DotNetNuke

You need to Register for free and Login to post a message in the forum.

Forum

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > DotNetNuke® > DotNetNuke® Questions

Installing to dedicated SQL Express Server

Last Post 03/20/2009 11:21 AM by Joseph Craig. 5 Replies.

Sort:

Check this box to subscribe to this topic.	Prev Next
You are not authorized to post a reply.

Author

Messages

Brian King

Nuke Newbie
Posts:3

03/18/2009 9:26 PM
Well, I have been successful in installing DotNetNuke 4.9 on the local web server. Now I am reinstalling in the production environment by using a dedicated SQL Express server and a separate Web server. Can someone offer advice on setting up the web.config connection settings? Here is the connection strings I am using: < ! -- Connection String for SQL Server 2005 Express -- > < add name="SiteSqlServer" connectionstring="Data Source=DBSERV\SQLEXPRESS;AttachDbFilename=\|DataDirectory\|Database.mdf;Integrated Security=True;User Instance=True" providername="System.Data.SqlClient" > < !-- Connection String for SQL Server 2000/2005 < add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" / > --> < appsettings > < !-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -- > < add key="SiteSqlServer" value="Data Source=DBSERV\SQLEXPRESS;AttachDbFilename=\|DataDirectory\|Database.mdf;Integrated Security=True;User Instance=True "> < !-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules < add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/ > -->

Joseph Craig
DNN MVP
Posts:11667

03/19/2009 5:09 AM
If you were using SQL Server Express in your development environment, then you'll need to change the name (URL or IP) of the server. If you installed the database with a different user, you'll need to change those, too. You will also need to insert a PortalAlias for the URL for the live site.

Joe Craig, Patapsco Research Group Complete DNN Support

Brian King

Nuke Newbie
Posts:3

03/19/2009 8:04 AM
Hi Joe! Thank you so much for the quick reply. After re-reading my post, I realize I didn't make it very clear . I have my current DNN site running as norm on a W2K3 server with IIS and SQL Express. Everything works fine. Now, I want to move the database portion to a second server running W2K3 and SQL Express. I configured the new SQL EXP server with the same users, etc, and to allow remote connections and can connect to it remotely using SQL Server Management Studio Express. I then created a backup of the DNN DB from the local server, configured users and the database on the new remote server, then restored the DB to the new server. All of this works fine. Then I edited web.config to point to the new server by changing "DataSource=DBSRV\SQLEXPRESS". I then point to the URL and it blows up, giving a generic Runtime Error message. So, what have I done wrong? I shouldn't have to do anything with the URL or IP address, should I, since the flows still use port 80 to access the IIS server.

Joseph Craig
DNN MVP
Posts:11667

03/19/2009 7:34 PM
If I had to guess, I'd guess that the error is related to the database connection. Does the Event Log provide more information?

Joe Craig, Patapsco Research Group Complete DNN Support

Brian King

Nuke Newbie
Posts:3

03/20/2009 11:09 AM
Thanks for all the help Joe, but I got frustrated and decided to start from scratch (I didn't have a whole lot invested in the development yet). After a completely clean install, I was able to finally access the site. One strange thing happened, when I was logged in as the host user, I could not access any of the host menu items. The Admin menu items all worked fine. After some digging, I found a post that pointed me to the Tabs table and verifying IsSecure column. I just happened to notice that the PortalID for all the Host Tabs were set to NULL. So I changed this to '0' and now it works fine. Strange that when installing on a single server, it wasn't getting this problem, but when installing to a separate SQL server, it would do this. Thought I would give you the update and hope it helps anyone else! Thanks again! BTW: an IRC channel would be AWESOME for immediate help. DNNCreative would have a good audience and another outlet to solicit the magazine subscriptions.

Joseph Craig
DNN MVP
Posts:11667

03/20/2009 11:21 AM
Hmmm. I'm not sure about the changes that you did in the tabs table. You should have found a set of tabs with NULL for the portalid, but you should have found another set with portalid=0, assuming that you had that first portal installed. If that's not the case, you may have a problem if you try to create additional portals. So ... you might want to look elsewhere. I'm also confused because this should not be related to having moved your database from one server to another. As for IRC ... isn't that just SOOOOO last century? These days, you will find a fair number of people in the DotNetNuke community tweeting and blogging enough to prevent you from doing serious work. Stuart Hilbert put together a list of DotNetNuke community members on Twitter. You can find his blog from dotnetnukeblogs.com, I believe.

Joe Craig, Patapsco Research Group Complete DNN Support

You are not authorized to post a reply.

Forums > DotNetNuke® > DotNetNuke® Questions

Latest Forum Posts

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Can you Run Xcode in Linux? by Aman Singh

Can you Run Xcode in Linux?

Billed for subscription that was canceled by Ryan

I was just billed for a subscription that was canc eled / inactivetive how do I get a refund for th

Meta Title and Meta Description are not showing properly by DNN User

Hi, On my site the meta title and meta descriptions are not showing properly. It's showing the m

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

Search is not functioning properly by DNN User

Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea

DNN Platform import site optio by Melanie Weaver

Is it possible to import site template in DNN Platform 8.0? We have internal Evoq Content 8.1 tha

Events Module for DNN V5? by Tugboat

Would anyone have a download link for the version 5.0.3 Events Module? Thanks!

"Ghost" TabID Number? by Tugboat

Hi! I have a portal instance with multiple child portals and on one of the child portals, there i

RE: DNN Load Testing by ayman sharkawy

Hi. Have you already implemented a site using the DNN . And how the performance of the site and its

Publish All Pages by NSUOK

I'm using DNN Evoq Content Basic 8.2.0. When I make the HTML Pro module display on all pages, I h

Simpler profile needed in 9.2.2 by Donald

We are upgrading a DNN 4.8.4 site to DNN 9.2.2. On 4.8.4, the top bar shows the user’s name. If yo

How to link from dnnmodal popup to web site page? by Donald

Hello all. I am using a dnnmodal.show popup. The popup works correctly, showing the content that I

RE: Document Collaboration by Nick Davern

That feature would be super beneficial for our needs as well! Does anyone have an update as to if th

RE: DNN 9.2, how to set default theme? by Andy Stephenson DNN Creative

you do that under "Manage/Themes". Note the highlight blue border around the default container and d

DNN 9.2, how to set default theme? by Donald

Please disregard, found Manage Themes I cannot find how to set a default portal theme in DNN 9.2

RE: Looking for DataSprings Dynamic Forms by Andy Stephenson DNN Creative

Your best chance would be to contact Chad Nash @ http://www.datasprings.com/

Looking for DataSprings Dynamic Forms by Jakir HM

Looking for DataSprings Dynamic Forms 3.4 for DNN 4.x 5.x for my site (https://themasters2018s.com/)

RE: Help with Cycle Image Carousel not displaying images by peter

I had the same problem with the Will Strohl Content Slider after upgrading to DNN 9.1 The above an

RE: Object reference not set to an instance of an object by Andy Stephenson DNN Creative

Check this one might be useful: http://www.dnnsoftware.com/answers/im-tryin-to-move-my-site-to-pr

Used
By

Testimonials

| The SoloCoder Podcast | Google | Privacy Statement | Terms Of Use