Reporting Services 2005 on Vista

Hi All
When I go to http://localhost/reports on my laptop running Vista and SQL
Server Reporting Services 2005 SP2 I recive the following error:
HTTP Error 401.1 - Unauthorized
Description: You do not have permission to view this directory or page using
the credentials that you supplied.
Does anyone know how to resolve this?
Thanks
- DavidNot sure if this is to do with you having to be logged in to the machine as
Admin or someone with admin rights.
"David" wrote:
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>|||I don't run Vista but here is a post I saved that might help you:
>>>>>
1) Control Panel / User Accounts / Turn User Account Control - off
2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
>>>>>>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <David@.discussions.microsoft.com> wrote in message
news:90D7717A-5883-4EB8-BFDF-A97EE9E5FE40@.microsoft.com...
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page
> using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>

REPORTING SERVICES 2005 AND VISUAL STUDIO 2003

Hi everyone
I would like to put the following question...
I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
MSQL2000 Database?
Do I need to Install Visual Studio 2005 ?
Thanks a lot
MiltosRS 2005 comes with a version of VS 2005. You do not have to purchase it.
Just install the BI tools from the SQL Server 2005 disk. RS 2005 can use SQL
Server 2000 db for its object/metadata (as long as you have the SQL Server
2005 license) the biggest issue is installing side by side on the database
with RS 2000. The other issue is IIS. One part of IIS (RS 2000) needs to
stay at 1.1, the other needs to be at 2.0. So you upgrade IIS with 2.0
framework and then you have to get the initial sites back to 1.1.
I believe all of this is possible but it is non-trivial.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<milmen@.tellas.gr> wrote in message
news:1155895924.922028.277620@.m79g2000cwm.googlegroups.com...
> Hi everyone
> I would like to put the following question...
> I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
> and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
> MSQL2000 Database?
> Do I need to Install Visual Studio 2005 ?
> Thanks a lot
> Miltos
>|||I have the same predicament.
I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
RS2000
The client wanted to upgrade SQL to 2005 but now I have difficulties
running my application which runs on Framework 1.1 to call RS2005 now
using Framework 2.
So to solve it, I downgraded RS back to 2000.|||There was no reason to downgrade RS. There are two ways to be integrating:
URL Integration and Web Services. Both are still available to you from your
application. The web server has to be told which sites are still running
1.1, then the sites used by RS 2005 use 2.0.
Also, his case was that he wanted to have RS 2000 and RS 2005 side by side.
That does not seem to be the case for you. Your situation seemed to be one
of integration which should not be a problem at all.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rGenius" <ruellacaste@.gmail.com> wrote in message
news:1156490695.127315.56360@.b28g2000cwb.googlegroups.com...
>I have the same predicament.
> I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
> RS2000
> The client wanted to upgrade SQL to 2005 but now I have difficulties
> running my application which runs on Framework 1.1 to call RS2005 now
> using Framework 2.
> So to solve it, I downgraded RS back to 2000.
>

Reporting Services 2000 SP2 online later today

During the question session for the reporting controls webcast which
finished a few minutes ago Brian Welcker indicated that the Reporting
Services 2003 Service Pack 2 would be available online later today.
No URL was specified.
http://www.microsoft.com/sql/reporting/default.asp
or
http://www.microsoft.com/sql/downloads/default.asp
seem promising places to keep an eye on.
Andrew Watt
MVP - InfoPathIt's out!
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
Thanks for all of your patience.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:dlii61128670qluc0md83q638lnbffp5nq@.4ax.com...
> During the question session for the reporting controls webcast which
> finished a few minutes ago Brian Welcker indicated that the Reporting
> Services 2003 Service Pack 2 would be available online later today.
> No URL was specified.
> http://www.microsoft.com/sql/reporting/default.asp
> or
> http://www.microsoft.com/sql/downloads/default.asp
> seem promising places to keep an eye on.
> Andrew Watt
> MVP - InfoPath|||Here is the URL:
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
news:dlii61128670qluc0md83q638lnbffp5nq@.4ax.com...
> During the question session for the reporting controls webcast which
> finished a few minutes ago Brian Welcker indicated that the Reporting
> Services 2003 Service Pack 2 would be available online later today.
> No URL was specified.
> http://www.microsoft.com/sql/reporting/default.asp
> or
> http://www.microsoft.com/sql/downloads/default.asp
> seem promising places to keep an eye on.
> Andrew Watt
> MVP - InfoPath|||Yeah!!!!!!!!!!!!!!!!!!
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:uiXdf23RFHA.904@.tk2msftngp13.phx.gbl...
> It's out!
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
> Thanks for all of your patience.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Andrew Watt [MVP - InfoPath]" <SVGDeveloper@.aol.com> wrote in message
> news:dlii61128670qluc0md83q638lnbffp5nq@.4ax.com...
> > During the question session for the reporting controls webcast which
> > finished a few minutes ago Brian Welcker indicated that the Reporting
> > Services 2003 Service Pack 2 would be available online later today.
> >
> > No URL was specified.
> >
> > http://www.microsoft.com/sql/reporting/default.asp
> >
> > or
> >
> > http://www.microsoft.com/sql/downloads/default.asp
> >
> > seem promising places to keep an eye on.
> >
> > Andrew Watt
> > MVP - InfoPath
>|||On Fri, 22 Apr 2005 13:55:30 -0700, "Brian Welcker [MSFT]"
<bwelcker@.online.microsoft.com> wrote:
>It's out!
>http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en
>Thanks for all of your patience.
Great to sse it! :)
Andrew Watt
MVP - InfoPath

Reporting Services 2000 SP2 fails

I have installed SP2 successfully a number of times before, but always where the Report Server and the Report Server databases were on the same box. This is the first time trying to install the Service Pack where the Report Server is on server X and the databases are on server Y.

When I try to run the SP (on server X), I get the following message:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I am logged in using a domain account that is a local admin on both servers (and also the SQL Server startup account on server Y). It is also the account used by the Report Server to connect to the RS databases. The startup account for the Report Server service is 'NT AUTHORITY\NETWORK SERVICE'.

Hi,

Try to change the SSRS service account to a domain account, and add this account to your SSRS database server and map to your SSRS database. Also, you should add this account to the RsExecRole role.

I hope it helps.

Regards,

Janos

reporting services 2000 rendering

I am using SQL Server 2000 sp3 and reporting services sp2, and I cannot
get the render method to work for my reports
(http://help.maximumasp.com/SmarterT...cle.aspx?articl
eid=847).
I get serveral errors such as :
1) The best overloaded match has some invalid arguments
2) Argument '8': cannot convert from '<null>' to 'out string'
3) Argument '9': cannot convert from '<null>' to 'out string'
4) Argument '10': cannot convert from '<null>' to 'out
lovelyjubbly.net.discountasp.rs.ParameterValue[]'
5) Argument '11': cannot convert from '<null>' to 'out
lovelyjubbly.net.discountasp.rs.Warning[]'
6) Argument '12': cannot convert from 'string[]' to 'out string[]'
Can anybody help?
Cheers,
Mike
*** Sent via Developersdex http://www.examnotes.net ***You'll get these errors if you don't pass the arguments properly to the
Render method. Make sure you specify the 'out' keyword for output
parameters and pass strongly-typed parameters instead of 'null' when
required.
If you still have problems, post your code.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:eMxayzaVGHA.4764@.TK2MSFTNGP10.phx.gbl...
>I am using SQL Server 2000 sp3 and reporting services sp2, and I cannot
> get the render method to work for my reports
> (http://help.maximumasp.com/SmarterT...cle.aspx?articl
> eid=847).
> I get serveral errors such as :
> 1) The best overloaded match has some invalid arguments
> 2) Argument '8': cannot convert from '<null>' to 'out string'
> 3) Argument '9': cannot convert from '<null>' to 'out string'
> 4) Argument '10': cannot convert from '<null>' to 'out
> lovelyjubbly.net.discountasp.rs.ParameterValue[]'
> 5) Argument '11': cannot convert from '<null>' to 'out
> lovelyjubbly.net.discountasp.rs.Warning[]'
> 6) Argument '12': cannot convert from 'string[]' to 'out string[]'
> Can anybody help?
>
> Cheers,
> Mike
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Hi Dan,
Here is my first attempt :
// ReportingService rs = new ReportingService();
//
// rs.Credentials = new System.Net.NetworkCredential("rs_*****",
"*****", "");
//
// Byte[] results, image;
// string[] streamids;
// string streamid;
//
// //render the report to HTML 4.0
// results = rs.Render("/lovelyjubbl/reports/QBRatings", "HTML4.0",
null,
"<DeviceInfo><StreamRoot>/lovelyjubbly/</StreamRoot></DeviceInfo>",
null, null, null, null, null, null, null, streamids);
// Response.BinaryWrite(results);
And here's my second :
ReportingService rs = new ReportingService();
rs.Credentials = new System.Net.NetworkCredential("rs_*****", "*****",
"");
// Render arguments
byte[] result = null;
string reportPath = "/lovelyjubbl/reports/QBRatings";
string format = "MHTML";
string historyID = null;
string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
// Prepare report parameter.
// ParameterValue[] parameters = new ParameterValue[3];
// parameters[0] = new ParameterValue();
// parameters[0].Name = "EmpID";
// parameters[0].Value = "38";
// parameters[1] = new ParameterValue();
// parameters[1].Name = "ReportMonth";
// parameters[1].Value = "6"; // June
// parameters[2] = new ParameterValue();
// parameters[2].Name = "ReportYear";
// parameters[2].Value = "2004";
DataSourceCredentials[] credentials = null;
string showHideToggle = null;
string encoding;
string mimeType;
Warning[] warnings = null;
ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
SessionHeader sh = new SessionHeader();
rs.SessionHeaderValue = sh;
try
{
result = rs.Render(reportPath, format, historyID, devInfo, null,
credentials,
showHideToggle, out encoding, out mimeType, out
reportHistoryParameters, out warnings,
out streamIDs);
}
catch (SoapException e)
{
//Console.WriteLine(e.Detail.OuterXml);
}
// Write the contents of the report to an MHTML file.
try
{
FileStream stream = File.Create( "report.mhtml", result.Length );
Console.WriteLine( "File created." );
stream.Write( result, 0, result.Length );
Console.WriteLine( "Result written to the file." );
stream.Close();
}
catch ( Exception e )
{
//Console.WriteLine( e.Message );
}
Neither of which work, and both give errors as mentioned in my first
post.
Thanks,
Mike
*** Sent via Developersdex http://www.examnotes.net ***|||> Neither of which work, and both give errors as mentioned in my first
> post.
The first version will generate the errors mentioned in your initial post.
However, your second attempt looks syntactically correct. I copy/pasted
that code and successfully compiled it so you shouldn't get any errors as
long as you've added the RS web service reference to your project.
Did you completely remove the first version from your project?
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:ON09ocbVGHA.5288@.TK2MSFTNGP14.phx.gbl...
> Hi Dan,
> Here is my first attempt :
> // ReportingService rs = new ReportingService();
> //
> // rs.Credentials = new System.Net.NetworkCredential("rs_*****",
> "*****", "");
> //
> // Byte[] results, image;
> // string[] streamids;
> // string streamid;
> //
> // //render the report to HTML 4.0
> // results = rs.Render("/lovelyjubbl/reports/QBRatings", "HTML4.0",
> null,
> "<DeviceInfo><StreamRoot>/lovelyjubbly/</StreamRoot></DeviceInfo>",
> null, null, null, null, null, null, null, streamids);
> // Response.BinaryWrite(results);
>
> And here's my second :
> ReportingService rs = new ReportingService();
> rs.Credentials = new System.Net.NetworkCredential("rs_*****", "*****",
> "");
> // Render arguments
> byte[] result = null;
> string reportPath = "/lovelyjubbl/reports/QBRatings";
> string format = "MHTML";
> string historyID = null;
> string devInfo = @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
> // Prepare report parameter.
> // ParameterValue[] parameters = new ParameterValue[3];
> // parameters[0] = new ParameterValue();
> // parameters[0].Name = "EmpID";
> // parameters[0].Value = "38";
> // parameters[1] = new ParameterValue();
> // parameters[1].Name = "ReportMonth";
> // parameters[1].Value = "6"; // June
> // parameters[2] = new ParameterValue();
> // parameters[2].Name = "ReportYear";
> // parameters[2].Value = "2004";
> DataSourceCredentials[] credentials = null;
> string showHideToggle = null;
> string encoding;
> string mimeType;
> Warning[] warnings = null;
> ParameterValue[] reportHistoryParameters = null;
> string[] streamIDs = null;
> SessionHeader sh = new SessionHeader();
> rs.SessionHeaderValue = sh;
> try
> {
> result = rs.Render(reportPath, format, historyID, devInfo, null,
> credentials,
> showHideToggle, out encoding, out mimeType, out
> reportHistoryParameters, out warnings,
> out streamIDs);
> }
> catch (SoapException e)
> {
> //Console.WriteLine(e.Detail.OuterXml);
> }
> // Write the contents of the report to an MHTML file.
> try
> {
> FileStream stream = File.Create( "report.mhtml", result.Length );
> Console.WriteLine( "File created." );
> stream.Write( result, 0, result.Length );
> Console.WriteLine( "Result written to the file." );
> stream.Close();
> }
> catch ( Exception e )
> {
> //Console.WriteLine( e.Message );
> }
>
> Neither of which work, and both give errors as mentioned in my first
> post.
>
> Thanks,
> Mike
> *** Sent via Developersdex http://www.examnotes.net ***|||I'm now using the second version of my code. I no longer get build
errors, but when I run the code I just get an unviewable image (a blank
image with a red cross). The strange thing is that my code works for
PDF, but not HTML4.0.
ReportingService rs = new ReportingService();
rs.Credentials = new System.Net.NetworkCredential("****", "****",
"");
// Render arguments
byte[] result = null;
string reportPath = "/lovelyjubbl/reports/QBRatings";
string format = "HTML4.0";
string historyID = null;
string devInfo =
@."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
DataSourceCredentials[] credentials = null;
string showHideToggle = null;
string encoding;
string mimeType;
Warning[] warnings = null;
ParameterValue[] reportHistoryParameters = null;
string[] streamIDs = null;
SessionHeader sh = new SessionHeader();
rs.SessionHeaderValue = sh;
try
{
result = rs.Render(reportPath, format, historyID, devInfo, null,
credentials,
showHideToggle, out encoding, out mimeType, out
reportHistoryParameters, out warnings,
out streamIDs);
}
*** Sent via Developersdex http://www.examnotes.net ***|||Try setting devInfo to null per http://support.microsoft.com/kb/842854/.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:%23eq76ymVGHA.1688@.TK2MSFTNGP11.phx.gbl...
> I'm now using the second version of my code. I no longer get build
> errors, but when I run the code I just get an unviewable image (a blank
> image with a red cross). The strange thing is that my code works for
> PDF, but not HTML4.0.
> ReportingService rs = new ReportingService();
> rs.Credentials = new System.Net.NetworkCredential("****", "****",
> "");
> // Render arguments
> byte[] result = null;
> string reportPath = "/lovelyjubbl/reports/QBRatings";
> string format = "HTML4.0";
> string historyID = null;
> string devInfo =
> @."<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>";
> DataSourceCredentials[] credentials = null;
> string showHideToggle = null;
> string encoding;
> string mimeType;
> Warning[] warnings = null;
> ParameterValue[] reportHistoryParameters = null;
> string[] streamIDs = null;
> SessionHeader sh = new SessionHeader();
> rs.SessionHeaderValue = sh;
> try
> {
> result = rs.Render(reportPath, format, historyID, devInfo, null,
> credentials,
> showHideToggle, out encoding, out mimeType, out
> reportHistoryParameters, out warnings,
> out streamIDs);
> }
>
> *** Sent via Developersdex http://www.examnotes.net ***|||This just gives me a blank page on rendering.
*** Sent via Developersdex http://www.examnotes.net ***|||> This just gives me a blank page on rendering.
I'm not sure what you mean by a blank page since your last code snippet
writes the report to a file rather than a browser window. If your code is
part of an ASP.NET application, you could change the format to "HTML4.0" and
render it with the code below.
Response.ClearContent();
Response.BinaryWrite(result);
Response.Flush();
Response.Close();
My RS expertise is limited. You might try posting rendering issues to a
Reporting Services forum.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mike P" <mike.parr@.gmail.com> wrote in message
news:OLZEjbnVGHA.4384@.tk2msftngp13.phx.gbl...
> This just gives me a blank page on rendering.
>
> *** Sent via Developersdex http://www.examnotes.net ***

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?

Reporting Services - Export to PDF problem

We are facing some problem while exporting the SSRS (SQL Server 2005 SP2 installed on win2K3) Report to PDF format, problem is when we export report to PDF format all the data after 80 columns gets wrapped to next page which not only increases no. of pages in the reports but also disturbs the report format for example if a report contains only one page and 320 columns of data and if we export it to PDF format then the PDF file will have 4 pages each having 80 columns of date. Has anybody faced the similar issues? would appreciate if you can give solution for this problem or forward any link which discusses the same.

That is a common problem, you are exceeding the width of a sheet of A4. With 80 columns your column width would have to be tiny to fit them all on one page. You can get yourself a little extra width on the page by having it render in landscape mode, just swap over the width/height values under the PageSize parameter for the report. You can also reduce the margin sizes. These techniques will not get you a lot of extra space, if you still need more then the only way to get it is to redesign the report (more tables) or select less data (narrow the parameters or filter the returned data).

sql

Reporting service not starting in SQL Express 2005 Advanced

I've installed SQL 2005 Express Advanced edition on an XP SP2 machine which
already had SQL 2005 Express SP1 installed. I followed the instructions on
deleting (moving) all files in the Template Data directory before attempting
the install - in the only instance I had on the computer (MSSQL.1).
After the install, I noticed that there was another instance (MSSQL.2) which
had the Reporting services folders in it. It didn't have any of the folders
found under MSSQL.1 in it. And of course when checking which instance the
reporting services are using under the SQL Server Config Manager, it says
Instance ID 2.
Also under either the SQL Server Config Manager or the Reporting Services
Config Manager it says that the Service Status is stopped and it won't start
using either manager. It gives a timeout error.
Anyone have an idea why? Is it because of the 2 instances? What else can I
check?
Thanks in advance.I think I may have found the problem. I didn't have a local group ASPNET
established. Once I created this local group, the service fired right up.
"Wade" <wnederveld@.preinnewhofdonotreply.com> wrote in message
news:%23YSklEIaGHA.4548@.TK2MSFTNGP04.phx.gbl...
> I've installed SQL 2005 Express Advanced edition on an XP SP2 machine
> which already had SQL 2005 Express SP1 installed. I followed the
> instructions on deleting (moving) all files in the Template Data directory
> before attempting the install - in the only instance I had on the computer
> (MSSQL.1).
> After the install, I noticed that there was another instance (MSSQL.2)
> which had the Reporting services folders in it. It didn't have any of the
> folders found under MSSQL.1 in it. And of course when checking which
> instance the reporting services are using under the SQL Server Config
> Manager, it says Instance ID 2.
> Also under either the SQL Server Config Manager or the Reporting Services
> Config Manager it says that the Service Status is stopped and it won't
> start using either manager. It gives a timeout error.
> Anyone have an idea why? Is it because of the 2 instances? What else can
> I check?
> Thanks in advance.
>