I am Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 (or SQL Server 2005) and I found that the utility provided by the framework 2.0 and described in the book Chapter 4 page 126 (on the top) as "aspnet_sql.exe" in reality is called "aspnet_regsql.exe". Maybe an earlier version of this utility had the first name.

The whole path (on my machine) is: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspn et_regsql.exe and also I found the utility was unable to connect to my Sql server 2000 by using Sql Server authentication, so I used another Sql server 2000 using windows authentication to generate the DB objects and after this I create an script to create this objects in my real DB server.

A complementary good blog for this Application Service is:

http://weblogs.asp.net/scottgu/archi...25/423703.aspx

Thanks,


Rick P.
Note. Let me know if anybody needs the sql script.

This folder should have SQL scripts already:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
I assume you know that the code for this book requires SQL 2005 for some of the features, like paging. SQL 2000 can't be used with the book's code unless you make some changes.

Eric

Eric,

My company as many others have SQL Server 2000 as repository for all its systems and the migration to SQL Server 2005 can take some months, so I have to go ahead and do my new applications in SQL Server 2000, indeed the pagination will be done in a different way.

Thanks!,

Rick