Troubleshooting Tip: FortiClient EMS migration from Windows server to Ubuntu shows the 'Alter failed for Server 'JEJEMS\FCEMS'. (Microsoft.SqlServer.Smo)'
| Description | This article describes how to solve the error 'Alter failed for Server 'JEJEMS\FCEMS'. (Microsoft.SqlServer.Smo)' when migrating the FortiClient EMS server. |
| Scope | FortiClient EMS 7.2.4 version, Linux Ubuntu. |
| Solution | When migrating FortiClient EMS server from windows to Linux Ubuntu by following the steps in this document. In the FCEMS option, select Properties under Security and select SQL Server for Windows Authentication mode.
The following error may appear:
The error is as follows:
------------------------------ TITLE: Microsoft SQL Server Management Studio Alter failed for Server 'JEJEMS\FCEMS'. (Microsoft.SqlServer.Smo) For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=17.100.40.0&Evtsrc= Microsoft.SqlServer.Management.Smo.ExceptionTemplates. FailedOperationExceptionText&EvtID=Alter+Server&LinkId=20476 ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The EXECUTE permission was denied on the object 'xp_instance_regwrite', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/ mssqlserver-229-database-engine-error ------------------------------ OK
This error is related to a permission issue running the DB management tool.
To solve the issue, it is necessary to login using MSQL Mng Studio tool as Administrator, or at least with enough rights. |
