× Search
Friday, June 14, 2024

Collecting Infrastructure Information - Installing SQL Server (Part 1/3)

[Part 1/3] - This video explains how to install Microsoft® SQL Server 2016 and Reporting Services to use CopyRight2's Infrastructure Reporting module.

Collecting Infrastructure Information - Installing SQL Server (Part 1/3)

This is the first part of our video series on how to collect domain infrastructure information using Sys-Manage CopyRight2's Infrastructure Reporting module. The video explains how to install Microsoft® SQL Server 2016 and Reporting Services onto a Windows 2012 R2 server.

Microsoft SQL Server and the accompanying Reporting Services are a requirement if you want to use the pre-installed infrastructure reports.

CopyRight2’s report model will allow you to access these reports using your favorite browser. The advantage of using a report model is that it adds an additional abstraction layer, because tables in a database may not necessarily correlate with entities as you know them in the real world.

For example, the data for a customer, may actually be split into multiple SQL tables or located in more than just 1 database or data source. All of that can be hidden by a properly designed report model.

The Reporting Service’s drill-through feature gives you the possibility to surf through your data via hyperlinks, for example if looking at the members of a group, you can simply click on one of the members and then get detail information on that member account (user or group). Additionally, you can export reports based on a schedule and build custom reports by using Microsoft’s Report Builder, all without knowing a single bit about how to write a SQL query.

Without SQL Server you can still produce infrastructure data using CopyRight2 in a decentralized way and automatically import the results to a central location, for example as text files in CSV format or Access MDB databases. You could then use something like Excel or build a custom solution tailored towards your requirements.



The server that SQL-Server 2016 and the Reporting Services were installed on in this video is running Windows 2012 R2. You could install it on a newer version of Windows, for example Windows 2016 or 2019 as well. CopyRight2 supports older versions of SQL-Server down to SQL-Server 2005 as well. The system has the 64-bit version of CopyRight2 installed.

Terms Of UsePrivacy StatementCopyright © Sys-Manage, 1998-2024. All Rights Reserved.
Back To Top