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

Forum

Subject: Database after backing it up with SQL 2008
Prev Next
You are not authorized to post a reply.

Author Messages
freddymorales
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:4

16 Feb 2010 3:35 PM  
hello mr.Lee I am going thru your videos very well. Thank you! If I have a problem, I usally find a solution on blogs. but after I attached and backed up my DNN database, I can no longer visit my local DNN anymore. I know your tutorials talk about this, and I did the web.config editing, and still can not get it to view my local site, can you help me please? also i just noticed there is not database in my local files after attaching the DB to SQL fmorales
Lee Sykes
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:6011


17 Feb 2010 2:45 PM  
Hello,

When you attached your database to SQL Server can you login to SQL Server using Management Studio and view all of the tables and data?

Did you setup a username and password to access the database?

What are the details you entered into your connection string?

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
Lee Sykes
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:6011


18 Feb 2010 2:00 AM  

When you attached your database to SQL Server can you login to SQL Server using Management Studio and view all of the tables and data?
 
YES

Did you setup a username and password to access the database?

YES on both places the video tutorial told me to; please check out the pictureScreenshot I attached

What are the details you entered into your connection string?

 
<connectionStrings>

<
add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress; Initial Catalog=C:\DNN_SITES\DNN_50202_TUTORIAL\APP_DATA\DATABASE.MDF;User ID=dnnxxx3;Password=xxxx" providerName="System.Data.SqlClient" />

connectionStrings>
<
appSettings>

<
add key="SiteSqlServer" value="Data Source=.\SQLExpress; Initial Catalog=C:\DNN_SITES\DNN_50202_TUTORIAL\APP_DATA\DATABASE.MDF;User ID=dnnxxx3;Password=xxxx" />



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
Lee Sykes
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:6011


18 Feb 2010 2:04 AM  
Which OS are you using?
SQL Server version?

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
Lee Sykes
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:6011


18 Feb 2010 2:06 AM  
If you can attach any pics to the forum post, they would be useful (you can zip them if there are several) 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
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > Database after backing it up with SQL 2008



ActiveForums 3.7

Latest Forum Posts

Request Tutorial For Forms and List by Allen6195
If you have already produced a tutorial for Forms and List, would you please let me know where it is...
RE: Skin Header by mcmanta
ok I edited the home.ascx and inner.ascx and uploaded the skin again. thanks for the help.
RE: "Good" hosting providers by jtgreg77
Hello AJ, I can't say anything about the other two hosting providers, but we at PowerDNN have ha...
Where is the tutorial for the Reports Module? by Allen6195
I'm sorry but I can't find a tutorial on the Reports module.  When I do a search for 'Reports module...
RE: calender and events registration module by jncraig
I'm not aware of any.
RE: Missing blog entries by jncraig
I have not seen or heard of that particular problem before.
RE: Module Installation Error by jncraig
In email I suggested that you manually install one of the modules that failed.  See if errors are re...
RE: DotNetNuke User Profile v5.4 - Issue 58 by jncraig
In the file manager, set the permissions so that logged in users (registered users) have write permi...
RE: Module Installation Error by ollep
Thanks for your prompt reply Joe.I tried the logfile yesterday but had problem saving current (today...
RE: Skin Header by WinXnet
You need to add the link to the button. Right now it is just an image - no link at all! open it with...
RE: Skin Header by mcmanta
sure my web site is twinsprucepa.com if you look I have the header in place but when you click the c...
RE: NAV Menu not showing up correctly... by WinXnet
Try putting something in the separator html, like a div with a class you can work with. Also, y...
RE: Missing blog entries by WinXnet
I never use the dnn blog - it always seems to have issues. If possible, you might want to move to a ...
RE: CSS Skin Height Problem by WinXnet
100% height divs are a bit more complicated than it seems it should be. First - what browsers are...
RE: Skin Header by WinXnet
Not sure what you are asking - you should be able to just create an image button link... Then you...
RE: DotNetNuke User Profile v5.4 - Issue 58 by jerimiahpettigrew
How do you make the "my folder" option the only visible option for the profile image upload....inste...
RE: Tab startdate/enddate by brian_strickland
Thanks tons Joseph... I was actually trying to simplify my explanation so I wouldn't over complicat...
Skin Header by mcmanta
Hello All, I have a DNN5 site and my customer has asked me to create a Contact us button and Dire...
RE: Slow login by jncraig
Make sure that you have uninstalled modules that you aren't actually using.  That will reduce the me...
RE: Customising Registration form by jncraig
You might also look at these:How to Create a Portal Signup Module with OWSHow to Create a Custom...
DNM Rapid Application Developer Trial Version
RSS Feeds