Connect HA Database as linked SQLServer

Hi All!

I’m pretty new to HA but am getting to grips with it.

I am trying to setup an ODBC connection to the HA SQLite database through the Samba share for a SQLServer linked server, but I’m getting errors. If I copy the DB to a local windows disk it connects fine so I’m guessing its a premissions issue where SQLServer cant see the database files in the Samba folder.

I’m running through an Oracle VM VirtualBox running on the same window 10 machine as my SQLServer database

Does anyone have this working please?


check out Recorder - Home Assistant


Thanks, I did a fresh Home Assistant install and its working now with no tinkering!?!?


1 Like