Sorry I can't help but I've had the same problem. Waiting on advice on configuring IIS7 but I'm completely baffled as to what the problem is.

and no mention of the clustered index on the GUID. Might not be on the referenced page of BOL but not a great idea

so if there isn't a reservation on that date the date isn't displayed across the top of the table as a column? I'm currently looking for a solution to...

Am I being too pedantic in thinking that Policy Management doesn't 'define' policies but it does enable us to enforce them. Am I tying...

you're right. thanks for the pointer. the problem was that quoted_iidentifier was set to OFF in SQLCMD, changed it and the query picked up the index and ran...

nice naming convention on your tables 😛

Adi Cohn (1/26/2009)

---

I think that the answer “You cannot set IDENTITY_INSERT on for more than one table in a database” should be changed to You cannot set IDENTITY_INSERT on...

You were right Deepak. Despite SQL Server being installed initially with Reporting Services at same time permissions were missing on RStempDB.mdf and .ldf for Local Administrators group, given to...

The user running install has permissions on all files within the directory named.

In Security in Event Viewer there is a Failure Audit at the time this happens for user SYSTEM....

Do you have write permissions to the location \\111.111.1.111\E\? E is drive E: ? Why not setup a share location with explicit permissions for the user this job...

Depending how you populate your fact table you could add an auto increment column then have a filter in report builder to return WHERE autoincr < 10. just a...

Try restarting the Windows Management Instrumentation service on the RS box

Or you can use the .Render method to generate a stream straight to the page

SELECT TOP 2000 *

FROM TABLE1

WHERE ID NOT IN (SELECT TOP 30000 ID FROM TABLE1 ORDER BY ID)

ORDER BY ID

At the top Home level of Report Manager in security>properties give a Windows group you've setup specifically for reporting the Browser role. Now below 'Home' create folders that will...