Creating the Database User Account
Click Start, click Programs, click Microsoft SQL Server 2005 then click SQL Server Management Studio.
Log in using Windows Authentication or as the “sa” SQL account.
On the left of the central screen, expand the top level SQL Server name you wish to place the database beneath, then expand the Security directory and click on the Logins directory.
Right-click on the Login menu option and a popup menu will appear. Click the New Login menu option.
In the Login Name field, enter the user account name value as per the pre-installation questionnaire. If none is specified, use “DataAcademy”.
Select SQL Server Authentication and enter the password as per the pre-installation questionnaire. If none is specified, use “dada”.
Deselect Enforce password policy.
Click on the User Mapping page, and make sure that the map checkbox is unticked for all databases. Then set it as owner for model, msdb and master.
Click on OK, and an animation in the lower left of the screen will rotate, displaying a process status of the login creation process. Once completed, you should see the new user appear in the list of users.
Creating the Blank Databases
Expand the Databases directory.
Right-click on the Databases directory and a popup menu will appear. Click the New Database menu option.
In the Database Name field, enter the database name value as per the pre-installation questionnaire. If none is specified, use “DataAcademy”.
Press the “…” button to the right of the Owner textbox.
Type in the name of the user account you created earlier, then press the Check Names button to verify the account. If it is verified, you will see the name surrounded by square brackets e.g. [example]. If it is not verified, please ensure you have not made a typo and have indeed created the account as above. Click the OK button once verified.
Usually you will not need to change the Logical Names for the two files. However, the client may deem it necessary for the logical names to be different to the Database Name.
Press the “…” button to the right of the path for each database file, and set the path to wherever the customer would like the databases stored (as per the pre-installation questionnaire). If this isn’t specified, use the default.
You should now have a screen as below.
Click on the Options page from the left.
Change the Recovery Model to Simple, and ensure the Compatibility Level is set to SQL Server 2005 (90).
Finally, check the Other Options list for the State category. This will usually be the bottommost category.
Ensure that Database Read-Only is False; Database State is Normal and Restrict Access is Multi-User.
Your screen should now look similar to the one below.
Click on OK, and an animation in the lower left of the screen will rotate, displaying a process status of the login creation process. Once completed, you should see the new database appear in the list of databases.
Repeat the steps in this section again to create a Data Academy staging database. As before, enter the name of the database given in the pre-installation questionnaire. If none is given, use “DataAcademy_Staging”.
Click on the Start Menu and click on Run. If this option is not visible, press and hold the Windows key on the keyboard and press R. If the keyboard does not have a Windows key, press Control+Alt+Delete, click on Task Manager, click on File and click on New Task (Run).
Type inetmgr and press OK/Run.
Check which version of IIS you are running. The first shows IIS 7 and the second shows IIS 6. IIS5 looks similar to IIS6 but the version will be different.
IIS7
IIS6
IIS7 Preparation
Close the IIS Manager.
Click Start then click on Server Manager.
Click on Roles from the tree.
For Web Server (IIS), check the Role Services to see if "IIS 6 Management Compatibility" is listed.
If it is, please skip the following indented steps. If it is not, then please follow the indented steps below.
Click on Add Role Services and add "IIS 6 Management Compatibility" and its children.
Open a Run Prompt by clicking on the Start Menu and clicking on Run. If this Run option is not visible, press and hold the Windows key on the keyboard and press R. If the keyboard does not have a Windows key, press Control+Alt+Delete, click on Task Manager, click on File and click on New Task (Run).
Type the following, followed by enter, to open a command prompt: cmd
Type the following, followed by enter: c:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -u
Type the following, followed by enter: c:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i
Ensure that the following Role Services are listed and installed (if not, please Add them):
- Application Development - ASP.NET, .NET Extensibility, CGI, ISAPI Extensions, ISAPI Filters, Server Side Includes
- Security - Basic Authentication, Windows Authentication
Close the Server Manager.
Click on the Start Menu and click on Run. If this option is not visible, press and hold the Windows key on the keyboard and press R. If the keyboard does not have a Windows key, press Control+Alt+Delete, click on Task Manager, click on File and click on New Task (Run).
Type inetmgr and press OK/Run.
Click on the server name.
Double-click on ISAPI and CGI Restrictions.
Ensure ASP.NET v2.x.xxxxx is set to Allowed. If it is set to Not Allowed, click once on ASP.NET v2.x.xxxxx and click the Allowed link on the right hand side of the window (If ASP.NET v2.x.xxxxx isn’t listed, please follow the Troubleshooter at the end of this document)
Expand the server name, then click on the Application Pools node, and ensure that the DefaultAppPool is set to use v2.0 of the .NET Framework. If there is, make sure it’s started. If there isn’t an entry, follow the Gotcha at the end of this document.
Different IIS sites can run under different Application Pools. To read more about Application Pools, please read this article from the Microsoft Technet Techcenter: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/67e39bd8-317e-4cf6-b675-6431d4425248.mspx?mfr=true
If you are running other websites on the server and at least one of them requires a version of ASP.NET other than 2.0, OR if you would prefer Data Academy to run in its own Application Pool, then you must create a new application pool. To do this, Click on the Application Pools node and then click on the Add Application Pool entry. Give the Application Pool a name, e.g. “Data Academy”. Select the .NET Framework version 2.0, but leave all other options as per the defaults. Click on OK. Click on the Application Pool and make sure it is started. If not, then start it.
Right-click on the Application Pool Data Academy is to be run under, and select Advanced Settings.
Under Process Model, change the Identity property to the built-in account called Network Service.
Click OK.
IIS6 Preparation
Expand the server name, and then left click on Web Service Extensions.
For Data Academy 5.4+
If ASP.NET v2.0 isn’t listed, then please follow the Gotcha at the end of this document.
If ASP.NET 2.0 is Prohibited, click on ASP.NET 2.0 and click on Allow.
For Earlier Versions
If ASP.NET v1.1 (2.0 for Data Academy 5.4 or later) isn’t listed, then please follow the Gotcha at the end of this document.
If ASP.NET v1.1 is Prohibited, click on ASP.NET v1.1 and click on Allow.
IIS6 Web Service Extensions
Different IIS sites can run under different Application Pools. To read more about Application Pools, please read this article from the Microsoft Technet Techcenter: http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/67e39bd8-317e-4cf6-b675-6431d4425248.mspx?mfr=true
If you are running other websites on the server and at least one of them requires a version of ASP.NET other than 2.0, OR if you would prefer Data Academy to run in its own Application Pool, then you must create a new application pool. To do this, Click on the Application Pools node and then click on the Add Application Pool entry. Give the Application Pool a name, e.g. “Data Academy”. Select the .NET Framework version 2.0, but leave all other options as per the defaults. Click on OK. Click on the Application Pool and make sure it is started. If not, then start it.
Click on the Application Pools Node.
Right-click on the Application Pool Data Academy is to be run under, and select Properties.
Under the Identity tab, set the Identity to the Predefined account called Network Service
Press OK.
IIS5 Preparation
No preparation is necessary for IIS5.