Configuring Your Database for the Application Services

guynorton · February 17th, 2011, 05:20 PM

(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

Imar · February 17th, 2011, 05:39 PM

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

guynorton · February 17th, 2011, 06:07 PM

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

Imar · February 17th, 2011, 06:19 PM

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