Active Directory Reporter Quick start Guide

(1)

Copyright 2016 CionSystems Inc

Page 1

Active Directory Reporter

Quick start Guide

Software version 5.0.0.0

Jan 2016

(2)

Copyright 2016 CionSystems Inc

Page 2

This guide may not be reproduced or transmitted in part or in whole by any means, electronic or mechanical, including photocopying and recording for any purpose other than the

purchaser's use under the licensing agreement, without the written permission of CionSystems Inc.

The software application in this guide is provided under a software license (EULA) or nondisclosure agreement. This product may only be used in accordance with the terms of the applicable licensing agreement.

This guide contains proprietary information protected by copyright. For questions regarding the use of this material and product, contact us at:

CionSystems Inc. 16625 Redmond Way, Ste M106 Redmond, WA. 98052 www.CionSystems.com +1.425.605.5235 Trademarks

(3)

Copyright 2016 CionSystems Inc

Page 3

Introduction ... 4

Highlights ... 4

System Requirements... 5

Installation ... 5

Installing from a CD ... 5

Installing from the Web ... 6

Installation Wizard ... 6

Configuring CionSystems Active Directory Reporter ... 11

Troubleshooting Installation issues ... 13

(4)

Copyright 2016 CionSystems Inc

Page 4

Introduction

CionSystems Active Directory Reporter provides the best solution to meet Active Directory Reporting requirements. Active Directory Reporter retrieves and reports information efficiently from the active directory while hiding the complexities of the native Active Directory reporting tools and eliminating the need to write scripts. Active Directory Reporter contains 155 out of the box reports and as well as customizable reports. Active Directory Reporter can generate reports to help organizations gather information for regulatory audits including SOX/PCI audits. CionSystems Active Directory Reporter provides a dashboard to view Active Directory status. The Active Directory dashboard can be customized to meet individual user needs.

CionSystems Active Directory Reporter’s efficient delegation model provides role based access for users to manage security permissions with ease. Administrators can securely delegate responsibilities to helpdesk and/or other users thereby reducing administrative workload.

CionSystems Active Directory Reporter allows administrators to receive important reports by email at scheduled times by simply choose the reports to be sent. Each user profile can be configured in Active Directory Reporter to receive the selected report information allowing an administrator to receive different information than helpdesk users.

Highlights

Complex tasks are simplified (no scripting needed).

100% web based - manage Active Directory from anywhere and any PC running a browser.

Search - The search facility retrieves data for the Active Directory object. A search can be made on a specific Active Directory object for a specific user

quickly and accurately.

Dashboard –The dashboard view helps to quickly check the Active Directory object status. Each user can customize their dashboard view.

Email Reports – Reports can be configured and scheduled for automatic delivery to an email address at a prescheduled time.

Web Access - After Active Directory reporter is installed on a system, it can be accessed from anywhere using Internet Explorer.

Print/Export Reports - Reports can be printed or exported to CSV, DOC and PDF.

(5)

Copyright 2016 CionSystems Inc

Page 5

System Requirements

CionSystems Active Directory Reporter needs: • 4GB RAM (8GB Recommended)

• 50 MB of disk space

• Web Browser IE 7.0 or higher • Windows Server 2003, 2008, 2012 • IIS server 6.0 or higher.

• Microsoft Exchange management pack for Exchange 2007+ • Microsoft .NET 4.0 Framework

• Access to Exchange Server 2007, or 2010 or higher

• Access to Windows Active Directory (2000, 2003, 2008, 2008R2, 2012) • SQL Server 2008 or higher Full or Express Edition.

• GPMC

Installation

CionSystems Active Directory Reporter can be installed using a CD or from the web.

Installing from a CD

To install Active Directory Reporter from CD:

1. Insert CionSystems Active Directory Reporter CD into your CD drive. 2. Click on start on start button.

3. Click on My Computer. 4. Double click on CD drive.

5. Double click on ActiveDirectoryReporter.msi. 6. Setup process will start.

(6)

Copyright 2016 CionSystems Inc

Page 6

Installing from the Web

After registration of the ActiveDirectoryReporter trial version, an email will be sent with the link to download ActiveDirectoryReporterr.msi

To install from the website:

1. Open email.

2. Click on the Download Free Trial link.

3. Save ActiveDirectoryReporter zip file to the hard drive.

4. When the download is complete, go to start > windows explorer. 5. Extract the file where ActiveDirectoryReporter zip file was saved. 6. Double click on ActiveDirectoryReporter.msi file.

7. Setup process will start.

8. Go to step 1 in Installation Wizard.

Installation Wizard

The welcome screen will open

(7)

Copyright 2016 CionSystems Inc

Page 7

2. Click Next in System Requirements and Info Screen.

(8)

Copyright 2016 CionSystems Inc

Page 8

4. Click Next in Confirm Installation Screen

(9)

Copyright 2016 CionSystems Inc

Page 9

6. IIS Authentication pop up will appear, enter IIS Username and Password, Click on OK button.

-If the System joined in Domain give domain\username

(10)

Copyright 2016 CionSystems Inc

Page 10

7. Active Directory Reporter installation will be continued.

8. SQL Server Configuration pop up will appear, if u are installing the application for first time then click on ‘Create New Database. In Configuration Details, you can select SQL Authentication or Windows Authentication.

•

For SQL Authentication Enter SQL database Server name, Select SQL Authentication, Enter Login and Password. Enter valid details and click Test Connection. If Test Connection displays connected successfully message. Then, Click on Next.

•

For Windows Authentication Enter SQL database Server name, Select

Windows Authentication, here, Login and Password will be grayed out. Enter valid details and click Test Connection. If Test Connection displays connected successfully message. Then, Click on Next.

Note:

To use the ‘Existing Database’ radio button. AD Reporter Database should already exist in the SQL database.

(11)

Copyright 2016 CionSystems Inc

Page 11

9. When the installation is complete, click Close.

Configuring CionSystems Active Directory Reporter

1. To configure Active Directory Reporter

(12)

Copyright 2016 CionSystems Inc

Page 12

2. The login screen will open in the default web browser, to login on to the application for the first time

Enter “admin” in the User Name dialogue box. Enter “admin” in the Password dialogue box.

Note: It is recommended that user name and password should be changed after the application has launched.

3. Enter the Active Directory Reporter details of the domain.

•

Domain Name. 

•

Domain User Name- It is critical that this user have highest privileges otherwise some of the functionality may not work. Application uses this account as is context.

•

Domain Password. 

•

Enter Domain Controller name.

•

Click on Get Domain controllers.

•

It will show all the domain controllers for that Domain. 

•

Select primary radio button.  

•

Click on save.  

(13)

Copyright 2016 CionSystems Inc

Page 13

Once Active Directory Reporter is successfully installed and launched, the dashboard window will appear with a view of the active directory categories of reports and task list.

For instructions on how the Active Directory Reporter dashboard can be customize to meet individual user needs please refer to “Active Directory Reporter Help Guide”.

Troubleshooting Installation issues

Windows Server 2008 R2

Issue #1

If you see the following error

(14)

Copyright 2016 CionSystems Inc

Page 14

To install the .NET version Click on Below Link

http://www.microsoft.com/en-in/download/details.aspx?id=17718

(15)

Copyright 2016 CionSystems Inc

Page 15

Issue #2

Log on as administrator or run the .MSI as an administrator by holding down shift key and right click the mouse, choose run as administrator.

Issue #3

This happens when .NET 2.0 is not enabled on the system. On Windows 2008

(16)

Copyright 2016 CionSystems Inc

Page 16

enable by going to server manager application, go to IIS server role and enable. Ensure the check boxes matches the following screenshots.

(17)

Copyright 2016 CionSystems Inc

Page 17

Issue #4

In some case, you have to change the Application pool identity to the username and password you provided at install. Process is

- Run Inetmgr.exe from start run

- Goto application pool, then to default app pool.

Issue #5

(18)

Copyright 2016 CionSystems Inc

Page 18

Start the sql server management studio and note the sql connection string and username. You have to provide this username during the install of ADReporter. Otherwise whatever username you provided you have to provide SQL privileges. Also, check the IIS role and ensure the Windows and Basic authentication is enabled.

Issue #6

(19)

Copyright 2016 CionSystems Inc

Page 19

This can happen because the firewall is blocking ports. Check the firewall and SQL to ensure the right SQL ports are open.

Below is an example

(20)

Copyright 2016 CionSystems Inc

Page 20

Click on Surface Area Configuration for services and connectors

(21)

Copyright 2016 CionSystems Inc

Page 21

Click on SQL server, browser, select service startup type as Automatic, Click on OK 2) Now open SQL Server Configuration Manager

(22)

Copyright 2016 CionSystems Inc

Page 22

Select TCP/Ip, go to properties, in properties windows select IP address In IP1 set TCP Port as 1433 and in IPALL set TCP port as 1433, Click on OK Restart SQLServer and SQL server Browser services

To open above ports in Windows firewall run this command from command prompt

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

To connect Remote Database you have to install SQL browser service (for SQL 2008) In firewall enable UDP port (By Default 1434) for SQL Browser

(23)

Page 23

Windows Server 2003

Issue #1

(24)

Page 24

To install the .NET version Click on Below Link

http://www.microsoft.com/en-in/download/details.aspx?id=17718

(25)

Page 25

Issue #2

(26)

Page 26

Issue #3

If the login fails after trying ‘admin’ & ‘admin’ (without quotes): see the solution below

(27)

Page 27

Issue #4

SQL Login fails

This can happen because the firewall is blocking ports. Check the firewall and SQL to ensure the right SQL ports are open.

Below is an example

(28)

Page 28

Click on Surface Area Configuration for services and connectors

Click on Remote Connections, select both TCP/IP and Named pipes

(29)

Page 29

2) Now open SQL Server Configuration Manager

Select Protocols for SQLEXPRESS

(30)

Page 30

Restart SQLServer and SQL server Browser services

To open above ports in Windows firewall run this command from command prompt

netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

Issue #5

(31)

Page 31

Go to ToolsInternet options-Security- Click on “custom level” button Enable Binary and Script Behavior option. Save it, you may have to restart the application again.

Issue #6

When installing the application on IIS6.0 you may see the following screen.

To fix take the following steps.

(32)

Page 32



Now Change ASP.NET version to 4.0.30319 as shown in the below picture

Issue #7

(33)

Page 33

To fix the issue take the following steps

(34)

Page 34



Click on Identity and In Predefined option change to Local system



Click on Save to save the settings

(35)

Page 35

Contact Notes:

For technical support or feature requests, please contact us at [email protected] or 425.605.5325

For sales or other business inquiries, we can be reached at [email protected] or 425.605.5325

If you’d like to view a complete list of our Active Directory Reporter solutions, please visit us online at www.CionSystems.com

Disclaimer

The information in this document is provided in connection with CionSystems products. No license, express or implied, to any intellectual property right is granted by this document or in connection with the sale of CionSystems products. EXCEPT AS SET FORTH IN

CIONSYSTEMS’LICENSE AGREEMENT FOR THIS PRODUCT, CIONSYSTEMS INC. ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY

WARRANTY RELATING TO ITS PRODUCTS INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL CIONSYSTEMS INC. BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL,PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF CIONSYSTEMS INC. HAS BEEN ADVISED IN WRITING OF THE POSSIBILITY OF SUCH DAMAGES. CionSystems may update this document or the software application without notice.

CionSystems Inc 16625 Redmond Way, Ste M106

Redmond, WA 98052 425.605.5325

Active Directory Reporter Quick start Guide

Copyright 2016 CionSystems Inc

Page 1