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:3352
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:3352
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

Need UK Hosting by Liz
Hi,Not sure if this is the right place, but I am currently with Power DNN, and whilst I am a big fan...
RE: search not working by sanju_k1421
host==>admin search page that is set both limits min //max page reindex content button is ...
RE: No Access for me too by leesykes
hello,I have fixed the problem and I have given you a years access beginning from today December 2nd...
old skins for DNN 4.9.0 ? by clippy
Hello from France My question is about the videos for beginners, and specially n° 3; I'm working...
Web.config Error by derpir
HelloI got this error, does this seem familiar to you? Can anyone say how to fix this error?Error 98...
No Access for me too by ristori
I suscribe for the magazine novembre 2008 13. I receive this ticket from Paypal : Prix de l...
How can I list our offices by country by bluehoops
Hi everyone!Apologies if this is a simple question, but it is driving me nuts.I run a small ISV and ...
RE: DNN Creative vs FireFoX V3 by DavidWSnow
It now looks like the error'ing extension is StumbleUpon and it effects FireFox on some, but not all...
Issue 39 Authentication by DavidWSnow
I was glad to see you address this topic. When LiveId was first added to DNN, I tried to implement i...
RE: (catalook) Itempane changes on product pages ?? by Vilaplana
Hi, I think the problem is been caused by your skin and not by Catalook itself.  In the main page, C...
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...
DotNetNuke Modules
RSS Feeds