Installing CS using the MSI
ok, so I just installed CS on my locahost using the MSI and followed the same advice that I used to give Dozing Dogs customers; namely, install on localhost but use your production (hosting company's) SQL Server if possible.
Doing this means that you won't have to move the db, just the web site.
I decided to install into the existing Dozing Dogs web site database, since all db objects are prefixed and won't disturb the existing data. This blog is also using this db, so it should make moving the data easier.
So I entered the DB server name, my existing Dozing Dogs database name and my SQL Authentication (not shown here obviously)
Then on the next screen when it asked for login details on how the web site would login I entered the same SQL Authentication, and made sure that "Create a new user with this information" was unchecked.
It all worked, up to a point. The tables and sprocs got installed, but the wizard still said that the overall process failed. The log is shown below:
Starting Installation
Action Start: PreConditions - 3/1/2006 4:29:12 PM
Action Finished: PreConditions - 3/1/2006 4:29:12 PM
Action Start: DatabaseInstall - 3/1/2006 4:29:12 PM
---------------------------------
Exception:
System.Data.SqlClient.SqlException: CREATE DATABASE permission
denied in database 'master'.
at CommunityServerInstall.WebApplicationInstaller.Actions.
DatabaseInstall.Do(IDictionary bag)
at CommunityServerInstall.WebApplicationInstaller.
InstallerController.Install()
---------------------------------
Action Start: DatabaseUsersCreation - 3/1/2006 4:29:13 PM
---------------------------------
Exception:
System.Data.SqlClient.SqlException: User does not have permission to
perform this action.
at CommunityServerInstall.WebApplicationInstaller.Helpers.SqlConfig.
CreateUserInDb(String connectionString, String userName)
at CommunityServerInstall.WebApplicationInstaller.Actions.
DatabaseUsersCreation.Do(IDictionary bag)
at CommunityServerInstall.WebApplicationInstaller.InstallerController.
Install()
---------------------------------
Action Start: DatabaseStructureCreation - 3/1/2006 4:29:13 PM
Action Finished: DatabaseStructureCreation - 3/1/2006 4:34:39 PM
Action Start: CustomDataInsert - 3/1/2006 4:34:39 PM
Action Finished: CustomDataInsert - 3/1/2006 4:34:41 PM
Action Start: WebSiteInstall - 3/1/2006 4:34:41 PM
Action Finished: WebSiteInstall - 3/1/2006 4:34:41 PM
Action Start: WebConfigUpdate - 3/1/2006 4:34:41 PM
Action Finished: WebConfigUpdate - 3/1/2006 4:34:41 PM
Action Start: GrantPermission - 3/1/2006 4:34:41 PM
Action Finished: GrantPermission - 3/1/2006 4:34:41 PM
Installation Complete.
So I think I have a couple of bugs to fix - the install in fact worked perfectly and installed both the database and setup my localhost virtual folder correctly. I can run http://localhost/cscya and the site comes up, using the remote DB.
But those two errors shouldn't have been reported - the create database and creation of the user should have silently failed - after all, if they fail it means it's already set up ok.
Still, that's step 1 complete. CS installed and running.
ASP.NET 3.5 Web Hosting: 3 Months FREE + FREE Setup - CLICK HERE!