Exit code: ERROR_NO_DB_DRIVE_ACCESS (-42)

 Issue: Exit code: ERROR_NO_DB_DRIVE_ACCESS (-42) when try to apply Cumulative Update on SQL database on Lync server 2010.

 

 

Problem statement:

While updating Lync Server 2010 Cumulative Update on SQL database you will see the above error. After updating Lync Server 2010 Front End with latest CU (current March 2013 CU). You must update the SQL database backend from Lync server 2010 front end.

Front end servers, once you have installed update for core components, the updated SQL files will be dropped on the server.

Install-CsDatabase -Update -ConfiguredDatabases –SqlServerFqdn –UseDefaultSqlPaths

However you will get the “Exit code: ERROR_NO_DB_DRIVE_ACCESS (-42)” error message after running command.

Error itself says it is access permission issue on database drive.

Best practice to deploy the CU: http://communicationsknowledge.blogspot.in/2013/04/best-practices-to-deploy-cumulative.html

Resolution:

After updated CU on Lync (front end) server and to apply the changes made by LyncServerUpdateInstaller.exe to the SQL Server databases.

I given full permission to domain admin on SQL drive where the database stored and tried to run update commands however it returns same error message.

Later added User/Admin account (which was using for applying the Cumulative updates) to Local Administrator group on SQL server and SQL Admin group (DB) on temporarily.

After given above permission I was able to run the update command on Lync Frond End to apply changes to Backend SQL databases.

Later revoke the access from SQL server.

Command:

 -CsDatabase -Update -ConfiguredDatabases –SqlServerFqdn –UseDefaultSqlPaths

Thank you.