I am having SQL Server Connection issues "com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user " Nothing has changed. I have read most of the posts around ports and connectivity and I do not think that is the issue. I did upgrade the default RDS engine from PostgreSQL 10.6 to 10.9 around the same time, so I am thinking this may be an issue. Some of the connections are still working
Could this be related to the engine upgrade? Assuming it was a successful upgrade.
Should have probably added that I running 0.32.9
It shouldn’t be a problem upgrading metadata backend, but did you close Metabase before upgrading? Otherwise perhaps there was a write during upgrade, which corrupted something.
If you go to Admin > Databases, and edit the MSSQL database (input password too) and Save, does it then start working again?
Haven’t seen this type of problem before - and I’ve upgraded metadata several times, but not those specific versions (and not AWS).
Ok. I just found out that we restored some tables and the old ones were renamed. The permissions went with the renamed tables and as such I did not have access the to correctly name tables. Ugh. Sorry for the confusion.
@flamber Thanks for the suggestion. That is what i was trying but because i was pointed to a table with which I did not have access, it failed. Thanks and sorry for wasting your time. Only 4 hours of troubleshooting!