External database

member4953 · May 24th, 2010, 09:57 AM

Imar,

I am working on a new application that necessarily requires an external database. I have read Chapters 15 and Appendix B and am clearly missing something.

First of all I am using Visual Studio 2010 Premium for the first time. I know you have a new book on this, but I have not gotten it yet. Nonetheless, I am expecting that not much will have changed in this area. I am paying attention to details such as the machine.config file has version 4.0.0.0, which I have replaced in the application's web.config file where you speak of 2.0.0.0 in the text. Second I am using SQL Server 2005 Management Studio, the full version.

The current problem is when I attempt to login, as yet with no credentials in the database, I get the message "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'". I see that this must have been created automatically on the locally created database, but it does not seem to be happening on the database I have setup on the external SQL Server.

Are there other things like this that I need to look for it making the switch between internal and external databases?

Thanks.

Imar · May 24th, 2010, 10:57 AM

Hi there,

Take another look at Appendix B; page 701 and onwards specifically as they show you how to prepare your database and change your connection string (if necessary).

Cheers,

Imar

member4953 · May 24th, 2010, 11:45 AM

Imar,

I used the technique on p. 658, "Using the database publishing wizard" and then ran the resulting script on the SQL Server and it worked perfectly.

Imar · May 24th, 2010, 12:00 PM

Yep, good option too as it creates schema *and* data....

Imar