When trying to connect to our SQL server instance, using windows authentication, I get the error on first attempt:
The conncetion to Microsoft SQL server failed.
Invalid object name 'information_schema.tables'
I can relate the error directly to our sql server environment being case sensitive, in which the valid expression should use 'INFORMATION_SCHEMA.TABLES', instead.
When trying to connect to our SQL server instance, using windows authentication, I get the error on first attempt: The conncetion to Microsoft SQL server failed. Invalid object name 'information_schema.tables'
I can relate the error directly to our sql server environment being case sensitive, in which the valid expression should use 'INFORMATION_SCHEMA.TABLES', instead.