Report error

Hi all,

I just setup SQL 2005 Report Service, and then I used the browser to view the "folder.aspx"

Nothing showed up but I received an error page with the message like the following:

"The request failed with HTTP status 400: Bad Request."

So, what did I do wrong?

Thanks,

Frank

System Engineer

Start debugging with your http://localhost/reportserver. How were the RS virtual directories created? Try creating them using the configuration tools, and re-apply the script mappings.|||If the suggestions from James is not working, try to dive deeper into the error of the reporting services engine, by setting the logging mode to verbose and see where the error is based on. If you have a blank report server with not much reports one, try to reinstall the whole thing, that is sometimes better than (try) fixing the issues that popup. I had that a while ago, the cause was that there were file locks on the files that needed to be changed. The installer didn′t pop up a message and *bump* there were many erros coming up regarding authentication etc.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Report Designer VS. 2003 Interface Failure

Our current VS2003 installed on 2000 Sever sp4 and Reporting Service
will not longer interface.
When trying to open a report project we recieve the error "Th
application for Project XXX.rptproj is not installed" "Make sure th
application for project type (.rptproj) is installed".
Has anyone ever seen this error before or have any suggestions?
We have built a number of reports and deployed them, but we are n
longer able to open the project to make modifications. We are als
unable to create a new report project without receiving the sam
errorDid you install or remove any software recently? Did you try reinstalling
Report Designer?
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"kucerakk" <kris.kucera@.ps-dot-net.no-spam.invalid> wrote in message
news:pr2dnce98v9d4BDfRVn_vg@.giganews.com...
> Our current VS2003 installed on 2000 Sever sp4 and Reporting Services
> will not longer interface.
> When trying to open a report project we recieve the error "The
> application for Project XXX.rptproj is not installed" "Make sure the
> application for project type (.rptproj) is installed".
> Has anyone ever seen this error before or have any suggestions?
> We have built a number of reports and deployed them, but we are no
> longer able to open the project to make modifications. We are also
> unable to create a new report project without receiving the same
> error.
>

Report connection fails with DNS name

Hi,

I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.

When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection"
Also I am not able to view reports directly through IE. I.e. http://<DNS_NAME>/Reports.
When I access Reports, it prompts me to enter username/password. Even after specifying valid username, it shows me the prompt again n again.

Is there some known issue with Reporting Service or with IIS setting not able to connect to a DNS name? I did not face with any issue when
I specified DNS name in the connection string of Analysis Service project.

Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?

We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.

3: Tried putting the DNS name in the hosts file.

Eagerly awaiting some positive reply.

Note: I am working with SQL Server 2005 Standard Edition.

No replies yet

We are stuck up with this issue since quite some time.

still waiting for some positive inputs.

|||

After doing some investigation, I have found that the issue is with Analysis server not able to connect using the DNS name (Note: my Reporting Service proj is connecting to Analysis services datasource). When I connect to Analysis server through SQL Server management studio (by def which uses Win authentication), and specify machine name (ABC) in Server then it connects but if I give DNS name (XYZ.PWR.COM) it gives me the following error:

************************************************************************************************************
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()

************************************************************************************************************

If I connect to Reporting Service using DNS name then I get the following error:

************************************************************************************************************
===================================

Cannot connect to XYZ.PWR.COM.

===================================

A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using a report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
************************************************************************************************************

When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC

Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d

C:\Documents and Settings\Administrator>ping XYZ.PWR.COM

Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:

Is this problem because of the kerberos authentication that Analysis server uses to authenticate?

I am able to connect to the Database engine using DNS name (but using SQL Server authentication).
Also I was able to view the reportserver and reports page by changing the IIS authentication to NTLM.
But finally I am not able to view the reports.

Can anyone please help me in solving this issue.

Awatiitng some positive reply.

Report connection fails with DNS name

Hi,

I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.

When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection"
Also I am not able to view reports directly through IE. I.e. http://<DNS_NAME>/Reports.
When I access Reports, it prompts me to enter username/password. Even after specifying valid username, it shows me the prompt again n again.

Is there some known issue with Reporting Service or with IIS setting not able to connect to a DNS name? I did not face with any issue when
I specified DNS name in the connection string of Analysis Service project.

Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?

We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.

3: Tried putting the DNS name in the hosts file.

Eagerly awaiting some positive reply.

Note: I am working with SQL Server 2005 Standard Edition.

No replies yet

We are stuck up with this issue since quite some time.

still waiting for some positive inputs.

|||

After doing some investigation, I have found that the issue is with Analysis server not able to connect using the DNS name (Note: my Reporting Service proj is connecting to Analysis services datasource). When I connect to Analysis server through SQL Server management studio (by def which uses Win authentication), and specify machine name (ABC) in Server then it connects but if I give DNS name (XYZ.PWR.COM) it gives me the following error:

************************************************************************************************************
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()

************************************************************************************************************

If I connect to Reporting Service using DNS name then I get the following error:

************************************************************************************************************
===================================

Cannot connect to XYZ.PWR.COM.

===================================

A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using a report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
************************************************************************************************************

When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC

Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d

C:\Documents and Settings\Administrator>ping XYZ.PWR.COM

Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:

Is this problem because of the kerberos authentication that Analysis server uses to authenticate?

I am able to connect to the Database engine using DNS name (but using SQL Server authentication).
Also I was able to view the reportserver and reports page by changing the IIS authentication to NTLM.
But finally I am not able to view the reports.

Can anyone please help me in solving this issue.

Awatiitng some positive reply.

Report builder and Report Designer

Hi,
I am new to SQL reporting service (2005).
Will like to find out can report builder open a report created by report
designer.
My scenario is like this, I will like to create some reports for my
clients using report designer. Afterwhich, I will like to a allow end-user
to modify the report using report builder. How should I solution this?
I notice that Report Designer can create 2 types of projects (i.e. model
and report server)... When I use the report server, I am not able to use the
model created.
Is there anything that I miss?
Thanks
Regards
eforceIs there a way for End user to amend the report that is created by Report
designer, just like using report builder.
We tried creating a report using report designer, but report builder is not
able to open it.
Is there a walkaround to do so?
It is because our end user will like to have the flexibility to make some
cosmetic changes to those reports that we created using Report designer.
Thanks.
"eforce" <eforce@.newsgroup.nospam> wrote in message
news:OOvXMSZIGHA.344@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I am new to SQL reporting service (2005).
> Will like to find out can report builder open a report created by
> report designer.
> My scenario is like this, I will like to create some reports for my
> clients using report designer. Afterwhich, I will like to a allow end-user
> to modify the report using report builder. How should I solution this?
> I notice that Report Designer can create 2 types of projects (i.e.
> model and report server)... When I use the report server, I am not able to
> use the model created.
> Is there anything that I miss?
> Thanks
> Regards
> eforce
>
>|||Report Builder can not open RDL files
It needs a model that you have to design (in BI studio),, and the end
user will use this model to design his own reports
EH
"eforce" <eforce@.newsgroup.nospam> wrote in message
news:%231gVbXtJGHA.1032@.TK2MSFTNGP11.phx.gbl...
> Is there a way for End user to amend the report that is created by
> Report
> designer, just like using report builder.
> We tried creating a report using report designer, but report builder
> is not
> able to open it.
> Is there a walkaround to do so?
> It is because our end user will like to have the flexibility to make
> some
> cosmetic changes to those reports that we created using Report
> designer.
> Thanks.
> "eforce" <eforce@.newsgroup.nospam> wrote in message
> news:OOvXMSZIGHA.344@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> I am new to SQL reporting service (2005).
>> Will like to find out can report builder open a report created
>> by report designer.
>> My scenario is like this, I will like to create some reports for
>> my clients using report designer. Afterwhich, I will like to a
>> allow end-user to modify the report using report builder. How
>> should I solution this?
>> I notice that Report Designer can create 2 types of projects
>> (i.e. model and report server)... When I use the report server, I
>> am not able to use the model created.
>> Is there anything that I miss?
>> Thanks
>> Regards
>> eforce
>>
>|||You can, however, create a report in Report Designer based on a model using
the Report Model Query Designer. Then, you can save this report and open it
in Report Builder. Be aware though that some Report Designer functionality
cannot be consumed by Report Builder.
For more information at the Report Model Query Designer, see
http://msdn2.microsoft.com/en-us/library/ms345239(SQL.90).aspx
"EH" wrote:
> Report Builder can not open RDL files
> It needs a model that you have to design (in BI studio),, and the end
> user will use this model to design his own reports
> EH
> "eforce" <eforce@.newsgroup.nospam> wrote in message
> news:%231gVbXtJGHA.1032@.TK2MSFTNGP11.phx.gbl...
> > Is there a way for End user to amend the report that is created by
> > Report
> > designer, just like using report builder.
> >
> > We tried creating a report using report designer, but report builder
> > is not
> > able to open it.
> > Is there a walkaround to do so?
> >
> > It is because our end user will like to have the flexibility to make
> > some
> > cosmetic changes to those reports that we created using Report
> > designer.
> >
> > Thanks.
> >
> > "eforce" <eforce@.newsgroup.nospam> wrote in message
> > news:OOvXMSZIGHA.344@.TK2MSFTNGP11.phx.gbl...
> >> Hi,
> >> I am new to SQL reporting service (2005).
> >>
> >> Will like to find out can report builder open a report created
> >> by report designer.
> >>
> >> My scenario is like this, I will like to create some reports for
> >> my clients using report designer. Afterwhich, I will like to a
> >> allow end-user to modify the report using report builder. How
> >> should I solution this?
> >>
> >> I notice that Report Designer can create 2 types of projects
> >> (i.e. model and report server)... When I use the report server, I
> >> am not able to use the model created.
> >>
> >> Is there anything that I miss?
> >>
> >> Thanks
> >>
> >> Regards
> >> eforce
> >>
> >>
> >>
> >
> >
>
>

Report Builder - Filter Dropdown Order Post 2005 SP2 Incorrect

Hi All,

Hope someone can help here. Since installing Service Pack 2 onto our SQL 2005 instances our report models are not working correctly. When selecting fields within the models as filters, and getting them to prompt when the report is run, the ordering of the data within the filters does not match the selected ordering in the model definition. The ordering is random each time the report is run.

This issue does not happen when setting the filter up, the data appears in the correct order, but when running the report the filter data is incorrect.

I have spent the last 4 hours building a new system and testing this with each stage of service packing. The RTM version of SQL 2005 is ok, SP1 is also OK, but when SP2 is applied the ordering fails.

Any ideas?

Many thanks in advance.

Regards

Nick

An update to this issue just in case it may help others.

I logged a call with Microsoft relating to this issue and the product support specialist managed to reproduce the issue at their end. It was passed up to the product teams and the reponse has come back that it is now designed this way even though it worked prior to SP2.

The specific issue is:- Dropdown parameter boxes on reports created using report builder do not adhere to the ordering specified in the report model at runtime, although they do at design time.

As we were adding parameter boxes allowing users to select from almost 1000 branch codes the fact that it isn't ordered and appears in a random order is obviously an issue that has meant we can no longer use report builder.

The workaround suggested by Microsoft is to index the underlying tables so that the table scans of the branch codes scan indexes instead and return ordered lists, as the index is already ordered. Unfortunately I cannot do this as my tables are indexed for performance, and I can't change them to fix an issue that shouldn't (in my personal opinion) be there in the first place.

Hope this helps anyone else in the same situation.

Nick

Report always displays 2 pages

Hi, I have a SQL Reporting service on which I have a footer with the number of page, something like "page 1 of 1". THe thing is, if I preview the report, it displays the nr of pages correctly, however, when I export to PDF; it alwas displays 2 pages, on the 2nd page only displays the footer "page 1 of 2" even if the first page is small and fits that page only. I've tried to reorganize the controls on the report and fit the footer to display only one page, however, no result.. any guess?Thanks a lot!Check the page margins settings in the report's properties.|||Problem solved. I've resized the report width to a less value than the value that I was using and is working!Thanks for the tip!

Reporitng Services Web Service and Credentials

I have developed an asp.net, vb.net web app and have integrated reporting services. Right now I am using url access but am not to crazy about showing the parameters in the querystring. I am using a dynamic stored procedure to get client data. I would like to use the rs web service to programatically set the parameters and send them invisably to the web service. Since the web app is not using windows authentication I would like to pass the parameters using a hard coded account that has been set up with browse privilages in the report manager. Is it possible to hard code the credentials that are sent to the reporting service instead of the System.Net.CredentialsCache.DefaultCredentials? The report returns a bar graph which I am hoping to display on the page. Reading some posts about some problems returning images I might be posting some more questions.

Are there any good walkthroughs or code examples using reporting services web service other than MSDN's limited supply?

Thank you for your time!
--
- preisifigured out the first part

rs.Credentials = New System.Net.NetworkCredential("username", "password", "domain")

Now when i try and render my graph the image can't be found.|||this is not an answer to your question but infact a question to you. can you share with us about how far you have gotten in getting this RS thing to work. i mean i have created some reports which accept a couple of parameters. now i need to create a windows service that calls the reportservice everyday, and prints the report. which is a little similar to what you have done. xcept for the windows service part. so could you share some of your xperience ?

thanks.
dinakar

Reporing Service and deploy permission

Dear all,

I use Window Vista+ Sql server 2005 with SP 2

When I deploy the report in Report designer, the following error message display

The permissions granted to user 'winVista\admin' are insufficient for performing this operation.

The user "admin" is a admininstor and I assign the following group to it

(1) administors

(2)WINVISTA\SQLServer2005ReportingServicesWebServiceUser$WINVISTA$MSSQLSERVER

(3)WINVISTA\SQLServer2005ReportServerUser$WINVISTA$MSSQLSERVER

Which and Where I must assign the permissions to this account?

thanks you

If you connect to Reporting Services in Sql Server Management Studio, right click on the servername and select the properties of the server. Then select the permissions page. What's in there?

Reporing Service and deploy permission

Dear all,

I use Window Vista+ Sql server 2005 with SP 2

When I deploy the report in Report designer, the following error message display

The permissions granted to user 'winVista\admin' are insufficient for performing this operation.

The user "admin" is a admininstor and I assign the following group to it

(1) administors

(2)WINVISTA\SQLServer2005ReportingServicesWebServiceUser$WINVISTA$MSSQLSERVER

(3)WINVISTA\SQLServer2005ReportServerUser$WINVISTA$MSSQLSERVER

Which and Where I must assign the permissions to this account?

thanks you

If you connect to Reporting Services in Sql Server Management Studio, right click on the servername and select the properties of the server. Then select the permissions page. What's in there?

Reponse to reporting service event

Hi,
Is there anyway to response when RS generated report? I need to do extra works such as encryption once report generated, before deliver to customer.

Thank you

Hi,

Can you give me a little more information on what you are trying to accomplish? Such as what are you trying to encrypt and at what event or time should the encryption happen?

Thanks!

|||Hi,
Thank you for reply.

Actually I am trying to protect report generated in PDF from editable. I did some research and found that RS doesn't support this.

Therefore, I am looking for any workaround. I know that is 3rd party tool which able do add "protection" to any existing PDF file. I was thinking to call this 3rd party tool to "protect" RS generated PDF before deliver to client.

Please advice.

Thank you