The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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 !!
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]