Internal or datetime varchar conversion error on non-EN SQL instances

Summary: When Dell Security Management Server (formerly Dell Data Protection | Enterprise Edition) is installed on a non-English server operating system (French for instance), you may encounter an "internal error" or a "Data access error" in the WebUi console. ...

Acest articol se aplică pentru Acest articol nu se aplică pentru Acest articol nu este legat de un produs specific. Acest articol nu acoperă toate versiunile de produs existente.
Consultați alte resurse

Symptoms

Affected Products:

  • Dell Data Protection | Enterprise Edition

Affected Versions:

  • v9.7 and Earlier

Affected Platforms:

  • Windows Server

Compatibility logs report an error similar to: The conversion of a varchar datatype to datetime datatype created a value out of range.

Cause

Not Applicable

Resolution

In this case:

  1. Open SQL Server Management Studio
  2. Go to the Properties of the Login.
Note: The Login under instance\Security not the User under database\Security, used by the Dell Data Protection services to connect to the Dell Data Protection database
  1. Ensure that the Default database is set to the Dell Data Protection database.
  2. The default language is set to English.
  3. Then restart the Security and Compatibility Server services.

Set the Default database and Default Language
Figure 1: (English Only) Set the Default database and Default Language

To contact support, reference Dell Data Security International Support Phone Numbers.
Go to TechDirect to generate a technical support request online.
For additional insights and resources, join the Dell Security Community Forum.

 

Produse afectate

Dell Encryption
Proprietăți articol
Article Number: 000126660
Article Type: Solution
Ultima modificare: 06 sept. 2023
Version:  8
Găsiți răspunsuri la întrebările dvs. de la alți utilizatori Dell
Servicii de asistență
Verificați dacă dispozitivul dvs. este acoperit de serviciile de asistență.