Problem with dot (.) character in database or table names with SQL server

[Sonja_Bauernfeind]

In Qlik Sense It's not possible to preview tables and fields in a SQL database if the databas name contains a dot "." character. Dot characters in field or table names can also be problematic. 

Environment:

Qlik Sense Enterprise on Windows 

Cause:

Dot in database names is generally considered bad practice and should be avoided:
 

• https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3b892d22-d7ab-450a-be85-0e08e850d97e/databa...
• https://stackoverflow.com/questions/34621779/query-database-with-dot-in-its-name
• https://dba.stackexchange.com/questions/1166/is-it-okay-to-put-dots-in-sql-server-database-names

Resolution:

You can try switching Sense to Legacy mode and manually constructing the connection string: See Disabling standard mode

However there is no guarantee that will help, the best solution is absolutely to follow best practices and avoid dot in any database or table names.