 |
| 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
|
|
|
|
February 17th, 2011, 05:20 PM
|
|
Authorized User
|
|
Join Date: Oct 2004
Location: , , .
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
February 17th, 2011, 05:39 PM
|
 |
Wrox Author
Points: 70,322, Level: 100 |
|
|
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
February 17th, 2011, 06:07 PM
|
|
Authorized User
|
|
Join Date: Oct 2004
Location: , , .
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
February 17th, 2011, 06:19 PM
|
|
Wrox Author
Points: 70,322, Level: 100 |
|
|
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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
|
|
Similar Threads
