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 ...Migrating from SQL Express to SQL Server?Migrating from SQL Express to SQL Server?
Previous
 
Next
New Post
4/6/2010 9:18 AM
 
Greg Baughman


Joined: 9/2/2008
Posts: 20

Recently it became necessary for me to install SQL Server (full) on the same machine that is running SQL Express.

I wish to move DNN to the SQL server, so that I can uninstall SQL Express (no point in two SQL servers running on the same machine).

I would have thought that this would be as easy as pointing to the new data source, since DNN attaches the database itself; but unfortunately it's not that easy.

Does someone have information on how to do this?  The database is on the same machine, just a different instance of SQL server (instead of SQLExpress, it would be SQLSERVER).

Thanks in advance!

 
 
New Post
4/6/2010 1:18 PM
 
Jeff Smith


fishingstatus.com
Joined: 1/6/2005
Posts: 47
Assuming you made a copy/backup of the Express db and moved it to your new SQLServer, you should only have to change the connection string to include the named instance of your new SQLServer. Here is an example:


If you are still having a connection issue, try creating a new SQLServer AND DB security account. It also helps to use a UDL file to test the connection. If you cannot connect using the UDL file, then you will know something is not configured correctly.

Last but not least, depending on your server configuration, you may need to enabled Named Pipes and TCP/IP connections. You can do that through the SQL Server Surface Area Configuration Manager.
Jeff Smith
VivoWare, Inc. - Open Source Social Networking Modules for DNN.
 
New Post
4/6/2010 3:36 PM
 
Greg Baughman


Joined: 9/2/2008
Posts: 20
It looks like DNN attaches the database file; it's no "In" SQL, it attaches it on load.... (or at least that is my understanding).... So my thought was that if I point the web.config at the new SQL instance, it would attach the file to that instance instead; but that doesn't work. I must be missing something simple. The SQL Express and full SQL databases are on the same machine. My hope is to move DNN to the full SQL, so that I can un-install SQL Express.
 
New Post
4/6/2010 4:23 PM
 
Greg Baughman


Joined: 9/2/2008
Posts: 20
I don't think my last reply went. My understanding is that DNN attaches the MDF file on load... since both SQL servers (Express and Full) are on the same machine, it *should* be as easy as pointing to the new instance, and letting it attach the file. Unfortunately, that didn't work. I must be missing a step somewhere.
 
New Post
4/8/2010 1:57 PM
 
Greg Baughman


Joined: 9/2/2008
Posts: 20
OK, I got it. Here's what I did (for anyone trying to do this in the future). 1) Stopped my IIS Server. 2) Using SQL Management Studio, I attached the DNN database MDF file to my SQL Server. 3) I right-click and did a rename on the file to DotNetNuke 4) I created a user called DotNetNuke, gave it a strong password, and made it the owner of the DotNetNuke database. 5) I made sure that the DotNetNuke database was in 2005 compatible mode (since I am running SQL Server 2008) 6) I edited web.conf, commenting out the lines about SQL Express, and un-commenting the lines below that for SQL Server 2005. I put my DotNetNuke user name after uid= and the strong password after pwd= 7) Just to be complete, I tested connectivity by going to a command prompt, and using sqlcmd -S .\SQLSERVER -U DotNetNuke - it prompted me for the password, and I was in. 8) I re-started the IIS Services and tried logging on. It worked perfectly. 9) I stopped the SQL Express service, and made sure the web page still responded (it did) 10) Just because, I rebooted the entire server to make sure that everything loaded up properly. I am now ready to un-install SQL Express.
 
 Page 1 of 1
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Migrating from SQL Express to SQL Server?Migrating from SQL Express to SQL Server?


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