ok - this is sorted
the connectionstring parameter had the "allow multiple Values" box ticked
I unticked this and it is now working

this linked sorted it our for...

I finally managed to do what I wanted - not sure if this is the most efficient way but it does the job for now
It took a while and...

thanks Lynn
I found the first one and getting that into my script now -
must have missed the second one though - will need to have a read...

just an update for those interested:

failed over SQL instance to passive node and up the SQL Max_server_memory to 36GB - showing less deadlocking and the WEB UI is responding quicker...

Hi Craig - thanks for your reply - I will have a look at this also

i'm going to fail this sql instance back to it's home node which has more...

ps - sorry - too many things going on here

I have set 3605,1204 and 1222 - deadlocking - seeing a lot of these and the scans - working on them...

thanks for your reply George

select from sys.traces returns nothing - I did make sure of that earlier - i even turned of the default sql trace.

OK - i wont do...

nope - this is just not happening.

I created a new domain account - ordinary user.

Using KB doc I changed the account SQL Server logs in as - to above user.

I...

thanks Elliot - I'll give this a go and let you know.

Would it be better to also have the RS service account run as the same user?

Hi Elliot

thanks for reply - apologies I haven't replied. Busy on other problems.

I checked the runas account for the SQL Server and Reporting Services

SQL Server is running as the Network...

thanks Andrew for your reply.

The question was prompted more by the fact that one of the business managers does not like having "his" systems shutdown for scheduled maintenance - so...

I'm pretty sure I did try the declared variable - however its been a week now and I have had to move on. I will still try this out again...

that's what it was! - I didn't have the tool bar and when I hit the f8 there it was.

You do learn something new everyday

thanks all

thanks All,

I will try all the suggestions.

I will honour the copyright

regards

I've to the link and filled all the requirements - how do I save the ebook so I can reference it again.

Its an encrypted pdf - can you save these?

thanks