Viewing 2 posts - 1 through 2 (of 2 total)
Use this statement at the top of your query:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
This will make any table look up perform the same as the Hint (With NOLOCK)...
September 14, 2010 at 3:26 pm
#1221029
Check your IIS directory security setting on the ReportServer virtual directory.
If Anonymous is not allowed, then you will be getting the authentication request.
July 16, 2009 at 8:33 am
#1025702