i can't deploy a report from SQL Server Business Intellegience Development Studio

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

I have installed:

* SQL Server 2005 Express Edition SP1

* SQL Management Studio Express

* SQL Server 2005 Express Edition with Advanced Services SP1

* SQL Server 2005 Express Edition Toolkit SP1

I'm trying to create a simple report, that display only a list of names. "Select * From Table"

Any ideas?

Hi,

switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hey, Jens

I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message.

Lloyd Arcales

i can't deploy a report from SQL Server Business Intellegience Development Studio

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

I have installed:

* SQL Server 2005 Express Edition SP1

* SQL Management Studio Express

* SQL Server 2005 Express Edition with Advanced Services SP1

* SQL Server 2005 Express Edition Toolkit SP1

I'm trying to create a simple report, that display only a list of names. "Select * From Table"

Any ideas?

Hi,

switch the logging mode of SQL Server Reporting Services to Verbose and try it again, post the specific log snippets of the log according the error to the forum.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hey, Jens

I uninstalled SQL Server Express and all its components, and reinstalled the SQL Express SP1 Edition, i'm no longer going to use the reporting services anymore, as long as i know that SQL Server Express can create reports and deploy it to, other computers. I'm ok, and Thanks for the reply to my Message.

Lloyd Arcales

I can't connect to http://localhost/Reports - rsinternal error

After a new installation I can't connect to http://localhost/Reports - rsinternal error

The logfiles give me the following: (haven't been able to find an answer to this issue)

<Header>

<Product>Microsoft SQL Server Reporting Services Version 8.00.1038.00</Product>

<Locale>en-US</Locale>

<TimeZone>W. Europe Daylight Time</TimeZone>

<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles\ReportServer__07_28_2006_11_27_56.log</Path>

<SystemName>BUIS8907-6</SystemName>

<OSName>Microsoft Windows NT 5.1.2600.0</OSName>

<OSVersion>5.1.2600.0</OSVersion>

</Header>

aspnet_wp!webserver!b0c!7/28/2006-11:27:57:: i INFO: Reporting Web Server started

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.

aspnet_wp!library!b0c!7/28/2006-11:27:57:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.

aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Running on 1 physical processors, 1 logical processors

aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Reporting Services starting SKU: Evaluation

aspnet_wp!resourceutilities!b0c!7/28/2006-11:27:57:: i INFO: Eval SKU: 120 days left

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!runningjobs!b0c!7/28/2006-11:27:57:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds

aspnet_wp!library!b0c!07/28/2006-11:28:09:: i INFO: Call to GetPermissions:/

aspnet_wp!crypto!b0c!07/28/2006-11:28:15:: i INFO: Initializing crypto as user: BUIS8907-6\ASPNET

aspnet_wp!crypto!b0c!07/28/2006-11:28:15:: i INFO: Exporting public key

aspnet_wp!library!b0c!07/28/2006-11:28:15:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.IO.FileNotFoundException: The system cannot find the file specified.

at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode, IntPtr errorInfo)

at RSManagedCrypto.RSCrypto.ExportPublicKey()

at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()

at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()

at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()

at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()

at Microsoft.ReportingServices.Library.Storage.get_Connection()

at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)

at Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)

at Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)

at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String name)

at Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)

at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()

at Microsoft.ReportingServices.Library.RSService.PathToInternal(String source)

at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path, Boolean validate, Boolean convert, Boolean translate)

at Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String path)

at Microsoft.ReportingServices.Diagnostics.CatalogItemContext..ctor(IPathTranslator pathTranslator, String userSuppliedPath, String parameterName)

at Microsoft.ReportingServices.Library.RSService.GetPermissions(String item, StringCollection& Operations)

End of inner exception stack trace

I have already tried the rsconfig -c, this was succesfully but did not resolved the issue.

hey,

I am not a expert but i had similar kind of problem initially.

http://localhost/Reportserver is a default name. Instead of localhost try putting ur database name .

like http://Database/reportserver.

ashish

|||

Thanks Ashish for your reply, but unfortunately that didn't work.

Even when I browser the virtual directory in the IIS is gives me the rsinternal error.

I found somewhere else someone who re-installed and it resolved it for them. That was the first thing I did still have the issue.

I think there must be a setting or parameter incorrect somewhere. After the installation was finished I received a message telling me that the service could not be started and I would have to manually start it. I check the service and it was running. I even restarted it. the eventviewer tells me it started successfully so.....?

Thanks again, hoping for more suggestions

sql

I cannot logon to Http://localhost/reports$sqlexpress

Hello,
I am completely stuck. I have installed SQL server express server
advanced with reporting services. I can create some reports in Visual
studio 2005 IDE (from Acces database) but I cannot login to subj
address to do something from the web
I get the following response from my browser:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance
What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
functioning. I am logged as a user with Administrator rights. I can
browse web pages hosted on my IIS.
Searc on Google on this reveals a lot of hits which I have gone
through but no avail.
Also, how can I check that I have ASP.NET enabled on IIS'
Thanks,
AivarsOn Mar 15, 5:52 pm, "Aivars" <aiva...@.apollo.lv> wrote:
> Hello,
> I am completely stuck. I have installed SQL server express server
> advanced with reporting services. I can create some reports in Visual
> studio 2005 IDE (from Acces database) but I cannot login to subj
> address to do something from the web
> I get the following response from my browser:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance
> What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
> functioning. I am logged as a user with Administrator rights. I can
> browse web pages hosted on my IIS.
> Searc on Google on this reveals a lot of hits which I have gone
> through but no avail.
> Also, how can I check that I have ASP.NET enabled on IIS'
> Thanks,
> Aivars
You may need to reinstall SSRS Express w/Advanced Services. I had a
similar issue a few months back and that seemed to resolve it. To
check if ASP.NET is enabled for IIS, do the following:
- Right click 'My Computer' and select 'Manage.'
- Select Services and Applications -> Internet Information Services ->
Default Web Site
- Right-click either the Reports or ReportServer virtual directory and
select Properties.
- There should be a tab at the end called 'ASP.NET'. If you select it,
it will show you the ASP.NET version, etc.
- Also, the Virtual Directory tab is where you would set up connection
pooling (in case you needed to run different versions of Visual
Studio/ASP.NET and need to control which .NET framework is used for
what).
Hope this helps.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||Running the following statement in your Framework\v2.0.50727 directory
might help:
aspnet_regiis -i -enable
Regards,
Thomas
Aivars schrieb:
> Hello,
> I am completely stuck. I have installed SQL server express server
> <SNIP>
> Also, how can I check that I have ASP.NET enabled on IIS'|||Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
times all SSRS and Toolkit and still I am getting the following error
when logging to reportserver:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance.
No clue whatsoever.
Any more ideas?
Aivars
Thomas H=FCtter wrote:
> Running the following statement in your Framework\v2.0.50727 directory
> might help:
> aspnet_regiis -i -enable
> Regards,
> Thomas
>
> Aivars schrieb:
> > Hello,
> > I am completely stuck. I have installed SQL server express server
> > <SNIP>
> > Also, how can I check that I have ASP.NET enabled on IIS'|||Well, what do your event logs say around the time the error happens?
Aivars schrieb:
> Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> times all SSRS and Toolkit and still I am getting the following error
> when logging to reportserver:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance.|||Thomas, thank you very much.
I reinstalled windows(!). Now i can at least get the to the home page
of reportserver (it looks like it) but it responds with an error:
The report server is not responding. Verify that the report server is
running and can be accessed from this computer. But it is a home page
of report server.
It looks like I am closer. What is that last thing which I am
suppposed to do?
I think that is something to do with windows xp security?
Thanks,
Aivars
Thomas H=FCtter wrote:
> Well, what do your event logs say around the time the error happens?
>
> Aivars schrieb:
> > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > times all SSRS and Toolkit and still I am getting the following error
> > when logging to reportserver:
> >
> > The server has encountered an error while loading an application
> > during the processing of your request. Please refer to the event log
> > for more detail information. Please contact the server administrator
> > for assistance.|||Finally I did get it to work. I had tu use rskeymgmt utility to delete
encrypted contend. And do not ask me why because i do not know myself
how i had something encrypted on server.
maybe when configuring the report server there is an option to encrypt
and i had used it by accident.
Anyway, thanks to all who responded. There is a plethora of
information in Books online and Google is your friend!
Aivars
Aivars wrote:
> Thomas, thank you very much.
> I reinstalled windows(!). Now i can at least get the to the home page
> of reportserver (it looks like it) but it responds with an error:
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer. But it is a home page
> of report server.
> It looks like I am closer. What is that last thing which I am
> suppposed to do?
> I think that is something to do with windows xp security?
> Thanks,
> Aivars
> Thomas H=FCtter wrote:
> > Well, what do your event logs say around the time the error happens?
> >
> >
> > Aivars schrieb:
> > > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > > times all SSRS and Toolkit and still I am getting the following error
> > > when logging to reportserver:
> > >
> > > The server has encountered an error while loading an application
> > > during the processing of your request. Please refer to the event log
> > > for more detail information. Please contact the server administrator
> > > for assistance.

I am not able to view RS folders and reports.

I created reports and deployed but i am not able to see on IE my RS folders
I used this path and also i used instead of localhost i used my machine name;
http://localhost/reports$SQL2005/Pages/Folder.aspx
I checked IIS and RS, it's running.
Also i stoped and start again.
It still not working.
What else should i do?
But it did work couple days ago.
Please help.
Thanks.On Jul 26, 11:44 am, GGill <GG...@.discussions.microsoft.com> wrote:
> I created reports and deployed but i am not able to see on IE my RS folders
> I used this path and also i used instead of localhost i used my machine name;
> http://localhost/reports$SQL2005/Pages/Folder.aspx
> I checked IIS and RS, it's running.
> Also i stoped and start again.
> It still not working.
> What else should i do?
> But it did work couple days ago.
> Please help.
> Thanks.
The only other thing I can think of are to stop and restart the SQL
Server service (sqlserver.exe) and the RPC service (remote procedure
call). If this doesn't work, you may need to reinstall SSRS. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant

I am not able to open my report through URL It's URGENT!!!!!1

I am not able to open reports through URL.

<A HREF="http://localhost/Reports?NTIEE Reports/NTSID_LookUp">View Report</A>

When i click on this link it opens report manager and the NTIEE Reports folder.But i want to open direclty the report.Name of the report is NTSID_LookUp which is depoyed inside NTIEE Reports folder.Pls let me know how i can open a report through my web application.

Run the report in Report Manager and then right-click inside the report to get the Properties. The URL to link directly to the report is there.

If you don't want to see the manager, you should user Reportserver? instead of Reports.

cheers,

Andrew

|||

Try this

<A HREF="http://localhost/ReportServer?NTIEE Reports/NTSID_LookUp&rs:Command=render">View Report</A>

or this

<A HREF="http://localhost/ReportServer/Pages/ReportViewer.aspx?NTIEE Reports/NTSID_LookUp&rs:Command=Render">View Report</A>

Pls also make sure you use the correct the virtual directory - ReportServer (which is the default).

Cheers,

Henary