Er. alokpandey's Blog

How to install SageFrame?

Posted in ASP.NET (C# & VB), C#, HTML and XHTML, J-Query, JavaScript, LINQ, PLINQ, SEO, SilverLight, VB, WCF by Alok Kumar Pandey on August 17, 2010

SageFrame Installation Guide

The secret to a successful install is getting theprerequisites right first before you start the install. If everything isprepared correctly first, then installation is straightforward and painless!

Installing SageFrame is easy if you knowhow,yet there are a large number posts on the SageFrame “Install It!”forum from people who are having install problems ranging from mild tosevere.  Why is this?  The answer is that many first time installersdo not get the prerequisites right before they start to install.

Thisguide to SageFrame install prerequisites assumes that you have direct access tothe computer– for those using a hosted account, instead of installing these prerequisites,just ask your hosting provider if these prerequistes are already set up foryou, and if their control panel software will install SageFrame for you.

Youmust firstinstall these items, in this order:

1. Internet Information Server (IIS) .
2. DotNet Framework 3.5 minimum.
3. SQL Server (Express or 2005 or 2008).
4. If you are using SQL server express then you must also install SQLserver management console for SQL server express (a seperate download

There are 5 basic stepsto a clean install.

  1. Download the .zip file from
  2. Create the database and a SQL Server login
  3. Create the website folder and unzip the downloaded .zip file.
  4. Create virtual directory in Internet Information Service(IIS) and configure the website
  5. Run the SageFrame installation wizard in your favorite web browser.

1. Download file from

After you have logged into, navigate to “Download SageFrame”, selectthe desired the latest versions install package and save to your C: drive (forour example, I selected and downloaded the SageFrameSource Version ( the source code version of SageFrame allows you to make changes tothe core code of SageFrame.

2.Create the Database, SQL ServerLogin, and Database User

There are two things you need to do inSQL Server Management Studio. First, create a database.Second, create the SQL Server login for that very same database. Make surethat your database server runs in “mixed authentication mode” (SQL Server andWindows Authentication mode” is checked.) You can find this setting byright-clicking on your server (first node in the SQL ServerManagement Studio tree on the left), then Properties | Security.

Create the Database

  • Open SQL Server Management Studio
  • Select your desired server from the drop-down list and connect
  • Expand the tree on the left-hand side so you can see “Databases”
  • Right-click on “Databases”
  • Select “New Database”
  • In the “Database Name” field enter a name for your database and click OK. For this example, I entered “SF100”
  • You now have an empty database called SF100

Creating a login for your database:

  • Expand the Security node of your server
  • Right-click on Logins
  • Select “New Login”
  • Enter your desired login name. You must remember this login name and password as we will use it later. For my purposes here, I’ve entered “SF100Login” (without the quotes) as my login name.
  • Select “SQL Server Authentication” and enter a password. I entered “test” as my password.
  • Uncheck “Enforce Password expiration/User must change password at next login”
  • Click “User Mapping” on the left
  • Select/Check the new database you created in the top grid “Users mapped to this login:”
  • Select/Check db_owner in the bottom list “Database role membership for: “
  • Click OK
  • Now look in the Security node under your database (SF100) and you will see a newly created database user listed, meaning we also created a new database user by mapping our SQL Server login to our database.

The database portion is now complete.

3. Create thewebsite folder and unzip the downloaded .zip file.

In this step, we create a folder andunzip the source code version SageFrame .zip package file to this directory.You can put it directly under C:\inetpub\wwwroot or C:\foldername. Forthis example, I used C:\SF100.

  • In Windows Explorer, create a new folder called SF100 on your C: drive. This will be the folder where your website files will live.
  • Extract (unzip) the file that you downloaded earlier into your desired folder (C:\SF100 in our example)
  • Lastly, you must change the access permissions of your folder. The Windows account that is used to access your site must have full control over your SageFrame root folder. To set this, right-click on the root folder of your site (C:\SF100). Click Sharing and Security. Click the Security tab. If you do not see the Security tab, you must “turn off” simple file sharing for the folder. To do this, select the root folder (C:\SF100) in Windows Explorer. Click Tools | Folder Options. Select the View tab. Uncheck “Use simple file sharing.” Click OK. You can now right-click the folder and access the Security tab.
  • On the Security tab, you will see a list of users who have access to your folder. Windows XP uses the ASPNET account and Windows 2003 uses the NETWORK SERVICE account. Add the account and give it full control permissions.

4. IIS – createvirtual directory and set-up

Now that the database and file systemare in place, we can create the virtual directory in IIS.

  • Open IIS and expand the tree to see “Default Web Site”. (You can find IIS in Start | Control Panel | Administrative Tools.)
  • Expand the “Default Web Site” node.
  • If you have placed your SF root folder under C:\inetpub\wwwroot, you will already see your website and can bypass this step. If not, you will need to add a virtual directory.
  • Right-click on “Default Web Site”
  • Click New | Virtual Directory
  • Enter an alias – “SF100” will do
  • Click Next and enter/browse to the path to the root folder of your website.
  • Click Next and leave access permissions as is (should be set to Read/Run Scripts.)
  • Click Next and Finish

Now that a virtual directory is inplace, you’ll need to modify its properties.

  • Click on the “Documents” tab
  • An entry for “default.aspx” needs to be added. Add default.aspx and move it to the top of the default documents list.
  • Click on the “Directory Security” tab
  • In the “Anonymous access and authentication control” group box, click “Edit”
  • Make sure that “Anonymous Access” is checked as well as “Integrated Windows authentication”
  • Next, click on the “ASP.NET” tab and make sure that “2.0.50727” is select for the ASP.NET version
  • Click OK to save your changes

5. Run the SageFrameinstallation wizard in your favorite web browser to complete theinstallation process.

The very last step is to initiate the SFinstall via a web browser. The install wizard takes over. In doing so, itcreates tables and stored procedures in your database and adds the needed datarows to these tables to house your site. You will be prompted to test yourfolder’s permissions, test the database connection and lastly, enter yourdesired user name and password for your host and admin user. Write these down!

  • Open your web browser of choice and navigate to http://localhost/SF100/Install.aspx (replace SF100 with the name of your IIS virtual directory)
  • If everything has been configured properly, you will be guided through an install wizard i.e.http://localhost/SF100/Install/InstallWizard.aspx.
  • You will choose the custom install setting.  We will not choose auto option, because the custom install allows us to specify the database information.  Eventhough, the auto option will be disabled if it is your first and fresh SageFrame installation, if you are upgrading your previous version of SageFrame then the auto option will be enabled.
  • Test your folder permissions when requested.
  • Verify your database connection when asked.
  • You will see the wizard running the script for each version after you click “Next”.
  • On successful completion, click on “Finish (Access your Portal)” and your new SF-based website appear.
  • You can login as “SiteAdmin” using UserName: admin and Password: admin
  • You can login as “SuperUser” using UserName: superuser and Password: superuser

NOTE: If while installing, anything goes wrong due tomissing any of the settings above, then delete the database and create a newempty database and start the SageFrame install again.  The reason for thisis that a half completed install will result in a half created database, and itis quicker to start again than it is to fix a half installed database.Otherwise if all settings are configured correctly as mentioned above steps thenyou should check for sqldataprovider .sql scripts files under folderhttp://localhost/SF100/Install/Providers/DataProviders/SqlDataProvider/and rerun the.sql scripts by clicking “Return” button.

For Detail visit

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: