Ok, what would we do without you Imar :-).
I'll install the express version as well.

/Lars

I have been trying (and failing) to get WroxUnited to work with 2005 developer edition. I suppose I could take your advice and install 2005 express to get WroxUnited to work, but how would this help me to learn what is needed to connect to the real 2005 database? So far I find nothing in the "Beginning ASP.NET 2.0" book that helps with the database connection.

--
BettyB.
www.flamingo-code.com

Once you're done developing your site with the Express edition, it's pretty easy to move the database to a "real" version of SQL Server....

Everybody says how easy it is to move the database to a "real" version of SQL Server but I just don't get it! How do you do that? Move a SQL Express DB into a SQL 2000 database? When runing aspnet_regsql.exe does that copy the data from the existing appData Folder in to the SQL 2000 tables? What about all of your other custom tables, views, stored procedures,and such? Does it copy them too? If not, how do you get them there? Any help would should be appreciated.

Well, I never said it's easy to move a SQL Server Express 2005 database to a 2000 environment. In fact, that's impossible....

However, it's easy to move a 2005 Express database to another 2005 installation. Simply copy the .MDF file and attach it to the new server.

aspnet_regsql.exe doesn't do anything with data or your database objects. All it does is create a bunch of objects required for ASP.NET like the aspnet_* tables, views and so on. It doesn't touch your database, or copy your data at all.

Take a look at this article to learn more about SQL Server 2005, how to attach a database and how to configure the database and your application so the two can work together.

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395

Re: moving a 2005 to 2000: it depends on a number of factors if you can do this at all. If you're using SQL Server specific features (like the new CTP syntax feature), you're pretty much out of luck. Otherwise, you can script your database using "SQL Server Management Studio" (not sure, but the SQL Server Management Studio Express Edition may support this as well) and then run this script on your SQL 2000 database.

You just need to be aware of the differences between 2000 and 2005. I think in general, it's easiest if you develop on the platform that you intend to use for production as well. Developing against 2005, while deploying on 2000 is likely to get you into problems, or at least into a lot of work.

Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thanks Imar, you have answered my question and I appreciate it. I suspected all along that running the exe would only accomplish the db creation with required tables, views, etc. per the switch settings used in its execution and not move any data. Your comment as to developing using the ultimate deployment version of SQL is appropriate and unfortunately a lesson I have learned the hard way. Thanks for your response I very much appreciate your efforts and feedback.

You're welcome....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

I too get this message:

The user instance login flag is not supported on this version of SQL Server. The connection will be closed.

I am using sql2005, not express. Can some explain to me what themessage means and whether a clear explaination is out there.

Thanks,
Harry

Harry Standley

The answer is in the previous posts in this thread. You need to remove User Instance=True from your connection string as that only applies to SQL Server Express 2005.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

OK I really appreciate your patience. I installed sql express as suggested earlier, same error, removed the user instance and still I get the same error message. Sorry but I am totally lost on this example in the book.

Harry

Harry Standley

Sorry,test .