Trouble Deploying

jluc311 · March 6th, 2009, 01:04 AM

Hi, I'm using Appliedi.net as my hosting site. I've deployed everything over to their servers including db. I am able to remotely connect to their sql server and access the db on my local however when i run the site, I'm receiving the generalservererror.aspx page.
below is my connectionstring details. Is their a problem here? Like I said everything works fine on my local. What did I miss?

Code:

<connectionStrings>
<removename="LocalSqlServer"/>
<addname="LocalSqlServer" providerName="System.Data.SqlClient" connectionString="Data Source=sql2k5f.appliedi.net;Initial Catalog=aspnetdb;User ID=userid;Password=userpassword" />
</connectionStrings>

Lee Dumond · March 6th, 2009, 02:13 AM

Perhaps you should set customErrors mode="Off" temporarily so you can see what the real error is...

jluc311 · March 6th, 2009, 11:24 AM

Hi Lee, I did as you said, and received the following error:

The 'System.Web.Profile.SqlProfileProvider' requires a database schema compatible with schema version '1'. However, the current database schema is not compatible with this version. You may need to either install a compatible schema with aspnet_regsql.exe (available in the framework installation directory), or upgrade the provider to a newer version.

What do you suggest as I'm very new to this?Thanks!

Lee Dumond · March 6th, 2009, 06:06 PM

Something happened to the dB such that it is not finding the proper tables/columns/whatever to provide Profiling services.

Are you sure you deployed it correctly, with the proper schemas and everything?

m22 · March 21st, 2009, 04:00 AM

aspnet_regsql.exe, find this exe in the .NET installation on your LOCAL machine. you can ask it to set up the Database schema on the production server machine.

for the longest time i tried to get the exe onto the production server instead of just running it on my local machine (ie, the one that has Visual Studio installed).

mitch
(old timer having a hard time coming up to speed on this consarned new fangled internet dealie.)

Steve S · March 21st, 2009, 01:09 PM

you might want to check the online database to see if the aspnet_* tables are included in it. That is what the reference to aspnet_regsql.exe is about, it installs the aspnet_* tables and procedures.

If you have a working development version of your database on your local machine you can use the server explorer in Visual Studio, right click on the database and publish it to generate a sql script that will, depending on the setting you choose in the publish wizard, export schema and data. Running the script on your hosted database will give you a copy of your local db for your published site.

m22 · March 30th, 2009, 01:04 PM

Bringing up the DB question:

I'm using Visual Studio 2008 where my website works as I expect it.
When I try publishing to the web, she no work too good.

I would like to keep my development DB 'in sync' with the published DB.
is there an 'automatic' procedure for doing this?

for example, on the development machine, i can create the groups and roles I'd like to have, but I am unsure as to how to do in out in the real world. If I can just copy my local DB out, that would be the easiest.

but this, then, brings up the question of syncing real world with local if the world has been adding to the world DB while I am using the local copy of the DB.

jluc311 · March 30th, 2009, 01:45 PM

i downloaded and used the database publishing wizard to avoid this problem....

m22, I would add a connection (remote) in VS 2008 to the database on the web server. In your webconfig, just use the remote connection as your default connection

Steve S · March 30th, 2009, 02:19 PM

There are several way you can do this, none of them are hands off automatic. But first there are several question I think you should be asking yourself Why do you want to keep two databases in sync? What frequency of synchronization do you need/want? And, if you are adding roles this delves into security and doesn't this mean that coding changes are needed to make the site recognizing new roles?

If you just want to 'play' with data from the live site you can make a backup, download it and install it local on a periodic basis (snapshot); or you could change your development connection string to use the live site's database. If you need to add a few records to the live database, such as roles, you can write a simple sql script to run on the live server to add the records/roles (test it local first to make sure it does what you want). You could set up SSIS packages to move data between databases, this means learning SSIS and creating the packages and running them manually or scheduling them. Finally you could set up merge replication, if your host allows this, but then you'd have to learn all about setting up merge replication.

As with most things with computers and software there are many ways to solve the problem, the first priority is defining the problem to be solved.

Good luck

Steve