(imported topic written by lbradley91)
I am trying to connect Web Reports to a second instance of SQL on a Server. I keep getting the error “Unknown Error: Could not connect. Database ‘THSSQL01’ has been disabled.” The DSN connects successfully when I test it. Can someone give me guidance on how to set up the OBDC or how to setup Web Reports to access the second instance? Thank you for the help.
(imported comment written by Macideus91)
I will take a shot at this…since I have had similar issues.
I had to place an entry in the hosts file to point my machine at the bigfix server. ie 192.168.0.x bigfixservername
So that anything I do from my console machine that looked for the Server pointed to the reference location.
Hope that helps!
-Mike
(imported comment written by Miran_p91)
I am having same problem as lbradley. ODBC is working I still get database disabled, any idea?
(imported comment written by BenKus)
Log into web reports and go to settings and un-disable your database.
This will happen if your database was unavailable for a while…
Ben
(imported comment written by Miran_p91)
It was using wrong ODBC by default, so I set it to bfenterprise and it start to work.