Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 3.5 > ASP.NET 3.5 Basics
| Search | Today's Posts | Mark Forums Read
ASP.NET 3.5 Basics If you are new to ASP or ASP.NET programming with version 3.5, this is the forum to begin asking questions. Please also see the Visual Web Developer 2008 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 3.5 Basics 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
 
Old February 17th, 2011, 05:20 PM
Authorized User
Points: 160, Level: 3
Points: 160, Level: 3 Points: 160, Level: 3 Points: 160, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2004
Location: , , .
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Default Configuring Your Database for the Application Services

(This is not strictly an ASP.Net question though it was covered in the book.)

I configured my database for application services with aspnet_regsql and uploaded it to Sqlserver using SQL Server Management Studio. When I tried to use these services I received this error:

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

The stored procedures were not uploaded and I have not been able to work out how to do this. Is it even possible with SSMS? If not, how do I upload them? I presume a script would work but I couldn't get the .sql script to run on my hosts server. After 3 weeks of suffering some of the most inept support I have ever encountered I gave up and resorted to using SSMS which seems insufficient for the task....

So, how do I get out of this predicament?

regards, Guy
 
Old February 17th, 2011, 05:39 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,

Have you tried scripting your stored procedures and then running them against the remote database?

You can also take a look in the folder C:\Windows\Microsoft.NET\Framework\v2.0.50727 (or such for *.sql files under C:\Windows\Microsoft.NET). You'll find .SQL files that can create the database schema for you. You probably need at least InstallMembership.sql and InstallRoles.sql and maybe more, depending on your requirements.

Finally, take a look at the Database Publishing Wizard: http://weblogs.asp.net/scottgu/archi...nt-part-1.aspx

BTW: scripting schema (e.g. tables, views, stored procedures) is not enough. Some tables contain data needed to run correctly. The Publishing Wizard should take care of that.

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!
 
Old February 17th, 2011, 06:07 PM
Authorized User
Points: 160, Level: 3
Points: 160, Level: 3 Points: 160, Level: 3 Points: 160, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2004
Location: , , .
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Imar,

I've generated a script but it doesn't execute on the server. I've set everything up as in the (Plesk) documentation, cut and pasted it into the querybox, clicked execute and received no message either of failure or success (failure is definitely the result as the database doesn't create). I've tried using simple scripts, the northwind script, all to no avail. The host help desk (Hostnet.nl) haven't been able to help me at all. Their support doesn't extend much beyond, we can't help you with scripts, all we can do is tell you that the server is up.


regards, Guy
 
Old February 17th, 2011, 06:19 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

If even simple scripts don't work, something is wrong on their end I think. Maybe your account doesn't have sufficient permissions, or any of the other possible 10 million reasons for failure could apply ;-)

I would persuade them to help you, or find a better host....

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
using two database in one application..possible? danielnixon SQL Language 2 May 21st, 2008 06:18 AM
Web Application and Internet Information Services deniscuba VS.NET 2002/2003 0 March 31st, 2005 02:26 PM
Run and Debug Application Using Directory Services tushpri General .NET 0 February 12th, 2005 02:35 AM





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