This article provides information on how to resolve the following error which occurs while opening the Report Writer:
Cannot connect to DATABASE NAME database
Report Writer uses TCP/IP and Named Pipes to connect to the SQL Server. By default, SQL Server only enables Shared Memory as a transport protocol. While installing Orion on the same server where SQL Server is installed, the Configuration Wizard creates dependencies on some services (i.e. Information Service, Job Engine, Collector), which allows utilization of Shared Memory. But standalone applications, like Report Write, do not have such dependency and fails while opening with the error above.
In Registered Servers or Object Explorer, right-click the server instance you want to restart, and then click Restart.
A message box asks whether you are sure you want to restart SQL Server on the server instance you chose.
A green arrow on the icon next to the server name indicates that the server restarted successfully.