Home » SQL Server Error : 114, Severity: 15. Browse mode is invalid for a statement t

SQL Server Error : 114, Severity: 15. Browse mode is invalid for a statement t

SQL Server Error : 114 Details


SQL Server Error: 114
Severity: 15
Event Logged or not: No
Description:
Browse mode is invalid for a statement that assigns values to a variable.
Severity 15 Description:
Indicates syntax errors in the Transact-SQL command.

Cause

NetBackup VMware backups using SQL Server application protection fails showing unimplemented sql server error code 114(114)

Credentials used for starting (Log on as) the SQL VSS Writer service on SQL Server are not part of the sysadmin role in SQL Server.

Normally the SYSTEM account is part of Built-in Administrators group on the server but if it is not removed due to security hardening.

Solution

Grant sysadmin permissions to the System account (NT AUTHORITY\SYSTEM) on all SQL Server instances that are installed and configured. we can try to perform the VSS backup or use another  local/domain account/group that has sysadmin permissions on the SQL Server online instances for the “Log on as” account permissions that starts the SQL VSS Writer service.

For more information,refer to Microsoft KB article:  SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS)

SQL Server Error Code and solution summary


SQL Server Error: 114
Severity: 15
Event Logged or not: No
Description:
Browse mode is invalid for a statement that assigns values to a variable.

Grant sysadmin permissions to the System account (NT AUTHORITY\SYSTEM) on all SQL Server instances that are installed and configured.

Leave a Reply

Your email address will not be published. Required fields are marked *