TopBanner

Step by Step Installing Lync Server 2013 Monitoring Role Collocated on Standard Edition Front End - Part 2

In Part 1 of Installing Lync Server 2013 Standard Edition we go our lab Lync 2013 server up and running. In this next step by step we will install the Monitoring role using SQL 2008. In Lync Server 2010 a Monitoring required an additional server. In Lync Server 2013 this has changed and Monitoring will be on your Front End.

This article presumes:

  • Server is Windows Server 2012
  • using SQL Server 2008
  • You have Lync Server 2013 Preview installed Using This Blog

So, to get started, lets prepare our Lync Server Front End (Windows Server 2012) by installing Queuing (you will/may not need this in RTM Lync Server). Do this by opening the “Add Roles and Features Wizard”

queuing

Monitoring role requires installing Full SQL 2008R2 or SQL 2012. (SQL EXPRESS will not cut it)

put SQL 2008 CD in place and run Setup.exe.

install-sql-marked

ok | next | next | next…

SQL-Server-Feature-Installation

Feature Selection. Below are the SQL features we need:

  • Database Engine Services
  • Reporting Services
  • SQL Server Books Online
  • Management Tools – Basic
  • Management Tools – Complete

sql-feature-select

Instance Configuration:

Check Named Instance.

NAMED INSTANCE: MONITOR

monitor named

Server Configuration:

NOTE:SQL should run as system account

NOTE: No password required.

SQL-SERVER-CONFIG

Database Engine Configuration:

SQL-database-engine-configuration

Reporting Services Configuration:

  • Native Mode
  • Now click Install (15minute install/wait time)

When done test SQL Reporting Services by running “Reporting Services Configuration Manager” (from Start menu)

Test-SRS

Sure enough, it running!

Test-SRS-2

Associate a Monitoring Store with a Front End Pool and Publish Topology

Open Lync topology builder. Drill down to your Standard Edition front (as shown below) then right click and Edit Properties.

edit topology to include monitoring role

Next we want to add a Monitoring role to this topology by going to General, scrolling down to and selecting “Monitoring (CDR and QoE metrics)” and then click New. We will type input our Front End as the FQDN (as shown), select “Named Instance” and give it the name “MONITOR” (we will later install a SQL instance with this name) and click OK, Ok.

config monitor in topology

Action | Topology | Publish.

publish monitoring topology

Next we will goto Start and open the Lync Server Management Shell (Powershell).

lync server managment shell

Run the below command:

Install-CsDatabase –LocalDatabases

Deploy Monitoring Reports

Run the Lync Deployment Wizard again and click “Deploy Monitor Reports”

deploy-reports-db

Specify credentials to access monitor SQL database. (for this lab I used domain Administrator)

deploy-reports-user

Now reports are being deployed…

deploy-reports-running

Once the reports are deployed you will be presented with URL for reports. You can copy and paste this into Internet Explorer. (grin)

reports-finished

When you click on the reports URL you be presented with:

reports-main

You have successfully installed Lync Monitoring role!

Note: After rebooting this server, SQL Server Reporting Services (MONITOR) did not seem to auto start and need to go into the SRS Config and start it.

Continue your lab with more articles in this Lync Server 2013 Step by Step Series:

33 comments:

  1. Quick addition.

    I was getting errors during the "Deploy Monitoring reports", until I ran the install or update Lync components step 2 first.

    Then it worked perfectly. Loving the guides by the way!

    ReplyDelete
    Replies
    1. Thanks Chris. Ran into the same thing but your suggestion worked perfectly.

      Delete
  2. Hi,

    I am getting the following error when I run the 'Install-CsDatabase –LocalDatabases'

    Install-CsDatabase : An error occurred while creating or updating the database for feature MonitoringStore. For details, see the log file 'C:\Users\..._MONITOR-[2013_01_17][07_52_39].log'
    At line:1 char:1
    + Install-CsDatabase -LocalDatabases
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidOperation: (:SourceCollection) [Install-CsDatabase], ConnectionFailureException
    + FullyQualifiedErrorId : TaskFailed,Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet
    WARNING: Install-CsDatabase failed.
    WARNING: Detailed results can be found at
    "C:\Users\...\Install-CsDatabase-c2c20e20-9699-426d-8198-826afda38867.html".
    Install-CsDatabase : Command execution failed: Failed to connect to server <>\MONITOR.
    At line:1 char:1
    + Install-CsDatabase -LocalDatabases
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidOperation: (:) [Install-CsDatabase], ConnectionFailureException
    + FullyQualifiedErrorId : ProcessingFailed,Microsoft.Rtc.Management.Deployment.InstallDatabaseCmdlet

    Any help on this will be greatly appreciated

    Thanks

    ReplyDelete
    Replies
    1. Not sure what to say offhand, I suggest take this to the lync forum to more input: http://social.technet.microsoft.com/Forums/en-US/category/ocs

      you can always reference that you followed this guide as most are familiar with it.

      Delete
    2. Hi in your SQL Server Networkconfiguration --> Protocols for Monitor the TCP/IP is disabled. Enable it an then it will work.

      Regards Claudius

      Delete
  3. Hi Matt Microsoft says here http://technet.microsoft.com/en-us/library/gg398131.aspx you cannot collocate you lync monitoring DB on your Lync 2013 SE Server. Did you run into any Problems doing so anyways?

    ReplyDelete
    Replies
    1. i suspect this was not documented at preview time when this was written. needs to be updated. thanks!

      Delete
  4. Matt,
    Mine is working fine, but so many sql instance running of the same server is quite heavy.
    The Install-CsDatabase : An error occurred if you didn't select at the installation that all services should run under system account. it is a must to do. i've struggled several days on this too. Also be sure to register your spn for all your instance correctly in AD. notice and resolve all the errors you see about SQL in your event viewer.
    Watch out also if that you installed Reporting Services and then you decide to change the service account, to backup the your encryption keys before and reinstalled them under the new service account. http://support.microsoft.com/kb/842421
    Lync is not only Unified Communications, but you need to be also a good DBA to understand the SQL platform you running on!
    Miguel

    ReplyDelete
  5. I noticed the Monitoring Report screenshot is Lync 2010 not 2013.

    ReplyDelete
  6. Great screen shot explanation. Its a nice blog posted by you. I was seeking for this type of blog that have a fresh and interesting content.

    Hire SSRS developers

    ReplyDelete
  7. Hi, nice method for Installing Lync Server 2013 on sql server 2008.Thanks.....

    -Aparna
    Theosoft

    ReplyDelete
  8. Hi i Already have a SQL server on an other server. What is the powershell command to setup the database on an other server ?

    ReplyDelete
  9. Does this have to be installs as a Named Instance or can I use a Default Instance on a server I already have setup?

    ReplyDelete
  10. Home security systems are simply a great value .Beyond the important peace of mind for you and your family, a home security system has many benefits to protect your home, your family and your possessions.
    Security systems Minneapolis

    ReplyDelete
    Replies
    1. Awesome Artical Really i have searching this type of valuable information From a lot of days i found satisfaction when Read your blog Thanks for giving this type blog and also please Read link bvba Woodstone which provide information server monitoring software & server monitoring software

      Delete
  11. Thanks for sharing informative post about Microsoft Visual Studio. This platform is used to create web application and services. Being widely used software framework, this domain offer huge career opportunity for trained professionals. We at, DOT NET Training offer hands on training in this evergreen technology.

    ReplyDelete
  12. Great information and works perfect for PC based Lync clients. However, I'm having trouble getting report information for UCS phones (Polycom VVX) using Lync. I can get reports on calls from phone to PC, but not phone to phone. Is there anything to enable on the Lync Monitoring server side to catch these calls?

    ReplyDelete
  13. what is the minimum level of access credentials that is required to access the Monitoring SQL DB?

    ReplyDelete
  14. Thanks for sharing this informative blog. If anyone want to get ios training, android training in Chennai please refer this link. Android Training Institutes in Chennai, Android Training in Chennai

    ReplyDelete
  15. Monitor working of your website by using 'Ping' Feature in EazeMonitoring - a software by EazeConnect that is developed for handling the connectivity of Website and its working under your observations. For More details http://eazeconnect.com/eazemonitor.html

    ReplyDelete
  16. Hi, thanks for sharing this wonderful article. Just help me suggesting something about the latest technology Big Data Training in Chennai

    ReplyDelete
  17. Hi, I have read your blog. Your information is really useful for me.Thanks for sharing this blog. I did QTP Training in Chennai at Fita training and placement academy which offer best Selenium Training in Chennai with years of experienced professionals. This is really useful for me to make a bright career.

    Regards...

    Best Software Testing Training Institute in Chennai

    ReplyDelete
  18. I have read your blog it was nice to follow even I am looking for your future updates. Hadoop is a highly growing & scoopful technology in IT market it’s an open-source software framework for managing big data in a distributed fashion on large commodity computing hardware. FITA provides Hadoop training chennai get in to fita and out with your career.
    Hadoop training in chennai | Hadoop courses in Chennai | Hadoop institutes in Chennai

    ReplyDelete
  19. Your posts is really helpful for me.Thanks for your wonderful post. I am very happy to read your post.
    Phonegap Training in chennai | Phonegap Training chennai | Phonegap course in chennai | Phonegap course chennai

    ReplyDelete
  20. This comment has been removed by the author.

    ReplyDelete
  21. This comment has been removed by the author.

    ReplyDelete
  22. Server buddies provides Quality remote server management including troubleshooting, Server Management, Plesk Support, Server Maintenance, Server Monitoring, Server Troubleshooting and support for a large variety of customers at affordable rates. Here are option for Server Management, Server Maintenance, Server Monitoring, Server Troubleshooting, Server Optimization, Plesk Support, Linux Support, cPanel Support and Plesk Support.
    .........

    ReplyDelete
  23. Thanks for posting the useful information to my vision. Java is a programming language, now a day lots of websites & application created using java, because it’s more secure than others and reliable too. The popular JAVA Training institute has located in Chennai helps you to get your bright career.

    JAVA Training in Chennai | JAVA Training Institutes in Chennai | Java training

    ReplyDelete
  24. All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates…
    Regards
    Angularjs training in chennai|Angularjs training chennai|Angularjs course in chennai|Angularjs training center in Chennai

    ReplyDelete
  25. Contact us to hire website service and for your android Application...
    Buzz Applications

    ReplyDelete
  26. Hi. I am unable to find the appropriate version of SQL Server 2008. When I install it there are no instance shown on my Front end server. Please tell me what should I do? Where can I get the appropriate version of SQL server 2008?

    ReplyDelete
  27. Through this you Can create promotional messages / unlimited campaigns can Send to any cell phone in the world with no limit.

    best woocommerce plugins

    ReplyDelete

Note: Only a member of this blog may post a comment.