SageFrame Deployment on Windows 7 using IIS
This guide is aimed at users trying to set up their sites using Windows IIS Web Server on Windows 7.
What you need?
- Internet Information Server (IIS)
- DotNet Framework 3.5 with Service Pack 1( SP1)
- SQL Express/Server (2005/2008)
- If you are using SQL server express then you must also install SQL server management console for SQL server expresscode of SageFrame (http://www.microsoft.com/download/en/details.aspx?id=8961)
Steps to clean install
1. Download the .zip file
SageFrame can now be downloaded from http://sageframe.codeplex.com/releases/view/70057 as well. Or alternatively log in to www.sageframe.com and navigate to downloads, select the desired latest install or source versions of SageFrame and save to your local drive. The download is available for both the install and source version. Installing the source code version of SageFrame allows you to make changes to the core code of SageFrame.
2. Create database and SQL Server login
There are two things you need to do in SQL Server Management Studio. First, create a database and secondly, create the SQL Server login for that database. Make sure that your database server runs in “mixed authentication mode” (i.e. SQL Server and Windows Authentication mode” is checked.) You can find this setting by right-clicking on your server in the SQL Server Management Studio. Go to properties and under the security, check the radio button for SQL Server and Windows Authentication mode.
To Create the Database
- Open SQLServer Management Studio
- Select your desired server from the drop-down list and connect
- Right-click on “Databases"
- Select “New Database”
- Give the new database a name. For example db_SageFrame (you can give the database name of your choice). Click Ok
- Now you created an empty database called db_SageFrame
To create a login to 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 example let us give it a login name “MyLogin”(without the quotes)
- Select “SQL Server Authentication” and enter a password. I entered “test” as my password.
- Uncheck “Enforce Password policy”
- Click “User Mapping” on the left
- Select/Check the new database i.e. db_SageFrame(as for example we mentioned earlier) we 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 (db_SageFrame) and you will see a newly created 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 with the newly created database db_SageFrame!!
3. Create the website folder and unzip the downloaded .zip file
In this step, we create a website folder and unzip the downloaded SageFrame .zip package file to this folder. You can place this folder to any of your local drive. As for example we can create a folderE:\SageFrame
- In Windows Explorer, create a new folder called SageFrame on your E: drive (you can use any of your local drive). This will be the folder where your website files get located.
- Extract(unzip) the SageFrame_1_1_Install(1).zip or SageFrame_1_1_Source(1).zip (install or source version of your choice) file that you downloaded earlier into your desired folder (E:\SageFrame 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 SageFrameroot folder. To set this, right-click on the root folder of your site (E:\SageFrame) under properties.Click the Security tab.
- On the Security tab, you will see a list of users who have access to your folder. Add the IIS_IUSRS and Network Service and give them full permission to this folder.
4. IIS - Add New Application and Set up
Step.1 Click the Start button, and type IIS or inetmgr in Search box and press Enter. The Internet Information Services (IIS) manager will start.
Step.2 Right click on “Default Website” in Application Pools and select “Add Application” as shown in an image as below:-
Step.3Enter Alias as for example ‘SageFrameDemo’ and Locate the physical path to the directory you placed the files in. Click ‘OK’
Fig: Incase of Install version of SageFrame
Fig: Incase of Source version of SageFrame
5. Run the SageFrame installation wizard in your favorite web browser to complete the installation process
Now that all the prerequisites have been installed and configured we can start installing SageFrame.The next step to initiate the SageFrame install is via a web browser. The install wizard takes over. In doing so, it creates tables and stored procedures in your database and adds the needed data rows to these tables to house your site. You will be prompted to test your folder’s permissions, test the database connection.
The precise step with the installation of SageFrame is as given below:
- Open your web browser of choice and navigate to http://localhost/SageFrameDemo(replace SageFrameDemo with the name of your Application alias)
- If everything has been configured properly, you will be guided through an install wizard i.e. http://localhost/SageFrameDemo/Install/InstallWizard.aspx
- You have to choose the custom install setting. You will not choose auto option, because the custom install allows you to specify the database information. Even though, the auto option will be disabled if it is first SageFrame Installation.
Install Page 1. Choose the Custom Install
Install Page2. Click "Test Permissions".
Install Page3. Configure the database connection with the necessary credentials
Install Page 4. You will see the wizard running the script for each version after you click "Next"
Install Page 5. On successful completion, click on “Finish (Access your Portal)” and your new SageFrame-based website appear
