CA Identity Manager An account creation in MS SQL Endpoint is failing for the DB name with a dot symbol

Products

• CA Identity Manager

Issue/Introduction

 Whenever trying to create an account with the Database Name having a dot symbol(ex, DB Name: 123.xyz) in MQ SQL Endpoint, it is failing with an error.

 msg: Connector Server Add failed: code 32 (NO_SUCH_OBJECT): failed to add an entry MS SQL Server,dc=im,dc=etasa:SQL: Database'123' does not exist. Make sure that the name is entered correctly. (ldaps://xx.xx.xx.xx:20411)

 

Environment

Vapp 14.5.1 CHF1

Cause

A dot symbol within the Database name is causing the issue 

Resolution

The valid characters for MS SQL database names are below

Letters (a-z, A-Z)

Numbers (0-9)

Underscores (_)

However, dots (.) are reserved for separating database, schema, and table names, and cannot be used in a database name.