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

Forum

Forums > DotNetNuke® > DotNetNuke® Questions
Subject: 2 separate DNN Installations using 1 MS SQL database
Prev Next
You are not authorized to post a reply.

Author Messages
oweng
Nuke Newbie
Nuke Newbie
Posts:7
26 Apr 2006 9:49 PM  

Hi,  I was wondering if it is possible to have 2 separate DNN Installations (to different hosting spaces areas) but have them sharing 1 MS SQL database using prefixed table names. 

I know that DNN is a portal system but for certain reasons i wish to have separate installations for each website as they may have varing needs in the future. I have found that you can prefix the table names for the database during the install. But i can't seem to get the install work.  It actually completes successfullt but the new set of tables doesn't seem to be installed.  There is a entry made in to the aspnet_applications table for the new install, but no new tables with the different prefix apear in the database.

Is it possible to do achieve i am trying?

Can anyone help me with this, it would be much appreciated?

Thanks
Owen
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3351
27 Apr 2006 2:32 AM  
Hi Owen,

It's a good question, as you say, usually you would just create another portal, but I can understand why you would want to split the hosting up, so in theory I would think yes it's possible and approach it in the way you have, but if it's not working there maybe something in the installation procedure that is checking for another install of tables.

You would also have to check that your modules will be compatible running in this environment and don't clash. - I've come across some modules in the days of DNN2.x where if you had  a prefix on the tables they would throw errors. - I think most modules now are compatible with this, but occassionally you do come across the problem.

You may be safer just using 2 separate installations with separate databases.

Let me know if you come across a solution, I would be very interested to hear about it,

thanks,
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
oweng
Nuke Newbie
Nuke Newbie
Posts:7
27 Apr 2006 2:47 AM  
Thanks for getting back to me Lee. Alas no resolve so far.

Yes the reason i wish to achieve this is that i act as a hosting reseller and have a dedicated HELM based server. However my wholesaler doesn't provide multiple MS SQL databases with this option. Thus i have to pay for a new MS SQL server database for each site i wish to setup with DNN. I am in the process i migrating all my sites from another CMS system (PostNuke) on a linux based box, and thought that DNN would be a great move. But have come unstuck with the requirement of a separate MS SQL server database for each site i have. I have about 15 of them to migrate. So its turning out to be a bit of a problem. Have consider setting up my own live internet MS SQL server, but don't really want the cost and administration overhead.

I have come across a Firebird database solution that is in the process of being developed as a dataprovider for DNN but unfortunatley is a bit of a way off.

Do you know of any very cheap MS SQL server hosting that i could use with each of my DNN sites? It cost me $50 (Australian) for each DB here.

Thanks
Owen
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3351
27 Apr 2006 3:12 AM  
Hi Owen,

That's expensive for reseller hosting, I would do some shopping around. - www.resellerchoice.com  is a reseller that I use for DNN installs. They have been great support and service, but I'm currently thinking of moving as they are having server problems and I'm experiencing quite a bit of downtime. - They are in the process of exchanging the server, but it's taking longer than they expected. - You will probably be alright if you are signing up today as I guess they would put you on a different server that is working ok.

There are others around, so I would Google and see what you come across (look for hosting reviews)

Thanks,
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
oweng
Nuke Newbie
Nuke Newbie
Posts:7
27 Apr 2006 3:23 AM  
Thanks for the info, Lee.

Owen
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > 2 separate DNN Installations using 1 MS SQL database


ActiveForums 3.7

Latest Forum Posts

Yahoo Answers by cdtguru
Hey, i was wondering if anyone knew of a module that would create a similar system to Yahoo Answers...
(catalook) Itempane changes on product pages ?? by Gaz35
Hi , hi , I don’t know if you can help me , here is the site in question http...
RE: Virtual Pc 2007 help by jeff@zina.com
You need to get the Virtual PC's network set up.  Might check the Virtual PC news group: http://www...
DNNCreative Just Keeps Getting Better by jeff@zina.com
Kudos on issue 39, the article on importing large quantities of data was both timely for me and spot...
RE: Videos by clippy
Hello from France My question is about the videos for beginners, and specially n° 3; I'm working...
skinning trouble by derpir
HelloI have uploaded a skin to my DNN-website, but I want to make som changes. I have made some chan...
RE: Column width in UDT by VickySwift
In case anyone else is looking for the answer to this, I have been able to add the headers back in b...
RE: search not working by jncraig
Did you either reindex the site to turn on the scheduled task to do it?
RE: Template Issue by jncraig
No, you need to install your custom modules before you use the template.
RE: error message in registration page by jncraig
I'm not sure that you can avoid them, short of rewriting the module.You might want to investigate Dy...
Template Issue by Bobbyjosephg
Hi,   Today I have come up with a problem with templates.I was successful in exporting a template an...
RE: search not working by sanju_k1421
I checked     host==>admin search  page   that is set both limits min //max  page     still i m n...
RE: error message in registration page by coder247
but how do I avoid the error messages provided by default in dnn?
RE: Style sheet does nothing by andorz
Oh. I was told to do that in my thread at the dotnetnuke.com forum. http://www.dotnetnuke.com/Commun...
RE: Videos by clippy
Thank you to answer so quickly. It's really kind from you. I appreciate
RE: Simple subscribe newsletter module by jncraig
I seem to recall that DataSprings has an "Opt In" module. I haven't used it, though.
RE: Videos by jncraig
No, you can view them in any order.
RE: Skim Question by tlsadler
Wow! Went to Snowcovered and the 50% off Promo more then paid for itself. I actually wound up buying...
Videos by clippy
Hello from FranceJust a little questionIs there any order to respect to look the videos ("issues"). ...
RE: Skim Question by tlsadler
Thank you very much. I've followed many of your posts and will check it out. I had thought about get...
AppTheory
RSS Feeds