Title : Implementation Document Release Date: 11/01/2011
Implementation
Document
1
Title : Implementation Document Release Date: 11/01/2011
Contents
Template Information .......................................................................... 3
Document Information ......................................................................... 4
Prerequisite ........................................................................................ 5
Database Creation ............................................................................... 6
Steps to deploy Product....................................................................... 10
[Link] file Modification (for database link) .................................... 12
Report Configuration ........................................................................... 14
[Link] file Modification (for Report server link) .............................. 17
2
Title : Implementation Document Release Date: 11/01/2011
Template Information
Template Name: Implementation Document
Template Identification: Implementation
Template Revision History:
Sr. Version Release Author Reviewer Reason for
No. Date change
1. 1.0 11/01/2011 Sachin Shirish
Bhosale Kadere
2.
Template Authorized by: ______________ Date: _____________
(Director, Operations)
3
Title : Implementation Document Release Date: 11/01/2011
Document Information
Document Name: Implementation Document
Document Identification: Implementation
Document Revision History:
Sr. Version Release Author Reviewer Reason for
No. Date change
1. 1.0 11/01/2011 Anjali Shirish
Kadere
2.
Document Authorized by: ______________ Date: _____________
(Director, Operations)
4
Title : Implementation Document Release Date: 11/01/2011
Prerequisite
1. Microsoft Windows Server 2008 64 Bit Service pack 2
2. Microsoft SQL Server 2008 Standard / Enterprise (Service Pack 2)
3. Microsoft .Net Framework Version 3.5 SP1 and above
4. Mozilla Firefox 3.6 above or IE 7.0 above
5. Microsoft Office 2007 or greater
6. Adobe Reader9.0 or higher
5
Title : Implementation Document Release Date: 11/01/2011
Database Creation
Database creation involves the following steps:
1. Goto Start All Programs Microsoft SQL Server 2008SQL Server
Management Studio which is shown in the screen shown below.
6
Title : Implementation Document Release Date: 11/01/2011
2. Click on Connect in the Object Explorer as shown below.
3. Enter the Server Name, Login and Password and click on Connect in
the above screen which displays the following page.
7
Title : Implementation Document Release Date: 11/01/2011
4. To create a new database, right click Databases folder which displays
the following screen.
5. Enter the name of the new database in the following screen.
8
Title : Implementation Document Release Date: 11/01/2011
6. Click on OK in the above screen which displays the following screen.
7. Create the required schema in the newly created database.
8. Run Scripts in Database which is provided along with the publish:
Script for creating the table.
o Insert Table scripts(which will enable inserting values in the
specific table)
Script for generating Views.
9
Title : Implementation Document Release Date: 11/01/2011
Steps to deploy Product
1. Store the Publish on the local Drive of Server, which you got from the
QC Department of Neorithm Technologies.
For Deploying the Media on Server, need to copy the Media folder on
one of your local drive. And follow the below mentioned steps.
2. Go to Start -> Run, open inetmgr and click OK button as shown below.
10
Title : Implementation Document Release Date: 11/01/2011
3. Right click on Default Web Site ->New -> Add Application in the page
shown below.
Virtual Directory Creation wizard appears as shown below.
11
Title : Implementation Document Release Date: 11/01/2011
4. Provide the proper Alias for the Publish as per Requirement following
the physical path i.e. the location of your hard drive where the Publish
was stored got from NEORITHM technologies.
5. Open Firefox browser using URL: [Link] 1.0 (localhost
should be replaced by the machine/Server name.)
[Link] file Modification (for database link)
9. Go to Publish (ex. D:\CMPublish5.5) and open web [Link] file in
notepad++.
[Link] <ConnectionStrings> and add Data Source= Server name of SQL
server 2008, Initial Catalog=Name of Database , UserId= UserId of
SQL server 2008 and password= password of SQL server and save it.
Ex. Data Source=NEO015\SS2008;Initial Catalog=NewProduct;User
Id=sa; Password=sql#2008;
12
Title : Implementation Document Release Date: 11/01/2011
[Link] the [Link] and publish, clear the cache and open Mozilla
Firefox and add path which is mentioned in Virtual Directory Alias (refer
B)4 screen)with [Link] (for client system
[Link] or <machine ip>/<Alias name>
13
Title : Implementation Document Release Date: 11/01/2011
Report Configuration
The following procedure indicates the ways to configure reports related to the
product implementation.
1. Go to StartAll ProgramsMicrosoft SQL Server 2008 Configuration
ToolsReporting Services Configuration Manager
2. After entering the server name and instance details, click on Connect
which displays the page shown below.
14
Title : Implementation Document Release Date: 11/01/2011
3. Click on Report Manager URL and then on the link that appears
thereafter.
The following browser window opens up.
4. Click on New Data Source which enables creating a new data source
and the following page is displayed.
Enter Server
Name
Enter Database
Name
15
Title : Implementation Document Release Date: 11/01/2011
5. Enter database name, connection string, choose ‘Credentials stored
securely in the report server’ and enter User Name: sa, Password:
sql#2008 and click on Apply.
The above screen displays the newly created folder. Enter the Folder
Name and description and click on OK. The following screen shows up.
6. Select the new folder and click on Upload File which displays the screen
below.
16
Title : Implementation Document Release Date: 11/01/2011
7. Click on Browse to get the report file and specify its name after which
click on OK. This enables creation of all reports displayed in the screen
shown below.
[Link] file Modification (for Report server link)
1. Go to Publish folder and open [Link] file in notepad++ format.
Make the required changes in <appsettings> as shown in below.
2. Change the value against server name and reportServerURI which
completes the [Link] file modification.
17