Thanks...
Hi,
as a prerequisite, you will need to have IIS installed first, is it ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||I figured it out, but thanks anyway :).|||Could you please post your solution then, that any other reader can participate on your work ?sqlAny help please.
Juvan
Reporting Services is included with SQL Express Advanced. Launch this installer and you will see an option to install it during the "Feature Selection" dialog.
Thanks,
Sam Lester (MSFT)
Any help please.
Juvan
Reporting Services is included with SQL Express Advanced. Launch this installer and you will see an option to install it during the "Feature Selection" dialog.
Thanks,
Sam Lester (MSFT)
Hi all,
I am developing reports using sql2005 report service. I can export reports in excel and pdf format, but can't export to csv and xml correctly.
The exported csv and xml files only contain some thing like the textbox,..., but no report content are there.
Anybody can help? thanks in advance.
BTW, all reports are matrix, is martrix can cause some issues?
Hi,
For most items on your report, you can define how it needs to be rendered to XML. For example the xml output for an item in a matrix can be set as follow:
select the item in the matrix|||
Thanks, Greert.
Your reply is really helpful. Now I know how to export report in xml format. But, how about CSV? I still can't export report to csv.
Thanks again
|||
Hi,
The same goes for CSV. For example if you set the Output of a column to No, you will see that the column is not included in the CSV file.
Greetz,
Geert
Geert Verhoeven
Consultant @. Ausy Belgium
My Personal Blog
|||Hi Geert,Thanks a lot.
When I set th output of a column to yes, it works. Before, the the output of column was set to Auto.
We're new to SQL Reporting Services and have a new SQL 2005 server.
I'm having a problem activating scubscriptions.
- "New Subscription" is greyed out in Server Management Studio.
- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error;
"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"
Any suggestions?
Found the problem.
When configuring the Data Source the "Impersonate the authenticated user after a connection has been made to the data source" button should be off.
Thanks for the tip!|||Be careful! This might sound very fool but sometimes the problem is that the paramethers are bad passed to the report, or the report's paramethers has non-english characters, like '?'.
I've passed 'a?o' (year, in spanish) as a paramether, and nothing seems to work'till I changed that.
I hope this help all of you.
Saludos desde el sur del mundo.|||What screen are you configuring the data source? I can't find the button you are referring to.
We're new to SQL Reporting Services and have a new SQL 2005 server.
I'm having a problem activating scubscriptions.
- "New Subscription" is greyed out in Server Management Studio.
- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error;
"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"
Any suggestions?
Found the problem.
When configuring the Data Source the "Impersonate the authenticated user after a connection has been made to the data source" button should be off.
Thanks for the tip!|||Be careful! This might sound very fool but sometimes the problem is that the paramethers are bad passed to the report, or the report's paramethers has non-english characters, like '?'.
I've passed 'a?o' (year, in spanish) as a paramether, and nothing seems to work'till I changed that.
I hope this help all of you.
Saludos desde el sur del mundo.|||
What screen are you configuring the data source? I can't find the button you are referring to.
We're new to SQL Reporting Services and have a new SQL 2005 server.
I'm having a problem activating scubscriptions.
- "New Subscription" is greyed out in Server Management Studio.
- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error;
"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"
Any suggestions?
Found the problem.
When configuring the Data Source the "Impersonate the authenticated user after a connection has been made to the data source" button should be off.
Thanks for the tip!|||Be careful! This might sound very fool but sometimes the problem is that the paramethers are bad passed to the report, or the report's paramethers has non-english characters, like '?'.
I've passed 'a?o' (year, in spanish) as a paramether, and nothing seems to work'till I changed that.
I hope this help all of you.
Saludos desde el sur del mundo.|||
What screen are you configuring the data source? I can't find the button you are referring to.
We're new to SQL Reporting Services and have a new SQL 2005 server.
I'm having a problem activating scubscriptions.
- "New Subscription" is greyed out in Server Management Studio.
- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error;
"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"
Any suggestions?
Found the problem.
When configuring the Data Source the "Impersonate the authenticated user after a connection has been made to the data source" button should be off.
Thanks for the tip!|||Be careful! This might sound very fool but sometimes the problem is that the paramethers are bad passed to the report, or the report's paramethers has non-english characters, like '?'.
I've passed 'a?o' (year, in spanish) as a paramether, and nothing seems to work'till I changed that.
I hope this help all of you.
Saludos desde el sur del mundo.|||
What screen are you configuring the data source? I can't find the button you are referring to.
Hi all, for some reason I can't connect to SQL Server 2005 reporting services. When I try to log in I get "the request failed with HTTP status 404:Not Found".
When I installed SQL Server, port 80 was not available as I am also running Apache, so SQL Server Report Server runs at http://localhost:81/ReportServer/ .. this work fine, I have build a report, deployed it successfully and can view it.
In SSMS I see two 2 databases, ReportServer and ReportServerTempDB.
Everything looks OK in the Report Server Configuration Manager, however in the Surface Area Configuration when I click on "
Windows Integrated Security" under the Reporting Services node it also comes back as "the request failed with HTTP status 404:Not Found"
Does anyone have any ideas how I can fix this, does it look like it is looking for Reporting Services on the wrong port? 80 instead of 81 ?
Thanks for any advice
Hello, I have had a similar problem and posted a thread on it at: http://tinyurl.com/zke4gI've been running IIS 5.1 on port 200 just for security as hackers go straight for 80 if they are trying anything. While my problem is similar to yours, I have seen nothing that says the port is the problem especially given it persists when I switch IIS to port 80. A common move with Apach is to go into the config file and set apache to :8080, I've done that though it's been years and the details of how to are fuzzy.
Good luck. - Greg
I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. I have also check the reporting services configurations manager for any issues but still can't connect. The http://localhost/reportserver also is down. I also checked if ASPNET account belongs to the Reporting Services security settings and it does. IIS is up and running.
I'm running SQL 2005 Enterprise 64bit with Service Pack 2.
===================================
Cannot connect to ctbbcysql02.
===================================
The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
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()
Any help will be greatly appreciated.
Regards,
Ruaan
RuaanD79 wrote:
I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. The http://localhost/reportserver also is down.
That would be why you can't connect to it. What indicates to you that the report server is down? Is it really down or you just can't connect to it?
What, if anything, is not checked on the Reporting Services Configuration Tool?
When I try to connect to the Reporting Services using Microsoft SQL Server Management Studio, the following error message propmpts up:
_
ADDITIONAL INFORMATION:
The request failed with HTTP status 401: Unauthorized. (Microsoft.SqlServer.Management.UI.RSClient)
_
Is there any settings that I need to do in the "Reporting Services Configuration Manager" ?
Thanks.
Best regards,
Michael Wu
Did you found out how to fix this? I am getting exactly the same error.