Possible BUG: Database name sensitive in Enterprise Gateway

[gbpucci]

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 database name in lowercase. I'm trying to make this with a database with lowercase name and it work,

Bug ???

"Underlying error message: Cannot open database "dadosadvmp8"
requested by the login. The login failed. Login failed for user  ...."

Thanks !!

[Bjoern]

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.

[gbpucci]

After 15 days waiting a support ticket, no solution until now !!!

[rfritts]

I'm seeing the same thing - results in login failed, with binary collation on for the target db

[gbpucci]

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]