Geeks With Blogs

Tim Huffam Dotting the I and crossing the T of I.T.

I had to resort to using the web installer as the CS MSI installer didn't work (threw error stating it could not find MDAC 2.7 or above - even though I'm running XP Pro SP2 which has the MDAC components built into it - duh!).

  1. Download CS 2 web install & unzip.
  2. Edit Installer\default.aspx - modify the line:
        bool INSTALLER_ENABLED = false;
    so the installer is enabled eg:
        bool INSTALLER_ENABLED = true;
  3. Using IIS admin, create virtual dir (eg 'cs') pointing to the 'web' dir beneath the installation.
  4. Created a db on sqlexpress. 
  5. Create an account (sql authentication) on the sqlexpress server that ASPNET can use and give it access to the db you just created.
    Either use SQL Server Management Studio Express or Aqua Data Studio.  Note you may need to enable SQL Authentication.  This can be done via the latest version of SQL Server Management Studio Express.
  6. Run the CS installer from a browser eg: http://localhost/cs/installer
  7. When prompted, specify the db login details:
    ServerName: localhost\sqlexpress
    Select Sql Server Authentication
    Enter the details for the login you just created.
  8. Follow the rest of the instructions on screen (it's all very straight forward).
  9. When complete update Installer\default.aspx again so that the installer is disabled eg:
        bool INSTALLER_ENABLED = false;

Now you should be ready to use it, however...

When the installer completed I clicked on the link to the start the app (in my case: http://localhost/cs) - this caused the following error:

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

This was very strange - because during the installation it was connecting to the db just fine.  Also, the db server was working fine (for both pipes and TCP - both enbled and working for other apps).   I suspect the installation process does something to the context of the current web request.  So to work around this I simply opened the url from another browser instance - and bingo it worked.



Posted on Thursday, June 8, 2006 7:24 AM ASP.NET , Community Server | Back to top

Comments on this post: Installing Community Server 2 - web install on XP localhost with sqlexpress

# re: Installing Community Server 2 - web install on XP localhost with sqlexpress
Requesting Gravatar...
I had the same problem and same error everytime I got to the installer login with either Windows or SA credentials. The only way I fixed it was to use Windows Authentication and type localhost\sqlexpress for the server location. It would not let me use my SA account credentials. But at least I got past that part, in the video the show you to leave it as "(local)" for the server address!
Left by Jer on Aug 25, 2008 8:01 AM

Your comment:
 (will show your gravatar)

Copyright © Tim Huffam | Powered by: