Introduction to Enterprise Reporter for SQL Server
Enterprise Reporter for SQL Server provides reporting for visibility into Microsoft SQL Server database security configuration, including users, logins, roles and database object permissions. Armed with this information, organizations can perform the security assessments and change history analyses they need for informed strategic planning and proactive management of the IT infrastructure.
Extend your visibility and secure the rest of your Microsoft environment with Enterprise Reporter Suite.
Gain visibility into the configuration of your critical SQL servers to ensure database security and comply with best practices, internal policies and external regulations.
Capture historical configuration information on database objects and view detailed change history reports. Gain in-depth insight for historical analysis and compliance reporting.
Collect and report on permissions to SQL databases, as well as users, roles and logins.
Scale to SQL Server environments of any size. Schedule collections during off-peak hours to minimize the impact of data collection on network and server performance, and leverage the distributed collection architecture for load balancing.
Reduce database storage requirements and save more change history data by comparing SQL Server discoveries and storing only the changes.
Honor departmental and business function boundaries by enabling auditors, help desk staff, IT managers and other stakeholders get exactly the reports they need and nothing more.
Perform efficient, effective data analysis and satisfy the unique informational needs of your organization using predefined reports or creating new reports with additional attributes. Customize any report with advanced filtering, and choose from multiple formats, including PDF, HTML, MHT, RTF, XLS, XLSX, CSV, text and images.
Ensure stakeholders get the reports they need when they need them with automated report generation and flexible delivery schedules.
Disk space requirements will vary with the Enterprise Reporter components you install:
The following operating systems are supported for Enterprise Reporter components.
NOTE: It is not recommended that the server or console be installed on a domain controller.
The follow versions of Active Roles are supported as targets of Active Directory discoveries. See the Active Roles web site for hardware and software requirements for your version of Active Roles:
Enterprise Reporter can be configured to send discovery information to the following versions of IT Security Search. See the IT Security Search web site for the hardware and software requirements for your version of IT Security Search.
The following versions of SQL Server® are supported for the Enterprise Reporter database. See the Microsoft® web site for the hardware and software requirements for your version of SQL Server®:
SSL Encryption of SQL Server Connections using Certificates
Enterprise Reporter can be configured to work with a SQL Server® instance. To secure communications while working with Enterprise Reporter, data sent over connections to the SQL Server can be encrypted using an SSL certificate.
The steps required to configure this encryption are as follows.
To obtain links to the following required software, open the Enterprise Reporter Autorun.
To collect Active Roles information, the following software is required on the computer where the Enterprise Reporter Configuration Manager is installed and on the computer where the Enterprise Reporter node is installed:
For more information and installation instructions, see the Active Roles Quick Start Guide. The following additional considerations are required:
To collect Exchange® 2007 information, the following additional considerations are required:
The following services are required on the Enterprise Reporter server and nodes.
The following services must be enabled on discovery targets for collections.
For more information see the release notes.
Gain in-depth visibility into SQL Server database configuration, permissions and more
In this new report from the Information Security Community on LinkedIn, you will learn how your peers are approaching cybersecurity in the era of cloud, including the latest trends and benchmarks to gauge how your own organization stacks up.
This white paper explains the key provisions of GDPR and why organizations need to take action today to achieve compliance before May 25, 2018, when steep penalties for non-compliance take effect.
This white paper discusses best practices to prevent healthcare data breaches — focused on implementing appropriate strategies, policies, processes, training and cybersecurity defenses — that can mitigate much of the risk that healthcare organizations fac
In this white paper, we provide a checklist for complying with EU GDPR compliance requirements.
Active Directory (AD) security is a constantly moving target. With AD acting as the foundation for resources accessed both on premises and in the cloud, it’s critical to assess what state your AD’s security is in, understanding where to look and what to l
Changes in your AD environment can be indicative of a breach, leaving it unreliable. Explore AD security investigation and recovery plan best practices.
Unless you’ve been hiding under a rock, it’s going to come as no surprise that Office 365 adoption is increasing rapidly. With primary drivers like Exchange Online, SharePoint Online and OneDrive, Office 365 is obtaining an average of around 1 million new
Simplify Microsoft on-premises and cloud-based platform security and compliance reporting
Gain deep visibility into discovery, reporting and project planning on AD and Azure AD
Easily perform capacity planning with efficient file storage analysis and reporting
Simplify discovery, reporting, and assessment on Windows Servers, NAS, and OneDrive for Business
Efficiently track, audit, report and alert on changes to Microsoft SQL Server in real time
Securely collect, store and receive event data from Windows, Unix and Linux systems