Sql Report protection: ctp

Showing posts with label ctp. Show all posts

Friday, March 30, 2012

ReportBuilder 2005 and non-SSL

I've installed SQL Server 2005 CTP and I can't get ReportBuilder to
work. Everything is on a single XP computer. There are two possible
issues I can think of:
1. I've installed this "side-by-side" with an instance of SQL Server
2000 and Reporting Services 2000. Thus the virtual directories
localhost/Reports and ReportServer are already in use. I configured the
2005 to use Reports2 and ReportServer2.
2. There is no SSL certificate on my machine. I was hoping just to run
everything via http:. I noticed when I installed that the setup dialog
told that I had a certificate (!) and so it was going to install things
for SSL. However if I look in RSReportServer.config, I see <Add
Key="SecureConnectionLevel" Value="0"/>, which I believe means no SSL.
When I try to download reportbuilder from the Report Manager page, it
tells me that the download has been interrupted. If I just try to
execute the report builder .exe from the web directory, it does start
up and presents me with a user name/password dialog box. If I fill this
in and press OK, it tells me "No report server was found at
https://localhost/reportserver. That is, it is looking at the wrong
virtual directory and using the wrong protocol.
Is there some way to configure ReportBuilder so it uses a non-default
URL for the report server? Can I even use the CTP version without a
certificate?
Thanks...MikeDid you find the solution? I am having the same problem.
mike@.kraley.com wrote:
> I've installed SQL Server 2005 CTP and I can't get ReportBuilder to
> work. Everything is on a single XP computer. There are two possible
> issues I can think of:
> 1. I've installed this "side-by-side" with an instance of SQL Server
> 2000 and Reporting Services 2000. Thus the virtual directories
> localhost/Reports and ReportServer are already in use. I configured the
> 2005 to use Reports2 and ReportServer2.
> 2. There is no SSL certificate on my machine. I was hoping just to run
> everything via http:. I noticed when I installed that the setup dialog
> told that I had a certificate (!) and so it was going to install things
> for SSL. However if I look in RSReportServer.config, I see <Add
> Key="SecureConnectionLevel" Value="0"/>, which I believe means no SSL.
> When I try to download reportbuilder from the Report Manager page, it
> tells me that the download has been interrupted. If I just try to
> execute the report builder .exe from the web directory, it does start
> up and presents me with a user name/password dialog box. If I fill this
> in and press OK, it tells me "No report server was found at
> https://localhost/reportserver. That is, it is looking at the wrong
> virtual directory and using the wrong protocol.
> Is there some way to configure ReportBuilder so it uses a non-default
> URL for the report server? Can I even use the CTP version without a
> certificate?
> Thanks...Mike

Wednesday, March 28, 2012

Report Web Viewer Control Error - SQL2005 September CTP

I am trying to use the Report Viewer Control in an ASPX page but getting the following error :- "For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. ". This is with the SQL Server 2005 September CTP. Is there any option that i should turn on or off?...

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrowsql

Report Web Viewer Control Error - SQL2005 September CTP

Thanks,
Krishna

see
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101047&SiteID=1

I will try this tomorrow

Friday, March 9, 2012

Report Service failed to start

New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'LocalSystem' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

The service (and SQL server) is configured to use Local System as the account.

In RsReportServer.config change your WebServiceAccount to be the actual account the web service runs as, for instance ASPNET or Network Service. If you empty it, we will use a default for the OS.

Thanks
Tudor|||Dear Tudor,
I have similar problem. I've just installed the final version of sql 2005 (reporting services as well, side by side with the original sql 2000 + reporting services pair) and the Reporting Services (the old one) service doesn't start after the boot process. My error message is the following:

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: Event source Schedule and Delivery Processor does not exist.

at Microsoft.ReportingServices.Diagnostics.Utilities.RSEventLog.Init()

at Microsoft.ReportingServices.Diagnostics.Globals.Init(RSConfigurationManager configManager, RunningApplication app)

at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()

at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)

at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

In my browser I got the following message instead of my report folders:
Unable to communicate with report server. Please verify that the report server is operational.

The RS'2005 service works fine but all my reports are on the old installation and I really need them. Each service uses Local system account except server-agents which use a domain account.
Please help me!
Thanks in advance,
marcell|||

Tudor,

Many thanks. Your pointer solved my problem also.

Regards,

Arun Philip

|||

anyone please help.... Im unable to start report server...Im not sure if this is similar with the problem posted by Dillon.....Thanks

Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!4/26/2007-09:40:01:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'ORACLE-01\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

|||I get the Same Error RE LocalSystem account. Funny thing is, when i open the report server config file, there is NO NODE in the XML for the WebServiceIdentity. I treid to add it myself with NT AUTHORITY\System as per the MS KB Article but it is still not working... any ideas ?|||

This node doesnt exist in case you are woking on SQL 2000 Reporting services.

Hope This helps.