Lync 2010 – CU Updates and the SQL Database dropping when ran with User account without sysadmins to the database.

So Microsoft brings out the Cumulative updates periodically for Lync 2010, at the time of writing this seems to be quarterly. As part of the update there is a requirement to update the Lync backend SQL databases with the update which in it own right is a simple update, yet time and time again i hear how people have royally screwed up there Lync environment by not understanding the SQL update instructions OR when they dont have the right permissions to the SQL database when running the update. <sysadmins is required to the databases>

(Below are the Note instructions for SQL as part of the Lync CU updates and where to run the Update from)

<<

Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <EEBE.Fqdn> -UseDefaultSqlPaths

Notes

  • In a Lync Server 2010 Standard Edition environment, run the cmdlet from the Standard Edition server.
  • In a Lync Server 2010 Enterprise Edition environment in which the archiving/monitoring services are collocated with an Enterprise Edition back-end server, run this cmdlet from the Enterprise Edition back-end server.
  • In a Lync Server 2010 Enterprise Edition environment in which the archiving/monitoring services are not collocated with an Enterprise Edition back-end server , run this cmdlet from the Enterprise Edition front-end server.

If the RTCDyn databases are removed after you run the cmdlet without the UseDefaultSqlPaths parameter, run the following cmdlet to restore the RTCDyn databases:

Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn < EEBE.Fqdn > -DatabasePaths <RtcDyn log path>, <RtcDyn data path>

Note The RtcDyn log is located under the path of the rtcdyn.ldf file. The RtcDyn data is located under the path of the rtcdyn.mdf file.

>>

I have experienced first hand when a client runs the update in error (User account does not have sysadmin rights to the Lync databases) and drops the SQL databases, with no way of restoring them. If you are reading this blog as your in the same predicament then do the following to get your Lync environment back online.

ERROR FROM SQL IN THE LOGS

Failed to create database rtcdyn
Error (
name: Error
description:
number: -2147221242
message:
)
—————
Exit code: ERROR_CREATE_DB (-4)

or this one in the deployment log

Error: Script failed (code “ERROR_CREATE_DB”) when installing “BackendStore” on “lync2010SQL01.northernlync.local”. For details, see the following log file: “C:\Users\lyncadmin\AppData\Local\Temp\Create-BackendStore-lyncdbserver.domain.com-[2012_12_24][22_48_19].log”

The users inability to create the necessary databases during this process causes the Lync system to go offline. But dont fear its easily resolved by adding the install account as sysadmin and re-running the Install-CSDatabase command.

Simple!

Rgds

Iain Smith

 

 

Advertisements

2 thoughts on “Lync 2010 – CU Updates and the SQL Database dropping when ran with User account without sysadmins to the database.

  1. Pingback: Lync 2010 – CU Updates and the SQL Database dropping when ran with User account without sysadmins to the datab ase. | Northern Lync « JC’s Blog-O-Gibberish

  2. Pingback: Northern Lync: Lync 2010 – CU Updates and the SQL Database dropping when ran with User account without sysadmins to the database. « Lync News

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s