Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4 > BOOK: Beginning ASP.NET 4 : in C# and VB
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 25th, 2012, 05: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
  #2 (permalink)  
Old November 25th, 2012, 05:57 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!
  #3 (permalink)  
Old November 25th, 2012, 06: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
  #4 (permalink)  
Old November 25th, 2012, 08:42 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!
The Following User Says Thank You to Imar For This Useful Post:
07Raghav (November 29th, 2012)
  #5 (permalink)  
Old November 29th, 2012, 11: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 02:23 PM..
  #6 (permalink)  
Old November 29th, 2012, 07:33 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!
  #7 (permalink)  
Old November 29th, 2012, 08: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 08:36 PM..
  #8 (permalink)  
Old November 30th, 2012, 03:51 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!
  #9 (permalink)  
Old November 30th, 2012, 02: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 02:35 PM..
  #10 (permalink)  
Old November 30th, 2012, 03:53 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 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!


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 09: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





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.