Last post May 02, 2006 07:07 PM by mikedeko
Apr 30, 2006 10:46 AM|pkspence|LINK
At one point during the installation I'm asked to select the local database instance where the portal database should be installed. The only option in the dropdown listbox is "localhost". When I click on "Test Connection", after a few seconds I get a "connection
failed" message box. IIS is running as well as SQL Server 2000, and the Windows firewall is disabled.
May 01, 2006 07:35 PM|mikedeko|LINK
It's been so long since I installed it that I'm not sure, but this sounds vaguely farmiliar. Anyway, I believe you could just open up Enterprise Manager and run the PortalDB.sql script to create the database and then edit the connection string in the web.config
file to point to it.
Hope this helps.
May 01, 2006 09:35 PM|pkspence|LINK
But the PortalDB.sql script and web.config files are in the .msi file and when the installation pukes, those files are deleted when the installation process rolls-back. I'm in a catch-22 situation here!
May 02, 2006 04:37 AM|Spire128|LINK
If I remmeber correctly during the instalation there is an option to use a remote database, you can select this option and then the kit will install and you will have access to the DB script where upon you can do what the above
May 02, 2006 07:45 AM|pkspence|LINK
May 02, 2006 07:58 AM|Spire128|LINK
I just checked the installation and as I thought you get to a screen which asks you I quote
Where is SQL Sever installed?
the options are
if you select remote you can then install the kit, then change the web conficg to point to your Sql server (even tho it is on your local machine), then run the Sql scripts to create the database tables etc then it will work :)
May 02, 2006 08:01 AM|pkspence|LINK
Exactly where I can I find the the .msi file to download?
Thanks for your quick response!
May 02, 2006 07:07 PM|mikedeko|LINK
You can find the download here
http://asp.net/StarterKits/DownloadPortal.aspx?tabindex=0&tabid=1. I downloaded the C# version and ran the msi. As the other poster stated, you are given the option to run against a "remote" database. When you take this option your Setup folder will contain
several .sql script files to run against your server. A readme.htm file has instructions on what to do.