Last post Jul 11, 2006 10:49 PM by Sheldon
Jul 11, 2006 01:25 PM|Sheldon|LINK
I have been trying to create a sample Personal Web Site using the Starter Kit. In my previous attempts, the Personal Web Site Starter Kit appeared to have run without error. But when I press Ctl-F5 to view the result, I get the following error:
SQL Server 2005 is not installed on my computer; I wish to use my existing SQL Server 2000. I have been searching the web for information about this concept, and the preponderance of postings on forums seemed to indicate that it is NOT possible. However,
I did find one tantalizing message from Vinny Davi posted in May 2005. He mentioned a workaround involving something called aspnet_reqsql. In fact, he included an entire line of code to be run in something he called the "Visual Studio 2005 Command Prompt";
I don't know what that is.
Can someone tell me what aspnet_reqsql is, where I can find it, and whether I can use it to enable the Personal Web Site Starter Kit to work with SQL Server 2000?
Jul 11, 2006 02:23 PM|Freakyuno|LINK
It's actually not difficult at all to set your PWSK up to use Sql 2000 instead of the local database.
Your right, you need to run the aspnet_reqsql - what this does is setup the tables, and stored procedures that the membership system needs to run inside your database. You find this command under your framework foler for .net 2.0
Once this is setup, your going to need to modify your web.config file to remove the LocalSQLServer line, and re-add your membership provider, and role / profile provider as your SQL Server 2000 database.
Read Scot Gu's articles on the membership provider and how to extend it.
When your done with that, you need to let the PWS create a default set of data inside the database, by running it one time using the 2005 MSDE database, when thats done, detach it and run a DTS command on the database, to copy the data and structures over
from your MSDE database, to your SQL Server 2000 database, or...if you are using the enterprise manager, you can just "attach" it to your sqlserver.
You then will need to modify your web config again, to point the remaining items from your PWS's database residing locally to your SQL2000 server using a standard connection string.
Jul 11, 2006 10:49 PM|Sheldon|LINK
Thanks for your response, Bryan, and especially for the link to Scot Gu's articles. There's quite a bit there! It'll take me some time to get through it.
When I got to your instruction to to run PWS "using the 2005 MSDE database", I realized I hadn't made it clear that I did not have MSDE or any other flavor of SQL Server 2005 installed on my computer. The Personal Web Page was blowing up because PWS could
not create a SQL 2005 database, but rather than quitting at that point, PWS was just skipping that step and continuing on its way, then congratulating me on having successfully installed the web site. Go figure.
Anyway, since I knew I was going to have to install 2005 to get PWS to work, I downloaded and installed SQL Server 2005 Express, and now everything, including PWS, works as advertised.