Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4 > BOOK: Beginning ASP.NET 4 : in C# and VB
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4: in C# and VB by Imar Spaanjaars; ISBN: 9780470502211
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 25th, 2012, 04:35 AM
Authorized User
Points: 207, Level: 4
Points: 207, Level: 4 Points: 207, Level: 4 Points: 207, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
Default Database script deployment to production server

Hi, I am facing a great trouble in deploying mine database to the production server.

Technology:
ASP.NET 4, Visual studio ultimate, SQL Express edition 2005

Production server:
1 database allowed, Parallels Plesk 11,database submission by .sql scripts

I have successfully created the site-database using the script created by publish option, but whenever i execute the ASPNET.mdf.sql script it gives me

Error 500. There is a problem with the resource you are looking for and it cannot be displayed

Someone please help or guide to proper solutions.

thanks
Reply With Quote
  #2 (permalink)  
Old November 25th, 2012, 04:57 AM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,052
Thanks: 80
Thanked 1,581 Times in 1,558 Posts
Default

Hi there,

You'll need to talk to your host to figure this out. They may not support generating the necessary table objects like this or there may be an error in the script or the way they handle it. I think only they can tell you what's going on.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #3 (permalink)  
Old November 25th, 2012, 05:07 AM
Authorized User
Points: 207, Level: 4
Points: 207, Level: 4 Points: 207, Level: 4 Points: 207, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
Default

Well thanxs sir for replying,

I saw a thread where you replied usage of aspnet_regsql. Am i missing this thing.

Single database for ASPNETDB.mdf and database.mdf

this is the link
Reply With Quote
  #4 (permalink)  
Old November 25th, 2012, 07:42 AM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,052
Thanks: 80
Thanked 1,581 Times in 1,558 Posts
Default

aspnet_regsql is used to populate a database with the required schema. That is probably not going to work for you, as I don't think your database is accessible over the Internet. You could also try to manually running the SQL scripts found in the C:\Windows\Microsoft.NET\Framework64\v2.0.50727 folder.

Cheers.

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
07Raghav (November 29th, 2012)
  #5 (permalink)  
Old November 29th, 2012, 10:12 AM
Authorized User
Points: 207, Level: 4
Points: 207, Level: 4 Points: 207, Level: 4 Points: 207, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
Default

Hi Imar,

Please do shatter some light on this post.

http://blog.krisvandermast.com/Creat...pnetdbmdf.aspx

Is it what i am looking for? Mine provider mentioned that i am using some local instances.. and other things which is causing the sql script to generate errors ?

Mine main issue is I am unable to generate the aspnetdb.mdf [the login/membership database] over the production server

Thanks

Last edited by 07Raghav; November 29th, 2012 at 01:23 PM.
Reply With Quote
  #6 (permalink)  
Old November 29th, 2012, 06:33 PM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,052
Thanks: 80
Thanked 1,581 Times in 1,558 Posts
Default

Yes, except that this may not work with your remote database as the tool won't be able to access your SQL Server. Appendix B discusses this tool as well.

In your case, I would try one of the following:

1. Run the SQL files I pointed to directly against your server.
2. Prepare your database locally by merging both databases. Appendix B has more info. Then generate a script for this database as described in the book and deploy that.
3. Find a host that's easier to work with ;-)

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #7 (permalink)  
Old November 29th, 2012, 07:34 PM
Authorized User
Points: 207, Level: 4
Points: 207, Level: 4 Points: 207, Level: 4 Points: 207, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
Default

Hello Sir, Thanks for replying.

Appendix B: page 772 [ASP.NET4]

Do i need to select SQL Server Authenticaton along with username and password or windows authentication whilst configuring the db for application services.
[it's not mentioned there; shall i consider tht application services use windows authentication.]

For mine website i am trying out the SQL server authentication.

Last edited by 07Raghav; November 29th, 2012 at 07:36 PM.
Reply With Quote
  #8 (permalink)  
Old November 30th, 2012, 02:51 AM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,052
Thanks: 80
Thanked 1,581 Times in 1,558 Posts
Default

Hi there,

The wizard and command line tools support both, so it depends on the target database. If it's a local machine and it supports integrated security, use that. Otherwise, use SQL Authentication.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #9 (permalink)  
Old November 30th, 2012, 01:33 PM
Authorized User
Points: 207, Level: 4
Points: 207, Level: 4 Points: 207, Level: 4 Points: 207, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
Default

Hello Sir,

I used successfully the Asp.net SQL server setup wizard but after a few bumps and trials came to realize that the new db tables are empty.

The issue is i originally had used ASP.NET WEB APPLICATION Configuration tool to assign users and roles and then publish command to generate a release folder.

Will I have to go back and do the same right from somewhere in the middle of ma project.

I really am so much tired of searching, trial and learning that i dont know what to do next except for turning again and again to you, sorry if i irritate you with small issues but i really am greatful for whatever i have learnt from the book and you.

Last edited by 07Raghav; November 30th, 2012 at 01:35 PM.
Reply With Quote
  #10 (permalink)  
Old November 30th, 2012, 02:53 PM
Imar's Avatar
Wrox Author
Points: 71,804, Level: 100
Points: 71,804, Level: 100 Points: 71,804, Level: 100 Points: 71,804, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,052
Thanks: 80
Thanked 1,581 Times in 1,558 Posts
Default

Hi there,

The tool just generates the structure. In order to get the data out as well, you need to use the database publishing wizard as explained in the book.

Alternatively, you can create new accounts using the CreateUserWizard. Using the WSAT may not work as it requires direct access to SQL Server.

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
FindControl Problem Production Server GameGorilla BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 March 11th, 2009 03:39 PM
Database Deployment to Shared Servers; SQL Script englere BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 6 May 17th, 2008 07:00 AM
~* Installing MSRS in Production Server *~ chakravarthy_vr Reporting Services 0 March 9th, 2006 08:31 PM
sql server database backup by script mateenmohd SQL Server 2000 4 July 6th, 2004 12:32 PM
values not showing in production server. stewdabaker Classic ASP Databases 1 June 9th, 2004 03:42 PM



All times are GMT -4. The time now is 05:12 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.