Hi,

My 2005 Olap Query Log is located on a remote SQL Server. When the remote
SQL server is restarted for some reason, the only way i can get the OLAP
Query logging to recommence is to restart the OLAP Service. Otherwise, the
OLAP server just pumps the event log full of error messages.

Is there any way i can re-establish the connection from the OLAP Server (in
terms of the Query Logging) without having to restart the OLAP Service in
order to maintain service levels.

Many thanks.

--
Kyle Henly
DBA
U.K.