Environment
- App Control Console: All versions
- App Control Server: All versions
- Microsoft SQL Server: All versions
- Non-English language service account user
Symptoms
- Not able to change endpoint polices in the console.
- Endpoint attributes like hostname not getting updated in the console.
- Endpoints not able to connect to the App Control Server.
- In the serverlogs.bt9 the following error message exists:
Statement returned error [241]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversione non riuscita durante la conversione di una stringa di caratteri in una data o ora. Statement: SET NOCOUNT ON;{CALL dbo.RegisterHost (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
Cause
SQL service account user language is not set to English
Resolution
- In the App Control Server stop the following services: "CB Protection Server" and "CB Protection Reporter".
- Open SQL server management studio and logon into the DAS database.
- From object explorer, Go To 'Security'->'Logins'
- Right Click on the account used by App Control Server services and select Properties
- Change the default language to English.
- Save the change.
- In the App Control Server start the following services: "CB Protection Server" and "CB Protection Reporter".