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

Forum

Forums > Users Lounge > DNN Creative Articles
Subject: Error Restore 2000 to 2005 Express
Prev Next
You are not authorized to post a reply.

Author Messages
jgkirkman
Nuke Newbie
Nuke Newbie
Posts:3
06 Jul 2007 7:42 AM  
Hello All,

I just finished the  first two videos from Issue no 22...really good work the videos really cleared up some issues I have been having.  But I can't get SQL Server Management Studio to restore the 2000 db. I am getting the following error:

System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DNNFUMC2.mdf'. (Microsoft.SqlServer.Express.Smo)

Have I over looked something? Thanks for any help.

John
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318
06 Jul 2007 9:38 AM  
It would appear that you don't have the appropriate access to restore the database. You might want to review the tutorial again -- particularly the part where you create a login and password and also create access permissions for the new user.

Note that the error message says that you dont have access to the target, which is the SQL Server Express database.
Joe Craig
DNN Creative Support
Subscribe to the website
jgkirkman
Nuke Newbie
Nuke Newbie
Posts:3
06 Jul 2007 2:20 PM  

Joe,

Thanks for the response. I am really at a loss, the video says to restore the backup and then create the new logon user and password. Since I have not been able to restore the db I haven't been able to create the users.

Since I am the only one that seems to be having this problem, have I missed some steps along the way? I did follow your exact steps to install SQL Express (Lession 20). By the way in looking at the backup file from the Restore Backup page of SQL Server Management Studio the backup file user is "SQL319/administrator". This is the location of the database on my live site.

I would apprecitate any help.

Thanks,
John
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325
06 Jul 2007 2:25 PM  
Yes you are correct, you need to be able to restore the database before you can create any users. - I have not restored SQL 2000 into SQL 2005 express before so I will have to investigate this, 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
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3325
06 Jul 2007 2:38 PM  
ok, just done a quick test, I too have the same problem.

I've tested this using an SQL 2000 database restore to SQL Server 2005 Express and
SQL 2000 database restore to SQL Server 2005

both have thrown errors, I've run out of time to look any further into it right now as I am currently transferring some databases round for clients, but my first step would be to Google 'transfer SQL2000 to SQL 2005'

I am actually currently doing this in my hosting providers control panel, but you don't see what is happening behind the scenes with SQL Server. - Does any one else have experience with this? Let us know how you get on, thanks,

Lee
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
jgkirkman
Nuke Newbie
Nuke Newbie
Posts:3
07 Jul 2007 5:55 PM  
Instead of spending hours and hours trying to resolve the problem...I had my ISP upgrade my database to SQL 2005. Backed it up and followed the excellent videos and now have my live site running on my local machine. Again, Lee the videos are great!

Thanks,
John
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2318
07 Jul 2007 8:44 PM  
That's an excellent solution!
Joe Craig
DNN Creative Support
Subscribe to the website
video1
Nuke Newbie
Nuke Newbie
Posts:4
25 Sep 2007 3:27 PM  
This might help:

Using SQL Configuration Manager I changed my Logon to 'Local System' and this worked a treat.

So take heart - it does work!!!!

My steps in detail.

1. open up SQL Server Configuration Manager (I am using SQL Server 2005)

2.right click on SQL Sever Express (I assume it is the same for the full version of SQL Server)

3.Choose Properties

4. in the Logon tab - click the built in account radio button and choose 'Local system' from the drop down.

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=169145&SiteID=17
You are not authorized to post a reply.
Forums > Users Lounge > DNN Creative Articles > Error Restore 2000 to 2005 Express


ActiveForums 3.7

Latest Forum Posts

RE: Reversing Limited Access to the Admin Menu by wynnjon
OK-So I've updated the TABS table entries in the database and set the previously modified entries (t...
RE: localhost Install issues by leesykes
If you go to the subscribe page and click on the get free trial button - this takes you to a page wh...
localhost Install issues by cdees
I've set up a local host and want to run DNN for a local development machine.  The host is set up; h...
RE: Reversing Limited Access to the Admin Menu by wynnjon
That is what I thought.  So for my clients that will need to manage user accounts, I can not limit t...
RE: Reversing Limited Access to the Admin Menu by leesykes
I seem to recall it doesn't work
RE: Reversing Limited Access to the Admin Menu by wynnjon
Thanks Lee-  I will give that a try.An additional question- If you place the "User Accounts" page un...
RE: Reversing Limited Access to the Admin Menu by leesykes
all you need to do is reverse the process within the SQL tables.Compare the data to the other rows i...
RE: Module not working when logged off. by leesykes
thanks for the info,
Reversing Limited Access to the Admin Menu by wynnjon
Hi!  I followed the tutorial for limiting the access to the admin menu.  What a great thing!However,...
RE: Trouble installing! Designer trying to be a Developer. by leesykes
glad to hear you found a solution, thanks,
RE: Skim Question by leesykes
You could but you will not be able to have an XHTML compliant page as the SolpartMenu is non-complia...
RE: Include in Menu - Weird Request by leesykes
For your sitemap.xml file - use GSiteCrawlerYou could create the site map before moving the sub menu...
RE: Trouble installing! Designer trying to be a Developer. by awright14
It looks like I had ASP installed in the wrong order.  Copying and pasting this into the Run Command...
RE: Need Help Changing Containers Contentpane's Text Color by leesykes
Hello,Have you tried adding a class to the content area of your container and then styling the p, a,...
RE: Vertical SolpartMenu by leesykes
hello,If you wish to display the admin and host menus within the house menu, you need to enable it i...
RE: Firefox Does Not Display WMV File In Media Module by leesykes
Hello,I have just tested this and I can play a wmv file in Firefox 3.0.3, so it does suggest that it...
RE: advice wanted convert site to DNN while keeping existing asp functionality by leesykes
You could try using the IFrame module in DotNetNuke and then just link the IFrame to the current pag...
RE: Need Help Changing Containers Contentpane's Text Color by CROKeefe
Thanks for the quick update... I know it looks broken right now, but I had the TITLE classes working...
RE: Need Help Changing Containers Contentpane's Text Color by leesykes
The default class for a container is .head so you will find that the .head class will override any s...
RE: Module not working when logged off. by t.ramya85
have to set the cache time to '0' in that module setting.
DotNetNuke Modules
RSS Feeds