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

Forum

Forums > Users Lounge > Everything Else
Subject: VWD 2008 & SQL Express 2008?
Prev Next
You are not authorized to post a reply.

Author Messages
DavidWSnow
DNN Creative Magazine Subscriber
Nuke Master
Nuke Master
Posts:131
03 Sep 2008 4:31 PM  
During your Issue 36 video I noticed that you were using VWD 2008.
Are you also using SQL Express 2008? If so is this on Vista or XP Pro?

I just tried to install SQL Express 2008 on XP Pro and ran into some account issues. If you have already resolved them I would be interested in how.

/DaveS
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3426
04 Sep 2008 4:32 AM  
Currently in the latest tutorials I'm using:

Vista Ultimate
Visual Web Developer 2008 Express
SQL Server 2005 Express
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
rc_kemal
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:2
02 Oct 2008 7:20 PM  
Hi Lee,

I installed VWD 2008 and setup my dnn website.
just before I restore the database from localhost to webhosting server.
I realised that the web host doesn't support sql 2008.
I am wondering, if any way, I can configure my VWD 2008 to use SQL 2005 express?
As well as, can I attach my exist database to SQL 2005 express? 
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3426
03 Oct 2008 2:06 AM  
I don't know, when I setup vista I installed VWD2008 and SQL Server 2005 separately, so when I installed DotNetNuke it automatically used SQL server 2005. You could try installing SQL Server 2005 and see if you can either uninstall SQL Server 2008 or set it so that SQL Server 2005 works as default. However the first thing I would do is contact your hosting provider and see if they can convert an SQL server 2008 express database to a SQL Server 2005 database, if they can you don't have anything to worry about and you can just uploaded your database to your web hosting server.
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
rc_kemal
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:2
05 Oct 2008 11:58 PM  
It is very difficult to convert the database from sql2008 express to sql2005 express. To answer my own question, I could not attached exisit database which was attached to sql 2008 express (come with VWD 2008) to SQL 2005 Express.

So a suggestion, if anyone install VWD 2008, you should consider your live web host environment if they are capatable to host sql 2008 database.

For those people have the same situation like me, I would suggest you install VWD 2008 without installing SQL2008 Express. After you install VWD 2008, you can download and install SQL 2005 Express from MSDN website.
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3426
10 Oct 2008 9:35 AM  
thanks for the feedback,
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
You are not authorized to post a reply.
Forums > Users Lounge > Everything Else > VWD 2008 & SQL Express 2008?


ActiveForums 3.7

Latest Forum Posts

RE: Child portal to live site by jncraig
A subscription to this site will let you view the tutorials.  I believe that will be useful.  In fac...
RE: Child portal to live site by psgrzelak
Ok I changed the A record of the Jackson site to point to the IP address of the DNN portal. I than w...
RE: DotNetNuke News 8th Dec 08 by jncraig
Yes, I'm getting an error, also. But ... you can probably get the podcast from this link: http...
RE: Can't Login! Login Page can't be accessed... by jncraig
This table is part of your DotNetNuke database.You might first want to review these tutorials to hel...
DotNetNuke News 8th Dec 08 by pwadding
When I attempt to download the  Podcast I get an error message. Tried both servers. The first few li...
RE: Can't Login! Login Page can't be accessed... by e-kreator
a database that you mean.
RE: DotNetNuke 4.9.1 and 5.0.0 by jncraig
Yes, lots of learning, lots of new things and new ways.  I played a little with Beta6 of DotNetNuke ...
RE: PDF File Content by jncraig
If you want to just serve up the PDF files as PDF files, upload them using the File Manager.  You ca...
RE: Navigating between modules by jncraig
What is the URL that is generated? To which page does it send you?
RE: New Logo cant display by jncraig
There is nothing wrong with this, provided that you did it correctly.  I would have to look at your ...
RE: Child portal to live site by jncraig
You should set DNS to point the URL to the IP address of the DotNetNuke installation.  Inside of the...
RE: PopUp Page by jncraig
To open a link in a new window, format the link this way:Link to us! It is the target="_blank" that...
RE: How to Change fckeditor alignment by jncraig
It might be easier to use a different skin for your administrative pages. There have been some ot...
RE: Can't Login! Login Page can't be accessed... by jncraig
If you have access to your database, look at the Portals table.  Make sure that LoginTabID is set to...
RE: Can't Login! Login Page can't be accessed... by e-kreator
Hello my problem is that the configuration management in login page page was sent to a Web page that...
RE: Create new 'host' user? by jncraig
You can change a regular user to a Host, by setting the "Host" user's IsSuperUser set to True in the...
Create new 'host' user? by jonathanbrickman0000
I have a DNN 4.7 web site successfully migrated to a new server.  There is only one hitch:  the 'hos...
RE: split copyrgt option in two lines by jncraig
You can put a in the copyright text. This may or may not put other text (to the right of the copyr...
RE: Can't Login! Login Page can't be accessed... by jncraig
Try: http://localhost/DNN/login.aspx http://localhost/DNN/?ctl=login If neither of those ge...
RE: HOw to upload site from localserver to www.mysite.com by jncraig
View this tutorial:How to transfer a localhost DotNetNuke installation to a live websitePay special ...
DotNetNuke Modules
RSS Feeds