Skip to main content

How to update Microsoft SQL 2012 Express Service pack on Lync Front End Server?


How to update Microsoft SQL 2012 Express Service pack on Lync Front End Server?

Recently I found out that SQL Express service pack on front end is different than SQL service pack on back end, MSFT mentioned that if SQL service pack is mismatch might affect server performance. (Didn’t really tested, will share my experience later)

 I have recently updated service pack on Front End. Here is the best practices.

First check existing Service pack using below path:

Path: C:\Program Files\Microsoft SQL Server\MSSQL11.LYNCLOCAL\MSSQL\Log

Open any ERRORLOG.n file and see the version details: Look like below

2015-07-08 19:27:41.65 Server      Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

You can verify SQL version using Control panel: below screenshot

Download the Microsoft SQL Server 2012 Service Pack 2 (SP2) Express.

Ie. SQLEXPR_x64_ENU

SQL 2012 SP2 URL:


Copy Service pack to C:\Install or any other folder.

Command:

PS C:\Install> SQLEXPR_x64_ENU.exe /ACTION=Patch /allinstances /IAcceptSQLServerLicenseTerms

 
Now accept the license

Accept the license, Select All DBS.

Click on Next to install Service pack 2.

Now Service pack 2 is successfully installed.


Now check the version again.

C:\Program Files\Microsoft SQL Server\MSSQL11.LYNCLOCAL\MSSQL\Log

2015-08-10 16:06:22.68 Server      Microsoft SQL Server 2012 - 11.0.5058.0 (X64)

You must restart your Lync Server after SQL Service pack updates.

Thank you.

Comments

Popular posts from this blog

Outlook Add-in for Skype meeting getting disable after restarting Outlook.

Issue: Outlook Add-in for Lync meeting getting disable after restarting Outlook.
Problem Statement: Outlook Add-ins gets install automatically when Office 2013 installs (Lync and Skype for Business clients are part of Office package). Add-ins name is Lync Meeting Scheduling Outlook Addin or Skype meeting Add-in for Microsoft Office 2013. Sometime if other add-ins conflict with Outlook add-ins then outlook add-in keep getting disabled. And user has to enable it manually after Outlook restarts. 
Resolution: By default Lync Meeting Scheduling Outlook Addin or Skype Meeting Add-in for Microsoft Office 2013 installs wit load behavior "Load at Startup". However due to some conflict users Lync or Skype add-ins load behavior get changed to loaded instead of "Load at Startup" had to re-enable Lync Meeting Add-In in each time Outlook 2013 was started as it was not set to "Load at Startup". Look at the below screenshot. Now question is how we can change load behavior …

Unable to share desktop in Skype for Business?

Unable to share desktop in Skype for Business?
You can show your entire desktop or just a program to everyone in a Skype for Business Meeting, call, or instant messaging (IM) conversation. However sometime this feature does not work and give different errors.  Error message: ·Cannot start Desktop/Application Sharing due to network issues. ·An error occurred during the screen presentation. Resolution: There are multiple thing which may affect application/desktop sharing. 1.Make sure application / desktop sharing enabled on Skype for Business / Lync Server. SfB /Lync Control Panel > Conferencing > Conferencing policy > select Global or create new policy and set enable ‘Enable application and desktop sharing’. Refer below image. 2.Make sure your Skype for Business (Lync) client is updated with latest cumulative updates. Download latest update Skype (Lync) client. 3.Update your Video and Display drivers. a.Go to Start > Control panel. b.Search for Device Manager, and then open it. c.Find V…

Unable to login to Skype for Business client?

Unable to login to Skype for Business client? In order to sign-in on Skype (Lync) you must have login credential provided to you from your organization. ·Sign-in address: bilag@orgname.com ·User name: orgname\bilag ·Password: ************
Note: Orgname.com is my SIP domain name. Here are the most common mistake people make while sign-in on Skype for Business (Lync).
1.If you have login credential however still unable to sign-in then make sure you are putting proper login credential. Below error shows when you are wrong entering your sign-in address:
2.If you are writing correct Sign-in address however getting DNS error then contact administrator/ Support team there may be a DNS resolution or configuration issue. Administrator need to verify the SfB (Lync) AutoDiscover DNS records. 3.Sometime users password may expired/ lockout: Make sure that you password is not expire and lockout. If yes then call to helpdesk and reset your password / unlock. 4.Make user to have updated Skype for Business cli…