Have No Choice -- Dotnetnuke SQL Server Database
Have No Choice -- Dotnetnuke SQL Server Database
========================
ISSUE
========================
A bit of a dilemma...
I just researched and discovered that DNN no longer supports MS Access as a db solution. This is NOT good news for me, since I use GoDaddy's free hosting services, which only provides 200mb of SQL Server db storage. For thisreason, I always resort to MS Access to store databases, which willallow me up to 2GB data storage solution. Plenty for the small web applications that I build.
DotNetNuke Forum 3/25/2009:
http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/threadid/297268/scope/posts/Default.aspx
DotNetNuke does not support MS Access any longer. The last version with support for that was DNn 2.1.2 from about 5 years ago
2.1.2 stable
http://dotnetnuke.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=19986
According to security bulletins out there, old releases have issues with security roles. An attacker could access to your site and gain access to private roles. This is a security hole and an important issue
========================
ANALYSIS
========================
So, there's no choice. If I want to use DNN web sites (which I do), I have to use SQL Server Express as the database. Presently, I know how to set this up in GoDaddy; however, my questions remain:
1) Do I really want to begin using DNN when I can build all these tools from scratch? What's the value?
2) What is the initial install size of the DNN SQL Server Express db?
3) Can a small web application such as my Karaoke app (http://karaoke.pcsitter.info) and NEPURS (www.nepurs.info) use a GoDaddy 200mb db with DNN without quickly running out of space?
4) If so, how long before it will utilize the entire 200mb?
5) How do I set up DNN via manual install on my free GoDaddy account?
========================
RESEARCH
========================
1) YES! DNN not only comes with a pre-built administration area but its most useful feature is its built-in, easy to use content management system (CMS). I build web application for others and always build the admin and CMS areas from scratch, so this tool would make my life sooooo much easier! In addition, the free skins all over the internet for DNN sites are awesome. I no longer have to worry about implementing free web templates into ASP.NET. DNN accomplishes this task via skins in minutes.
2) Well, since I had a successfull DNN install on my laptop in VS2008, I decided to view the SQL Server database provided with DNN and see the initial install db size. I can open and view the db contents with VS2008; however, I cannot see the db size. My laptop came with SQL Server 2005 Express, so all I needed was to download the SQl Server Management Studio Express (SSMSS).
http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx#use
After a successful and easy install on my laptop:
1) Opened SSMSS, connected to my local machine as a server.
2) Right-clicked "Database" folder and selected "Attach".
3) Browsed for my Database.mdf file (located in my web app's App_Data folder).
4) Opened the "New Query" window and ran the query below:
EXEC sp_spaceused
Here are the details of a DNN initial db setup (with a few pages added):
Database Size: 8.69MB
Unallocated Space: 0.27MB
Reserved: 7080 KB
Data: 3856 KB
Index Size: 2752 KB
Unused: 472 KB
After a successful install on my free godaddy.com hosting site:
Logged intto GoDaddy hosting and went to Databases -> SQL Server and ran web admin. Ran the same query as above:
EXEC sp_spaceused
Here are the details of a DNN initial db setup (no modifications added):
Database Size: 12.00MB
Unallocated Space: 3.34MB
3 & 4) Currently, I'm unsure. I will build my karaoke app with DNN and analyze the results.
5) Followed these instructions.
========================
SOLUTION
========================
At this point, I cannot say that I can use DNN on GoDaddy with a 200mb SQL Server db limit; however, my plan is to find out. I will rebuild my karaoke app with DNN, add all pages, and then post results.
========================
ISSUE
========================
A bit of a dilemma...
I just researched and discovered that DNN no longer supports MS Access as a db solution. This is NOT good news for me, since I use GoDaddy's free hosting services, which only provides 200mb of SQL Server db storage. For thisreason, I always resort to MS Access to store databases, which willallow me up to 2GB data storage solution. Plenty for the small web applications that I build.
DotNetNuke Forum 3/25/2009:
http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/threadid/297268/scope/posts/Default.aspx
DotNetNuke does not support MS Access any longer. The last version with support for that was DNn 2.1.2 from about 5 years ago
2.1.2 stable
http://dotnetnuke.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=19986
According to security bulletins out there, old releases have issues with security roles. An attacker could access to your site and gain access to private roles. This is a security hole and an important issue
========================
ANALYSIS
========================
So, there's no choice. If I want to use DNN web sites (which I do), I have to use SQL Server Express as the database. Presently, I know how to set this up in GoDaddy; however, my questions remain:
1) Do I really want to begin using DNN when I can build all these tools from scratch? What's the value?
2) What is the initial install size of the DNN SQL Server Express db?
3) Can a small web application such as my Karaoke app (http://karaoke.pcsitter.info) and NEPURS (www.nepurs.info) use a GoDaddy 200mb db with DNN without quickly running out of space?
4) If so, how long before it will utilize the entire 200mb?
5) How do I set up DNN via manual install on my free GoDaddy account?
========================
RESEARCH
========================
1) YES! DNN not only comes with a pre-built administration area but its most useful feature is its built-in, easy to use content management system (CMS). I build web application for others and always build the admin and CMS areas from scratch, so this tool would make my life sooooo much easier! In addition, the free skins all over the internet for DNN sites are awesome. I no longer have to worry about implementing free web templates into ASP.NET. DNN accomplishes this task via skins in minutes.
2) Well, since I had a successfull DNN install on my laptop in VS2008, I decided to view the SQL Server database provided with DNN and see the initial install db size. I can open and view the db contents with VS2008; however, I cannot see the db size. My laptop came with SQL Server 2005 Express, so all I needed was to download the SQl Server Management Studio Express (SSMSS).
http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx#use
After a successful and easy install on my laptop:
1) Opened SSMSS, connected to my local machine as a server.
2) Right-clicked "Database" folder and selected "Attach".
3) Browsed for my Database.mdf file (located in my web app's App_Data folder).
4) Opened the "New Query" window and ran the query below:
EXEC sp_spaceused
Here are the details of a DNN initial db setup (with a few pages added):
Database Size: 8.69MB
Unallocated Space: 0.27MB
Reserved: 7080 KB
Data: 3856 KB
Index Size: 2752 KB
Unused: 472 KB
After a successful install on my free godaddy.com hosting site:
Logged intto GoDaddy hosting and went to Databases -> SQL Server and ran web admin. Ran the same query as above:
EXEC sp_spaceused
Here are the details of a DNN initial db setup (no modifications added):
Database Size: 12.00MB
Unallocated Space: 3.34MB
3 & 4) Currently, I'm unsure. I will build my karaoke app with DNN and analyze the results.
5) Followed these instructions.
http://forums.asp.net/p/893977/958251.aspx#958251
http://www.pcsitter.info/kardnn
- Configured a DNN manual install, since GoDaddy requires paid hosting to auto install DNN with Auto Install.
- Install landing page did NOT have message about not finding sql connection. It found it and installed dnn 5.1.1 site perfectly!
- I edited both web.config and release.config and changed all db references. Changed from sql express db calls to sql server in both files in both appSettings & connection strings. Oh, I also changed the custom error tags as the instructions suggest.
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<!--<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" />-->
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules-->
<add key="SiteSqlServer" value="Server=VisoAdmin.db.2230259.hostedresource.com;Database=VisoAdmin;uid=xxxx;pwd=xxx;"/>
- Also, Godaddy's hosting has SQL Server Web Admin, so you can run it online.
========================
SOLUTION
========================
At this point, I cannot say that I can use DNN on GoDaddy with a 200mb SQL Server db limit; however, my plan is to find out. I will rebuild my karaoke app with DNN, add all pages, and then post results.
Comments