Error:

Execute scalar requires an open an available connection.The connection’s current state is closed.

Snapshot:

Workaround :

Open Run | type services.msc | find SQL Server (RELYONDB)and SQL Server Browser

Restart SQL Server RELYONDB and SQL Server Browser service.