Hey Everyone,
I have tried searching but no luck yet. For using Recorder with MS SQL, can it be used with SQL Express? In the format I’m not sure how to specify the instance and have tried several things with no luck yet.
Here is one of the examples I have tried.
recorder:
db_url: mssql+pyodbc://myusername:[email protected]\sqlexpress/HASSIO?charset=utf8;DRIVER={FreeTDS};Port=1433;```
In the logs I get the following:
2020-09-18 10:48:17 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: (pyodbc.OperationalError) (‘08S01’, ‘[08S01] [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist (20009) (SQLDriverConnect)’)