Server 2003 R2 IIS MS-SQL ASP MySQL FlexCMS Howto
March 3rd, 2008======================================================================
Install IIS with .ASP extensions:
======================================================================
Install IIS through add and remove programs in the control panel and the windows component menu on the left.
Or alternatively through > Mange your server. Add role, IIS ( Application Server )
======================================================================
Configure a site with IIS Manager:
======================================================================
Open the IIS manager through Manage Your Server > Application Server ( IIS ) and Select > Internet Information Systems ( IIS ) Manager from the left hand menu.
Note:: Before we get started, know that Server 2003 R2 has ASP v2 already installed and configured much to my gratefulness. Information on how to do so, will not be found in this tutorial, but definitely can be found on your friend http://google.ca
Select your servername from beneath IIS Manager and open it further so you see three containers. IE: Application Pools, Websites and Web Service Extensions. To check and see if ASP v.2 is installed select Web Service Extensions and look to see if ASP.NET v2.xxxxx is allowed. Also enable active Server Pages and Server Side Includes
If the above check was solid, then lets create a site by right clicking web sites and going new > Web Site..
A wizard should magically appear, press next and enter a site description. The following screen is self explanatory, but the one big guy that should be noted is the IP address to use for this website. Verify the information and moving on, enter the location or browse to where your websites home directory should be located. I decided to put the directory in C:\inetpub\wwwroot\
Next for the purpose of this tutorial I gave the website bogus and dangerous permissions. It does make it easier to install web applications and then to tighten down the hatches later.
Before we go anywhere farther right click and go to the properties for the website you just created. Click the ASP.NET tab and change the ASP version from 1.xxx to 2.xxx, apply and exit.
If the website isn't started yet, start it.
======================================================================
Install MS-SQL Server 2005 Standard Edition:
======================================================================
Downloaded Ms -sql standard as an iso from the academic alliance and extracted it. Or alternatively just install it off of a DVD. Might be a little bit easier with the later option.
Install everything except for notifications entity/component on ms -sql server. We don't need it for our environment.
Hopefully after a long few waits everything is installed all “hunky dory” and there is a software suite called Microsoft Visual Studio too located in the Programs menu.
One last step of permissions regarding database stuff is to open up a program located at Start > All Programs > Microsoft SQL Server Management Studio.
Connect when prompted using Windows credentials. Create a database by right clicking on the database tab, go with the defaults and enter a name. Once the database is made, right click on the servername(SQL..bunch of jiberish) and go to properties. Select the Permissions tab from the left hand menu and select the user NT AUTHORITY/NETWORK SERVICE and give it a bunch of permissions to the database. They are pretty self explanatory.
======================================================================
Install FlexCMS
======================================================================
1.)Prerequisites:
1.1) Access to shared or dedicated web space supporting ASP.NET 2.0
1.2) Access to a SQL Server 2005 / SQL Server Express / MSDE / SQL Server 2000 database
2.)Installation:
2.1) Unzip the downloaded installation file to the root folder of the website.
2.2) Using a web browser access the URL of the website home page e.g. Http://142.25.97.129/flex/ You should be redirected to the FlexCMS Setup Wizard.
2.3) The connection to the database must now be established. Provide the name of the machine the SQL Server is running on. If the database is running on a named instance enter that after the machine name e.g. brashr_vpn. Login credentials must also be provided. If you are unsure of these details contact your server administrator / web host.
2.4) After clicking Next the database will be created and setup will move to the final step where the Administrator login must be created. The administrator has unrestricted access to the system. Provide a username and strong password for this account then click Finish.
2.5) You will be automatically logged in and redirected to the site home page to begin constructing your website.
Note:: During the installation you may need to give a file web.config extra permissions to be written to.
Further ASP information:
================================================================
Connecting to a MySQL server:
When installing MySQL download and install the MySQL ODBC 5.1 Driver from the MySQL website http://www.mysql/com/products/connector/obdc This is needed for connections using ASP.
Connecting to a MS SQL server:
The following must be completed:
A.) Mixed Authentication for SQL Server and Windows Authentication mode:
Open Microsoft SQL Server Management Studio > right click on the servername goto properties > Security tab.
B.) Permissions on the sqluser account:
Open Microsoft SQL Server Management Studio > right click on the servername goto properties >then permissions and grant access to sqluser accordingly.
Resources:
================================================================
Tags: 
