Hi,

Thanks for replying. I'd tried that but it didn't seem to have any affect. I left the parameter visible on the main report, hidden on the others, but...

do you have those MSDTC settings on both ends?

brilliant

maybe try creating a view in the local database that gets the data, then selecting from that in the report

what's the authentication mode in the reportserver.config file?

If it says NTLM in sys.dm_exec_requests, it's possibly "fallen back" to it because it failed the Kerberos reqs. I had the same...

Hi,

Yes, the sample data is correct - there are a couple of anomalies in there. The table itself is out of my control; I have to use it as...

depends to what end, but I tend to use

ALTER DATABASE databasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

this leaves only the current session (the one you run this command in) open

Hi,

Yes, we used physical + VMDK. I was thinking along the same lines as you and was going to try the RDM configuration... The problem smacked of the...

I think this is a pretty typical problem. The only way I've got round this is by running IE tab extension... I've only done it in Chrome - I...

easy

Not a satisfactory resolution, no. Microsoft recommended moving off the clustered VM to a standalone. We haven't had any more disk related problems, despite the server build/sql server...

Thanks John, I've just done that very thing. Will update later incase someone else finds it helpful

Here's a few more

At prod:

05/06/2014 15:41:15

LogWriter: Operating system error 170(failed to retrieve text for this error. Reason: 15105) encountered.

Write error during log flush.

Error: 9001, Severity: 21, State: 4.

The log for...

John,

The T: drive is dedicated to SQL backups. They're then shipped off to a secure location.

Thanks,

Andrew

Hi,

I only get OS error 170. You've just reminded me, I ran procmon and handle.exe to monitor the server and caught the "resource is in use" error, but it...