Showing posts with label sp4. Show all posts
Showing posts with label sp4. Show all posts

Wednesday, March 28, 2012

Reporting Services 2005 on Windows 2000 SP4 Domain Controller

Hi all,

I'm experiencing a problem with Reporting Services 2005 running on a Windows 2000 AD Domain Controller.

Installation has been done correctly, SQL 2005 and SSRS 2005 are running correctly (I've followed Microsoft KB911846 to solve the "not dtarting after installation" problem).

Accessing reports virtual folder (http://machinename/reports) from localhost, logged on with user Administrator Report Builder option displays correctly. Also accessing from LAN, but with user Administrator, displys Report Builder Option.

Report Builder button is not displayed with other users (i.e. user Dave)

I've given user Dave same permission as Administrator (Content Manager, in SSRS) but Report Buildr still can't be viewed.

If it can be userful to understand this strange behaviour, looking in "Reporting Services Configuration" tool I can see that Web Service Identity is reported as Not configured, with a beautiful red X besides.

Can someone please help me?

Thank you very much for any suggestion.

Regards,

Dave

Solved! :-)

Just had to set domain users as "System Users" in Report Server Management

Dave

Reporting Services 2005 in VS.2005?

We are on SQL server 2000 (sp4).
We have upgraded to Visual Studio 2005 (from .NET 2003)
We installed SQL server 2005 reporting services,
on a separate machine (separate from the machine that has
sql server 2000.
But when we open our Visual Studio 2005 IDE,
on a client machine, we can't find any template for creating a reporting
services project.
Microsoft's site has nothing but ads, I couldn't find
anything there on what to do
What do we do?
Thanks in Advance,
Laurence Nuttall
Programmer Analyst III
UCLA - Division of Continuing EducationHave you tried running the setup.exe in the tools directory of your SQL2005
CD? That should have all the desktop tools you need.
"Larry" wrote:
> We are on SQL server 2000 (sp4).
> We have upgraded to Visual Studio 2005 (from .NET 2003)
> We installed SQL server 2005 reporting services,
> on a separate machine (separate from the machine that has
> sql server 2000.
> But when we open our Visual Studio 2005 IDE,
> on a client machine, we can't find any template for creating a reporting
> services project.
> Microsoft's site has nothing but ads, I couldn't find
> anything there on what to do
> What do we do?
> Thanks in Advance,
> Laurence Nuttall
> Programmer Analyst III
> UCLA - Division of Continuing Education
>
>
>

Monday, March 26, 2012

Reporting Services 2000 Requirement for Visual Studio

I have a client who already has SQL-2000 SP4 installed and now wishes
to have reporting services installed.
The installation indicates a pre-requisite of Visual Sudio .Net 2003.
Further investigation on Microsoft web site reveals that VS would have
to be version "Enterprise Developer" or "Enterprise Architect."
I know in SQL 2005 that VS is included. One option presented to the
client would be to upgrade.
My question is, was any form of visual studio included with SQL 2000
or will the client need to purchase a license for Visual Studio .Net
2003? Is VS .Net 2003 even still available?
Thanks in advance.
DanThat is some information which is not quite true...
> The installation indicates a pre-requisite of Visual Sudio .Net 2003.
> Further investigation on Microsoft web site reveals that VS would have
> to be version "Enterprise Developer" or "Enterprise Architect."
No, you will just need a one-language version of Visual Studio, thats
all, without nailing me down on the price, that should be around 100$.
> I know in SQL 2005 that VS is included. One option presented to the
> client would be to upgrade.
Sort of. You will be able to create Report / Analysis and SSIS
projects with the "small" edition of this studio.
> My question is, was any form of visual studio included with SQL 2000
> or will the client need to purchase a license for Visual Studio .Net
> 2003?
No, there was non included. Yes, he would have to buy a licencse for
that, see the above mentioned answer.
> Is VS .Net 2003 even still available?
-Yes, it is. I assume that not all vendors of your choice will still
have it, but it is available in some places. Perhaps you might find a
version on ebay which was exchanged by someone with the 2k5 version.
HTH, Jens K. Suessmeyer
--
http://www.sqlserver2005.de
--|||First off, you need any product that has VS 2003, it definitely does NOT
need to be Enterprise Developer or Enterprise Architect. Very definitely
not. The cheapest way is to get VB.Net 2003, it used to cost about $100.
However, I don't know how you go about finding a copy to buy.
Now, if Enterprise Developer is the only one that you can find to purchase
it will work but any product that comes with VS 2003 will work.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<dan.dunkin@.at-net.net> wrote in message
news:dn34t25397nlkhi59fb3sgjn21qh8kdfan@.4ax.com...
>I have a client who already has SQL-2000 SP4 installed and now wishes
> to have reporting services installed.
> The installation indicates a pre-requisite of Visual Sudio .Net 2003.
> Further investigation on Microsoft web site reveals that VS would have
> to be version "Enterprise Developer" or "Enterprise Architect."
> I know in SQL 2005 that VS is included. One option presented to the
> client would be to upgrade.
> My question is, was any form of visual studio included with SQL 2000
> or will the client need to purchase a license for Visual Studio .Net
> 2003? Is VS .Net 2003 even still available?
> Thanks in advance.
> Dan|||The MS web site says enterprise developer or architect are the only
ones that talk to SQL Server as opposed to destop databases (Access,
SQL Desktop). Do they mean something else (like you only need
enterprise for applications that directly access the database not
reports that will be run through report writer)?
On a side note, will Visual Studio 2005 Express (the free one) work?
Will any version of Visual Studio 2005 work?
Thanks!
On Tue, 13 Feb 2007 13:40:52 -0600, "Bruce L-C [MVP]"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>First off, you need any product that has VS 2003, it definitely does NOT
>need to be Enterprise Developer or Enterprise Architect. Very definitely
>not. The cheapest way is to get VB.Net 2003, it used to cost about $100.
>However, I don't know how you go about finding a copy to buy.
>Now, if Enterprise Developer is the only one that you can find to purchase
>it will work but any product that comes with VS 2003 will work.|||Don=B4t know, but the information given by Bruce and me is valid. You
might want to share the link with us where this statement resides.
-Jens.
--
http://www.sqlserver2005.de
--|||In this case it is a little different. You are only using VS to have
something to install the report designer into. So in this case what you are
reading about is something else entirely.
RS 2000 requires some version of VS 2003. Neither of the two you mention
will work. They use a different version of the framework (2.0 instead of 1.1
that RS 2000 uses).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<dan.dunkin@.at-net.net> wrote in message
news:gu64t21phn1tcq8mga7kprscoii7u9jfm2@.4ax.com...
> The MS web site says enterprise developer or architect are the only
> ones that talk to SQL Server as opposed to destop databases (Access,
> SQL Desktop). Do they mean something else (like you only need
> enterprise for applications that directly access the database not
> reports that will be run through report writer)?
> On a side note, will Visual Studio 2005 Express (the free one) work?
> Will any version of Visual Studio 2005 work?
> Thanks!
> On Tue, 13 Feb 2007 13:40:52 -0600, "Bruce L-C [MVP]"
> <bruce_lcNOSPAM@.hotmail.com> wrote:
>>First off, you need any product that has VS 2003, it definitely does NOT
>>need to be Enterprise Developer or Enterprise Architect. Very definitely
>>not. The cheapest way is to get VB.Net 2003, it used to cost about $100.
>>However, I don't know how you go about finding a copy to buy.
>>Now, if Enterprise Developer is the only one that you can find to purchase
>>it will work but any product that comes with VS 2003 will work.|||THANK YOU! for everyone's help.
Dan

Friday, March 23, 2012

Reporting Services 2000 - Printing Hangs

I am running SQL 2000 SP4 with Reporting Services 2000 SP2. Reporting services hangs when I try to print reports. The reports render okay, and when I click on the print icon, I get the appropriate dialog box. Once I click "OK", I get the "Printing..." dialog that says "Printing Now...", but it never prints, and the window eventually stops responding. As far as I am aware, no changes have been made to the server, and it was working fine approximately 10 days ago. Below is the contents of my RS Client Print Log (%Temp%\LOG56.tmp):

CRSClientPrint::Print - Starting Function.
reportServerUrl = http://reportsrv/ReportServer
reportPath = %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active
reportName = Contract_Project_By_State
CResourceManager::SetLocaleInfo - Starting Function.
SetUICulture - Starting Function.
Attempted UI LCID = 9
Using UI LCID = 1033
SetUICulture - Ending Function.
CResourceManager::LoadResourceDLL - Starting Function.
CResourceManager::LoadResourceDLL - Ending Function: 0x00000000.
CResourceManager::CanUseCurrentLocale - Starting Function.
CResourceManager::CanUseCurrentLocale - Ending Function.
CResourceManager::LoadGDIPlus - Starting Function.
CResourceManager::LoadGDIPlus - Ending Function: 0x00000000.
Attempted culture = 1033
Using culture = 1033
Culture name = English_United States.1252
CResourceManager::SetLocaleInfo - Ending Function: 0x00000000.
CPrintDlg::Print - Starting Function.
CPrintDlg::InitializePrintDlg - Starting Function.
CPrintDlg::GetDefaultPrinterName - Starting Function.
CPrintDlg::GetDefaultPrinterName - Ending Function: 0x00000000.
CPrintDlg::SetPrinterPaperSize - Starting Function.
CPrintDlg::SetPrinterPaperSize - Ending Function: 0x00000000.
CPrintDlg::InitializePrintDlg - Ending Function: 0x00000000.
CReport::SetReportName - Starting Function.
CReport::SetReportName - Ending Function: 0x00000000.
CPrintDlg::PrintReportPages - Starting Function.
CCancelDlg::StartDialog - Starting Function.
CCancelDlg::StartDialog - Ending Function: 0x00000000.
CReport::Fetch - Starting Function.
CReport::ComparePrintInfo - Starting Function.
Value of diff = 2
CReport::ComparePrintInfo - Ending Function.
CReport::ClearPages - Starting Function.
CReport::ClearFetchedPages - Starting Function.
CReport::ClearFetchedPages - Ending Function.
CReport::ClearPages - Ending Function.
CReport::ResetNextFetch - Starting Function.
Next Fetch set to 1
CReport::ResetNextFetch - Ending Function.
CReport::StartFetchThread - Starting Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 1
CReport::GetPageToFetch - Ending Function.
CReport::StartFetchThread - Ending Function: 0x00000000.
CReport::Fetch - Ending Function: 0x00000000.
CReport::GetPage - Starting Function.
Page = 1
CReport::GetPageWrapper - Starting Function.
Page wrapper = 0x00000000
CReport::GetPageWrapper - Ending Function.
CReport::FetchThreadMain - Starting Function.
CReport::GetPageToFetch - Starting Function.
Page to fetch = 1
CReport::GetPageToFetch - Ending Function.
CReport::FetchAllPages - Starting Function.
CReport::PerformFetch - Starting Function.
CReport::GetPaperSize - Starting Function.
Height = 8500, Width = 11000 IsMM = 0
CReport::GetPaperSize - Ending Function.
CResourceManager::SetInvariantCulture - Starting Function.
CResourceManager::SetInvariantCulture - Ending Function: 0x00000000.
CResourceManager::ResetCulture - Starting Function.
CResourceManager::ResetCulture - Ending Function: 0x00000000.
Url = http://reportsrv/ReportServer?%2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True

Can anyone give me any ideas as to how to troubleshoot this issue?

Hi Patrick,

If that is all that is in the log, it looks like the service might be having an issue with rendering the Url. Paste the Url from the print log file into Internet Explorer and see if it renderers an emf image.

Also, you can check the Report Server log files for any exceptions from the rendering. You can find the log directory, Logfiles next to the Report Server installation binaries directory.

Did you change any settings on your server to use Cookieless Sessions? I notice that the SessionID is not stored in the URL.

|||

I have not changed any cookie settings. When I paste the URL into the browser, I get a prompt for credentials, and then an HTTP 401 (Unauthorized) error. I am an Administrator, so my credentials should be valid. The ReportServer log showed the following:

w3wp!webserver!1df0!01/08/2007-12:34:55:: i INFO: Processed folder '/'
w3wp!webserver!1df0!01/08/2007-12:34:56:: i INFO: Processed folder '/Engineering'
w3wp!webserver!1df0!01/08/2007-12:34:58:: i INFO: Processed folder '/Engineering/Ramz - Development'
w3wp!webserver!1df0!01/08/2007-12:34:59:: i INFO: Processed folder '/Engineering/Ramz - Development/DEV_Reports'
w3wp!library!83c!01/08/2007-12:35:01:: i INFO: Initializing ResponseBufferSizeKb to default value of '64' KB because it was not specified in Server system properties.
w3wp!library!83c!01/08/2007-12:35:01:: i INFO: Initializing UseSessionCookies to 'True' as specified in Server system properties.
w3wp!library!83c!01/08/2007-12:35:01:: i INFO: Initializing EnableIntegratedSecurity to 'True' as specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:06:: i INFO: Initializing SessionTimeout to '600' second(s) as specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:06:: i INFO: Initializing EnableClientPrinting to default value of 'True' because it was not specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:06:: i INFO: Call to RenderFirst( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!library!1e4c!01/08/2007-12:35:07:: Using folder C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for temporary files.
w3wp!library!1e4c!01/08/2007-12:35:08:: i INFO: Initializing EnableExecutionLogging to 'False' as specified in Server system properties.
w3wp!library!1e2c!1/8/2007-12:35:08:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
w3wp!webserver!1e4c!01/08/2007-12:35:08:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!library!1e2c!1/8/2007-12:35:08:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
w3wp!library!1e4c!01/08/2007-12:35:08:: i INFO: Initializing SessionAccessTimeout to default value of '600' seconds because it was not specified in Server system properties.
w3wp!webserver!1e4c!01/08/2007-12:35:08:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream='d60bcf42-3d04-4642-8772-8296be509a7b'
w3wp!library!1e2c!01/08/2007-12:35:39:: i INFO: Call to RenderNext( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!cache!1e2c!01/08/2007-12:35:39:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!chunks!1e2c!01/08/2007-12:35:39:: i INFO: ### GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found! this=25ac3238-2ba1-4406-befb-f46907e5d068
w3wp!webserver!1df0!01/08/2007-12:35:41:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!cache!1e2c!01/08/2007-12:36:17:: i INFO: Session live: /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!library!83c!01/08/2007-12:36:17:: i INFO: Call to RenderNext( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!cache!83c!01/08/2007-12:36:17:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!chunks!83c!01/08/2007-12:36:17:: i INFO: ### GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found! this=25ac3238-2ba1-4406-befb-f46907e5d068
w3wp!webserver!1df0!01/08/2007-12:36:18:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!cache!83c!01/08/2007-12:36:55:: i INFO: Session live: /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!library!1e4c!01/08/2007-12:37:57:: i INFO: Call to RenderFirst( '/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State' )
w3wp!webserver!1df0!01/08/2007-12:37:58:: i INFO: Processed report. Report='/Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State', Stream=''
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
w3wp!cache!1e4c!01/08/2007-12:38:33:: i INFO: Item not cacheable: - PersistStreams /Engineering/Ramz - Development/DEV_Reports/Contract_Project_By_State
|||

I get the following in the IIS log when I try to render the report:

2007-01-09 15:42:12 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:42:49 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:42:49 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:42:49 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:43:25 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:43:25 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:44:00 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:44:00 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:47:09 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401
2007-01-09 15:47:14 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 DOMAIN\pburcham XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 200
2007-01-09 15:47:14 XXX.XXX.XXX.XXX GET /ReportServer %2fEngineering%2fRamz+-+Development%2fDEV_Reports%2fContract_Project_By_State&ContractStateDesc=Active&rs:Command=Render&rs:format=IMAGE&rc:OutputFormat=emf&rc:StartPage=1&rc:EndPage=65535&rc:PageWidth=11.0in&rc:PageHeight=8.500in&rc:MarginTop=6.350mm&rc:MarginBottom=6.350mm&rc:MarginLeft=6.350mm&rc:MarginRight=6.350mm&rs:PersistStreams=True 80 - XXX.XXX.XXX.XXX Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322) 401

It appears that SSRS is not passing my credentials all of the time, only sometimes. It also appears that multiple requests are made for the same report. Any ideas as to why this might be?

Tuesday, February 21, 2012

Reporting instsallion-problem, initialize RS and security exception

Hi all RS professinal,
I am deploying RS on SQL 2000/sp4 on win2003 sp1.
after we install RS on it. it is running well until the last moment. It said
" setup could not initialize the report server. You must manually initialize
the report server before using it for the first time. For more information,
see the Reporting Services setup documentation"
Then we uninstall it, and then install again, which have the same result.
Then we manually activate it by issuing " rsactivate -c"D:\Program
Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config" -t "
it shows the following error
Failure starting the web service:
System.Exception: The Report Server Web service has not generated a public
key.
The service may not have started successfully. Check the log files for
more in
formation.
at
Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
clientType)
at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
when we open http://localhost/reports . it shows the error as attached
Security Exception:
Description: The application attempted to perform an operation not allowed
by the security policy. To gran this applicatino the rqiured permission ,
please contact your system administrator or change the applications trust
level in the configuration file.
we have granted admin right the IUSR_localhost account.
Any Expert can give us opinions on it?
Thanks for millions
PatrickHi Patrick,
I am having an exact same problem as you.
I have Windows Server 2003 SP1, SQL 2000 Standard SP4, no SSL, got the same
error message.
Do you have any luck?
BTW, I have another Windows server 2003 (No SP1), SQL Server SP3, with
Visual Studio .NET install. It worked.
Thanks
Skip
"Patrick Lam" wrote:
> Hi all RS professinal,
> I am deploying RS on SQL 2000/sp4 on win2003 sp1.
> after we install RS on it. it is running well until the last moment. It said
> " setup could not initialize the report server. You must manually initialize
> the report server before using it for the first time. For more information,
> see the Reporting Services setup documentation"
> Then we uninstall it, and then install again, which have the same result.
> Then we manually activate it by issuing " rsactivate -c"D:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config" -t "
> it shows the following error
> Failure starting the web service:
> System.Exception: The Report Server Web service has not generated a public
> key.
> The service may not have started successfully. Check the log files for
> more in
> formation.
> at
> Microsoft.ReportingServices.RSActivate.RSActivate.RpcActivateService(Int32
> clientType)
> at Microsoft.ReportingServices.RSActivate.RSActivate.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
> Bas
> eCmdLine instance)
> when we open http://localhost/reports . it shows the error as attached
> Security Exception:
> Description: The application attempted to perform an operation not allowed
> by the security policy. To gran this applicatino the rqiured permission ,
> please contact your system administrator or change the applications trust
> level in the configuration file.
>
> we have granted admin right the IUSR_localhost account.
> Any Expert can give us opinions on it?
> Thanks for millions
> Patrick
>
>