I'm trying to connect to a SQL Server database with the On-Premise Data Gateway, but unfortunately I have a period in the name of the database (yes, I know it's a bad idea). The gateway will successfully connect to databases without a period in the name, but I can't escape the name.
For instance:
Database name: Foo.Fighters I've tried [Foo.Fighters] and "Foo.Fighters" in the Database field with not luck.
As soon as I change it to a different DB on that same server, we're all good.
Any thoughts that aren't, change the name of the DB?