SQLServerCentral / Data Warehousing / Analysis Services / Errors when writing querylog in sql server database / Latest Posts

RE: Errors when writing querylog in sql server database

Ramunas Balukonis — Thu, 01 Apr 2004 23:16:00 GMT

Yaaa, that worked!

Thanks, Steve

Ramunas Balukonis

RE: Errors when writing querylog in sql server database

stevefromOZ — Mon, 22 Mar 2004 23:11:00 GMT

obviously it can't log to sql server if it's not running, so alternatives are to log to another server or like you say, put a dependency on the msolap service to tie it to the mssql service. Here's a link to a reg hack that shows how to add the dependency. http://www.boyce.us/windows/servertipcontent.asp?ID=7

Seems to work...

RE: Errors when writing querylog in sql server database

Ramunas Balukonis — Mon, 22 Mar 2004 23:04:00 GMT

This is valid connection string, and query logging works correctly before I stop sql sever service.

RE: Errors when writing querylog in sql server database

stevefromOZ — Mon, 22 Mar 2004 17:36:00 GMT

what did u change the connection string to? are they valid (ie have u checked them from another applciation)?

Errors when writing querylog in sql server database

Site Owners — Mon, 22 Mar 2004 08:00:00 GMT

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

Errors when writing querylog in sql server database

Ramunas Balukonis — Wed, 17 Mar 2004 01:34:00 GMT

Hello,

I migrated my Analysis Services querylog table from access database to sql server database. I just changed registry value QueryLogConnectionString and RemoteQueryLogConnectionString values in registry under HKEY_LOCAL_NASHINE/ SOFTWARE/MICROSOFT/OLAP SERVER/CURRENTVERSION.

After that all works fine until I stoped ant restarted my SQL SERVER service. MSOLAP Service continued to work but failed to write to database querylog. In event log I found such error:

1. Relational data provider reported error: [No transaction is active.].

2. Relational data provider reported error: [Connection failure;08S01].

3. Relational data provider reported error: [Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.].

When I stop and restart MSOLAP Service, it continue to write to table querylog. Pausing and then starting MSOLAps ervice does not work.

I think, one of the best method should be implement service dependency between olap service and sql server service, like between sqlserveragent and sql server. So, I want to stop olap service mandatory after sql server service stops. is it possible?

Or can somebody propose another way to continue logging after sql server restarted?

Thank you.

Ramunas