Installing Microsoft SQL Server 2008 Reporting Services
by Tom Pacyk, Andrew Abbate, Alex Lewis
Microsoft® Lync Server 2010 Unleashed
- Title Page
- Copyright Page
- Dedication
- Contents at a Glance
- Table of Contents
- About the Authors
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
- Part I. Overview
- Chapter 1. What Is Microsoft Lync Server?
- Chapter 2. What Is New in Microsoft Lync Server?
- Introducing New Management Tools
- Topology Changes
- New Enterprise Voice Features
- New Call Management Features
- Integrated Mediation Server
- New Presence Features
- New Conferencing Features
- DNS Load Balancing
- Survivable Branch Appliances
- Operating System Support
- New Lync Client Features
- Client Appearance
- The “Me” Area
- Enhanced Contacts
- Privacy Relationships
- Integration with Office and Windows 7
- Whiteboarding and Application Sharing
- Improved Meeting Join Experience
- Conferencing Attendant and Scheduling
- PSTN Dial-In Conferencing Improvements
- Video Improvements
- Manager/Admin Improvements
- Improved Phone Experience
- Summary
- Chapter 3. Feature Overview of Microsoft Lync Server
- Chapter 4. Benefits of Microsoft Lync Server 2010
- Part II. Microsoft Lync Server 2010 Server Roles
- Chapter 5. Microsoft Lync Server 2010 Front End
- Chapter 6. Microsoft Lync Server 2010 Edge
- Chapter 7. Microsoft Lync Server 2010 Monitoring
- Overview
- Installation
- Configuration
- Administration
- Troubleshooting
- Best Practices
- Summary
- Chapter 9. Director
- Part III. External Dependencies
- Chapter 10. Dependent Services
- Chapter 11. SQL
- Chapter 12. Firewall and Security Requirements
- Part IV. Administration and Management
- Chapter 13. Monitoring Microsoft Lync Server 2010
- Overview
- OpsMgr Lync Server 2010 Monitoring
- What Is New in OpsMgr R2?
- How OpsMgr Works
- OpsMgr Architecture
- How to Use OpsMgr
- OpsMgr Component Requirements
- Advanced OpsMgr Concepts
- Understanding OpsMgr Deployment Scenarios
- Multiple Configuration Groups
- Deploying Geographic-Based Configuration Groups
- Deploying Political or Security-Based Configuration Groups
- Sizing the OpsMgr Database
- Defining Capacity Limits
- Defining System Redundancy
- Monitoring Nondomain Member Considerations
- Securing OpsMgr
- Installing Operations Manager 2007 R2
- Installing Edge Component Monitoring Certificates
- Installing the Lync Server 2010 Management Pack
- Best Practices
- Summary
- Chapter 14. Backup and Restore of Microsoft Lync Server 2010
- Chapter 15. Administration of Microsoft Lync Server 2010
- Chapter 13. Monitoring Microsoft Lync Server 2010
- Part V. Migrating from Older Versions
- Part VI. Voice
- Chapter 17. PBX Integration
- Chapter 18. Enterprise Voice
- Chapter 19. Audio Conferencing
- Part VII. Integration with Other Applications
- Chapter 20. Exchange 2010 and SharePoint 2010 Integration
- Overview
- Exchange 2010 Unified Messaging
- Call Answering Rules
- Exchange 2010 Unified Messaging Architecture
- Unified Messaging Users
- UM Web Services
- Supported IP/VoIP Hardware
- Unified Messaging Protocols
- Unified Messaging Installation
- Postinstall Configuration
- Data Storage in Unified Messaging
- Exchange 2010 Outlook Web Application
- SharePoint 2010 Integration
- Best Practices
- Chapter 21. UCMA
- Chapter 20. Exchange 2010 and SharePoint 2010 Integration
- Part VIII. Clients
- Chapter 22. Microsoft Communicator Client for Macintosh
- Chapter 23. Windows, Browser, and Silverlight Clients
- Chapter 24. UC Endpoints
- Part IX. Planning for Deployment
- Chapter 25. Virtualization
- Chapter 26. Planning for Internal Non-Voice Deployment
- Chapter 27. Planning for Deploying External Services
- Chapter 28. Planning for Voice Deployment
- Index
Installing Microsoft SQL Server 2008 Reporting Services
,The Lync Server Monitoring Server leverages Microsoft SQL Server Reporting Services to provide rich reports related to usage and the quality of experience data. This section assumes you already installed SQL and are familiar with the process. Small installations that chose to use the Enterprise Edition of Lync Server can use the same SQL Server as the front end pool; however, most larger deployments require a separate SQL Server, and in very large installations, a separate SQL Reporting Services Server is required. In the steps that follow, you walk through the installation process and post-installation steps for SQL Reporting Services.
During the SQL Server 2008 Installation Wizard, ensure the Reporting Services box is checked and then continue through the wizard.
Tip
Be sure to examine the scalability requirements for your environment to determine whether the Reporting Services role should be placed on the SQL Server or on a dedicated server.
The administrator must also decide where to install the Reporting Services database, either on an existing SQL Server or on the Reporting Services Server. In general, it is recommended you collocate the Reporting Services database on the Reporting Services Server. After the SQL Reporting Services role is installed, it needs to be configured before before the Monitoring Server can use it.
From the Start Menu, navigate to All programs, click Microsoft SQL Server 2008, and then click Configuration tools. Select Reporting Services Configuration Manager. Ensure the appropriate server and instance is selected and click Connect. Then follow these steps:
1. Select the Server Account button in the left column and set the appropriate report server service account.
2. Select the Web Service URL button. Review the settings. Usually the default settings are acceptable. However, if you want to use SSL, you need to pick the certificate to be used. A certificate can be requested from the IIS console.
3. Select the Database button. Ensure the proper database server is set. Ensure the correct credentials are set to access the database.
4. Select the Report Manager URL button. Select the virtual directory to be used to access reports. By default this is Reports.
Now the SQL Reporting Services Server is almost ready. After the Monitoring Server is installed, you need to deploy the Monitoring Server Report Pack to the SQL Reporting Server as reviewed in the following section.
-
No Comment