 |
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
|
|
|
|
|
November 25th, 2012, 05:35 AM
|
|
Authorized User
|
|
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
|
|
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
|
|
November 25th, 2012, 05:57 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
November 25th, 2012, 06:07 AM
|
|
Authorized User
|
|
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
|
|
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
|
|
November 25th, 2012, 08:42 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
The Following User Says Thank You to Imar For This Useful Post:
|
|
|
November 29th, 2012, 11:12 AM
|
|
Authorized User
|
|
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
|
|
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..
|
|
November 29th, 2012, 07:33 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
November 29th, 2012, 08:34 PM
|
|
Authorized User
|
|
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
|
|
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..
|
|
November 30th, 2012, 03:51 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
November 30th, 2012, 02:33 PM
|
|
Authorized User
|
|
Join Date: Nov 2012
Posts: 40
Thanks: 8
Thanked 5 Times in 4 Posts
|
|
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..
|
|
November 30th, 2012, 03:53 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
|
|
button below this post to show your appreciation!
