Forum Discussion
Possible BUG: Database name sensitive in Enterprise Gateway
Hello !! I'm trying to set up the Enterprise Gateway, my database is configured with Binary collation, and i put the database name in uppercase, but the system returns the error below, with the d...
If lowercase/uppercase switch changes the issue, it is 100% a bug. I had a similar experience with the early SSAS Connector, it was also case sensitive.
After 15 days waiting a support ticket, no solution until now !!!
I'm seeing the same thing - results in login failed, with binary collation on for the target db
A workaround for this problem: create a database with a lowercase name, use this database for connection in gateway. But when creating the data source, use sql query to get the data from an especific database:
SELECT *
FROM [DATABASE].[dbo].[TABLE]
