Lync 2013 Archiving and Monitoring SQL database version mismatch issues

Hello All,


When we try to create Lync 2013 Archiving database & Monitoring database while publishing of the topology.

It creates the Archiving & Monitoring databases but it throws error of Creating database failed with below errors :

Resolution : By default it uses SA account even though if you specified other account. We must need the SA account with default permissions on SQL server where we create the databases. It will successfully create the databases.

------------------------------------------------------------------------------------------------------------------------------------

****Creating DbSetupInstance for 'Microsoft.Rtc.Common.Data.ArchivingDatabase'****

Initializing DbSetupBase
Parsing parameters...
Found Parameter: SqlServer Value sqlserver.domain.com.
Found Parameter: SqlFilePath Value C:\Program Files\Common Files\Microsoft Lync Server 2013\DbSetup.
Found Parameter: Serveracct Value SETINDIA\RTCComponentUniversalServices.
Found Parameter: DbPath Value E:\CsData\ArchivingStore\(default)\DbPath.
Found Parameter: LogPath Value F:\CsData\ArchivingStore\(default)\LogPath.
Found Parameter: LogSize Value 1024.
Found Parameter: LogSize Value 1024.
Trying to connect to Sql Server sqlserver.domain.com. using windows authentication...
Sql version: Major: 11, Minor: 0, Build 3000.
Sql version is acceptable.
Validating parameters...
DbName LcsLog validated.
SqlFilePath C:\Program Files\Common Files\Microsoft Lync Server 2013\DbSetup validated.
DbFileBase LcsLog validated.
DbPath E:\CsData\ArchivingStore\(default)\DbPath validated.
Effective database Path: \\sqlserver.domain.com\E$\CsData\ArchivingStore\(default)\DbPath.
LogPath F:\CsData\ArchivingStore\(default)\LogPath validated.
Effective Log Path: \\sqlserver.domain.com\F$\CsData\ArchivingStore\(default)\LogPath.
Checking state for database LcsLog.
Checking state for database LcsLog.
Checking state for database LcsLog.
State of database LcsLog is detached.
Attaching database LcsLog from Data Path \\sqlserver.domain.com\E$\CsData\ArchivingStore\(default)\DbPath, Log Path \\sqlserver.domain.com\F$\CsData\ArchivingStore\(default)\LogPath.
The operation failed because of missing file '\\sqlserver.domain.com\E$\CsData\ArchivingStore\(default)\DbPath\LcsLog.mdf'
Attaching database failed because one of the files not found. The database will be created.
State of database LcsLog is DbState_DoesNotExist.
Creating database LcsLog from scratch. Data File Path = E:\CsData\ArchivingStore\(default)\DbPath, Log File Path= F:\CsData\ArchivingStore\(default)\LogPath.
Clean installing database LcsLog.
Setting the database LcsLog to restricted mode.
Database LcsLog set to mode Restricted.
Setting database options.
Creating objects from dbcommon.sql.
Creating database objects.
Executing ArchDb.sql...
Updating database roles.
Setting owner for database LcsLog to sa.
Exception Stack:
Type: Microsoft.SqlServer.Management.Smo.FailedOperationException, Message: Set owner failed for Database 'LcsLog'.
Type: Microsoft.SqlServer.Management.Smo.SmoException, Message: An exception occurred in SMO.
Type: System.ArgumentException, Message: The login 'sa' does not exist on this server.

--------------------------------------------------------------------------------------------------------------

I hope it will resolve the issues.

Regards

Anand S


NOTE : If this posts helpful to resolve your issue, please comment.