Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gbpucci
Frequent Visitor

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 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 !!

4 REPLIES 4
Bjoern
Continued Contributor
Continued Contributor

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]

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors