Return
-
Title
GPOADmin Client crashes when re-configuring Version Control Store with SQL -
Description
When configuring the Version Control Store from SQL while using Microsoft SQL Server greater or equal 2014, the GPOADmin client may crash instantly.
NOTE: When initially configuring the Version Control Store for SQL there should be no issue. The issue occurs when re-visiting the Reconfigure Version Control Store page/wizard while SQL has already been configured.
-
Cause
The GPOADmin service account is missing the CONNECT ANY DATABASE permission on the SQL Server. This permission has been introduced in Microsoft SQL Server 2014. -
Resolution
Configure the CONNECT ANY DATABASE permission for the service account.
More information about the new permission in Microsoft SQL Server 2014 can be found in the following article (example):