Publishing Report Server Through ISA Server 2006
Nov 20, 2007
I am having all kinds of problems publishing report server through ISA Server 2006. Are there any guidelines? My biggest problem is that the browser returns an error page that says ISA Server is configured to reject requests that require authentication even though I have configured ISA and the default website to allow anonymous access and require no authentication in the web listener or the firewall policy.
I have a policy that maps an external IP to the default website which has a private IP - 192.168.1.203. I have an A record in my DNS for the external IP. So, I should be able to goto http://MyReportServerSite.com/Reports/Home.aspx. NO GO! Any ideas? I have configured many other web listeners/policies for other sites and they all work fine. I've done this at least twice.
BTW, thanks to MS for the myriad of myriad of dialog boxes, property pages, dropdown lists, check boxes, etc. ad infinitum for configuring ISA Server 2006. I can't even begin to imagine calculating all the permutations... Each iteration of the product seems to get more complex. :-( Hep me, hep me pleeeease!
View 1 Replies
ADVERTISEMENT
Apr 22, 2008
Hi all,
I am having seriuos problems getting VoIP traffic into and out of my network via the ISA server which we just newly installed.
My network topology is such that the phones i am using for the VoIP service, sitting inside my network and behind the ISA server, have to register to some remote proxy server outside my network and as soon as it registers i can begin using the service. The VoIP service is on the platform of SIP and uses udp ports 5060 and 8080.
I have permitted the necessary ports on the ISA server for the service being UDP port 5060 and 8080 but still cannot get my VoIp traffic through the server.
Please i need some help here as regards something i am supposed to do or something i am not doing right on the ISA server to permit my traffic.
I am a newbie to this Microsoft ISA server and i hope you all understand
Thanks in anticipation to your replies.
Leonard.
View 1 Replies
View Related
Mar 18, 2007
I have been trying literally for months to get SQL Server 2005 Express to work on my Dell Dimension WinXPPro machine. I have installed and reinstalled both the server and the 'Management System'. I have shut down and restarted all of the related Local Component Services on my machine (with the exception of the SQL Server Active Directory Helper which will not start ??).
I have reviewed much of what is in this Forum related to SQL Server 2005 Express and I find that many have had similar problems. When a connection is attempted, the following message or some minor variation appears:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
In desparation, and at the suggestion of one of this forum's moderators, I went to try to download the SQL Server 2005 Express, Service Pack 2. I threaded my way through what I felt was an unecessarily complex set of links and finally reached a download site - but it was unclear whether or not the service pack was for SQL Server 2005 or the Express version. Giving up in dispair, it turn to you (once again BTW, I received no real help with this same question about a month ago).
Even though I seriously doubt if anyone will help me, I am willing to give it another try - mainly because I am home sick with the flu and having nothing better to do on a Sunday afternoon.
Thanks
View 6 Replies
View Related
Mar 21, 2007
in footer of my report i show a current date by this
=Format(Today(), "d")
as a result i gave those
3/21/2007
but wont date like this 03/21/2007
How ?
View 1 Replies
View Related
Apr 10, 2006
I'm happyguy and this is the first time to post my problem. Thanks a lot
here is a SQL query that I know how to write in Oracle, which is
Select * from AttandanceRecord where date like '%__/Apr/2006%'
but, now i'm developing my system with using Ms Sql Server 2000, so I don't know how to write a query with same output as above...
Please, can somebody help me??
View 6 Replies
View Related
Oct 12, 2007
Hi all -
We are planning to use a 2-node SQL Server 2005 cluster as part of a new Biztalk 2006 project, and I would like some advice regarding SQL Server service packs and editions.
Testing has already been running for some time without problems, but the test environment (a) is not clustered, (b) is using SQL Server 2005 Standard Edition rather than Enterprise and (c) has neither of the SQL Server service packs installed.
As this is a major project for us, my instinct would be to use Enterprise Edition (maximise performance and scalability)
and to apply SP2 (because I thought it was best practice to be up-to-date). I would have liked to do this before we go Live so we don't run the risk of having to change afterwards if we hit a problem.
Understandably, the project guys' perspective is this: testing so far has not been affected by SQL Server bugs, and we should go Live with the environment we have tested in, albeit with the planned 2-node cluster which is seen as a 'must have'.
I have trawled Books Online, Technet and other resources without success, so any thoughts or info on required, recommended or preferred combinations of Biztalk 2006 with SQL Server 2005 editions and service packs in a clustered
environment would be greatly appreciated - thanks!
Michael
View 5 Replies
View Related
Aug 25, 2007
Can someone assist? I'm using the applciation Project Portfolio Server 2006. Have reporting services setup and when I try to create a custom report this is the error I receive:
The report server cannot process the report. The data source connection information has been deleted. More Info: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInvalidDataSourceReference&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.2047.00
Also does anyone know of a good location for information on troubleshooting Project Portfolio Server 2006? Can't find much good documentation.
Thanks, Julie
View 1 Replies
View Related
Jun 11, 2008
Sir,
I have created reports in SQL Server reporting services(SSRS)and when i publish the report in the Localhost server it can be viewed in browser only in the INTRANET network but my intention is to generate the INTERNET URL of the report such that report published can be viewed in INTERNET outside this network..
Can u suggest any solution to do the same..
Looking Forward to an early reply..
Thank You!!!
View 1 Replies
View Related
Jun 5, 2007
Hi!
I have a rdl file and would like to publish it programmatically? Is there any API or Web Service available for this.
View 1 Replies
View Related
May 7, 2008
Anyone know how I can direct different reports in the same project to different folder on the SSRS site? I can get everyone to publish to one folder, but want to know if its possible on a report/report basis to different folders
View 3 Replies
View Related
Dec 22, 2004
Hey all,
I received this publishing error a while back and can't think of a reason I would be receiving this error.
SQL error occurred. See entry specific information. Error : 21010, 01000, [Microsoft][ODBC SQL Server Driver][SQL Server]Removed 0 replicated transactions consisting of 0 statements in 6 seconds (0 rows/sec).
The error came just before another error:
SQL error occurred. See entry specific information. Information : 1205, 40001, [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
I'm wondering what would cause these errors, if someone could point me in the right direction that would be great.
Cheers,
-Kilka
View 2 Replies
View Related
Nov 27, 2007
I have a dropdown which shows all the available reports on reporting server. What I want to do is when a user select a report from dropdown and click on RUN REPORT button. That particular report will run. I am using VB.NET 2.0 version. One way which i am thinking is to use ReportViewer Control. Is there any other way to publish the reports in window forms or ReportViewer will take care. Kindly guide.
Thanks,
View 4 Replies
View Related
Oct 20, 2006
Now here is something I have been asking the SQL Server Team for a long long while : http://www.microsoft.com/downloads/details.aspx?familyid=16D8C1E9-A6A3-43A2-9BA7-916C6EB5023B&mg_id=10046&displaylang=en . I hope this will be of use to many of us
View 1 Replies
View Related
Oct 17, 2006
The SQL Server group at Microsoft has just launched the SQL Server Hosting Toolkit with the release of the Database Publishing Wizard Community Technology Preview 1.The objective of the SQL Server Hosting Toolkit is to enable a great experience around hosted SQL Server. The Database Publishing Wizard works toward this mission by making it easy to upload a database from a development box up to a shared hoster. In its first incarnation, the Database Publishing Wizard is a command line tool that generates a T-SQL script designed to be executed in the script execution windows provided by most hosters in their database management consoles. In the coming months we'll be adding a GUI and building seamless integration between the tool and an upload service we'll provide to hosters for deployment.Details on the Database Publishing Wizard as well as the download can be found at http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard.We plan to be releasing advances in the Toolkit frequently so check out this first CTP and give us your feedback!Thanks,Dan WinnSenior Program Manager, Microsoft SQL Server
View 15 Replies
View Related
May 31, 2006
Thanks for taking your time to read this.(sorry if someone posted this earlier but no solutions helped)
After i published my website, i am unable to login anymore. It has this error of "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed."
Note ** im using vb
View 1 Replies
View Related
Oct 31, 2007
Hi,
I have couple of Web pages linking to my RDLs using report viewer Web controls. I have no problem running and viewing them in VS2005 debug mode and report manager until I published them to local folder and set the local folder as an application on my IIS7. When running the published version of the Web pages, all my calendar image buttons (which happen to be part of the report parameter fields) turned to red 'X':
http://dyzimw.bay.livefilestore.com/y1pwxE9mLpX4JV7e438WA4DeGwu6YHQOkRoC20r_EhQ5uoXkt15dqs99LmiDSTauSvUCno9HnOwYKR34rPpFYA_lQ/ssrs.jpg
When clicking the View Report button, the animated progress icon not appearing at all. Before the occurance of this problem, I did face the problem whereby the 'NT AUTHORITYNETWORK SERVICE' does not have enough permission to view the report. After referring to some threads, I finally be able to get rid of this error by assigning Browser role to 'NT AUTHORITYNETWORK SERVICE' from the report manager. I wonder could this solution be related to the problem that I'm facing now. Any help would be appreciated.
Thank you.
Regards,
Antonio
View 1 Replies
View Related
Sep 9, 2006
Hi My project is in .NET 2003 i.e. framework 1.1 and database in SQLServer 2000. But the reports have been developed using SQLServer 2005 Reporting Services. Now when I am trying to deploy them through deployment project of .NET its giving me following error:"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services. Now I am really confused with this. Can any one please guide me regarding this ASAP. Thanks, Falguni
View 4 Replies
View Related
Apr 11, 2007
Hi -
I got through the installation hoops for SQLEXPRESS Reporting Services in Vista and set up the default configurations in Report Services Configuration. I can explore the default directory for "Reports" in IIS7, but I can't browse in IE. I get the "The report server is not responding. verify that the report server..." message in the browser. This is after I migrated the app per the initial http 500 error using the preferred method - %systemroot%system32inetservAPPCMD.exe migrate config "Default Web Site/Reports".
I'm running Vista Ultimate, VS2005, SQLEXPRESS SP2. I've tried running IE as admin and also I've disabled UAC from gpedit.msc - ...Windows SettingsSecurity SettingsLocal PolicySecurity Options and unchecking UAC.
Thanks,
Mike
View 13 Replies
View Related
May 25, 2007
Hi every one,
I'm very new new at this. I'm try to deploy a report model and got this message. I have no idea what its going on about.
Can anyone help me?
Aku
------------------------------
System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: Bad Data. (Exception from HRESULT: 0x80090005)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.DataProtection.ProtectData(Byte[] unprotectedData, String tag)
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName)
at Microsoft.ReportingServices.Library.DBInterface.GetAllConfigurationInfo()
at Microsoft.ReportingServices.Library.RSService.GetSystemProperties(Property[] requestedProperties)
at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) (System.Web.Services)
------------------------------
BUTTONS:
OK
------------------------------
View 38 Replies
View Related
Dec 5, 2007
every 1 hour my server's computer is restarting !
when the windows finish restarting i open the Event viewer and see that what coused it is the error :
"Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database."
Event 107
source : "Report Server Windows Service (MSSQLSERVER)"
How can i solve it ?
View 4 Replies
View Related
Dec 12, 2007
do you mean first install SDK, then install IIS, then install report sever?
I have same problem.
any can help?
View 1 Replies
View Related
Oct 9, 2007
When I trying to configure Reposrting services in IIS & XP. It hsows me error
"The report server is not responding. Verify that the report server is running and can be accessed from this computer."
I also configure with reposrting configuration tools which show all confuguration is perfect.
but when I try to open through IE http://localhost/Reports/Pages/Folder.aspx
or http://localhost/Reportserver
It shows error. I try all ways still not works ..Help me out
Thanks.
View 9 Replies
View Related
Mar 30, 2007
I would like to know if it is possible to have different applications on separate report servers sharing one report server database. If so are there possible issues or ptfalls to this type of architecture?
Thanks,
thecoleman
View 3 Replies
View Related
May 7, 2008
***SSRS 2000 ISSUE***
Hi All
Recently, several of our users have started to experience issues with hyperlinks in a report. I have created a textbox added navigation and selected the report to 'jump to' and the users are getting this error:
The specified server url does not link to the report server for this report manager or is not in the correct format
I have changed this to a an url but the error persists - there is nothing on google or MSDN that i can find which relates to this error so im kinda stuck with this one! The error is not affecting all users, just a small subset of them. Each of the users has different AD rights with one of them being a Domain Admin so i dont think it is a security issue.
the hyperlink which is being built is this :
http://<SERVERNAME>/SQLReports/Pages/Report.aspx?ServerUrl=http%3a%2f%2f<SERVERNAME>%2fReportServer%3f%252f<SERVERNAME>%252fS<REPORTNAME>
*obviously the <SERVERNAME> and <REPORTNAME> are not real server or report names - im just being cautious by not including this detail on a forum post.
Report manager is installed on several machines as part of a webfarm but this has not caused any problems in the past (i have over 200 reports under my belt thus far)
....Anyone have any ideas?
View 8 Replies
View Related
Jul 5, 2007
Hi
I went to my comp ->rt cick->manage-IIS->default website->rt click->properties->directory security->annoymouse access€¦EDIT->under Default domain it was blank, and i added a domain there.
And i was getting error opening up the reports from localhost.
I changed everything to same as it was previosly, and I am getting the error:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError) Get Online Help
Cannot open database "ReportServer$SQLExpress" requested by the login. The login failed. Login failed for user 'NGESComputer name$'.
View 1 Replies
View Related
Jun 16, 2006
SQL server 2005 express reporting problem.
error message:
This feature "remote access to report data sources and/or the report server database" is not supported in this edition of reporting service
I got this error message when I try to connect to database hosted in another PC running SQL server 2000.
Is it true that SQlL server Express can only use Local Database Engine to host the database?
View 5 Replies
View Related
Mar 29, 2007
Hi,
I am newbie and working with an application that ueses report server 2000 to make reports.
The problem is somebody has moved the database and changed some acounts and now I can not either get any report from the server or install my changes for reports. I used to run this commando to install changes for reports:
rs -i PublishGeckoReports.rss -s http://IpAddress:32808/reportserver -v definitionPath="C:TempDeploymentReportsRDL" -v targetFolder="/MyReports"
here is the error message i get when i try to install:
System.Web.Services.Protocols.SoapException: The report server cannot open a connection to the report server database. The logon failed
when I browse to http://IpAddress:32808/reportserver I get following:
The report server cannot open a connection to the report server database. The logon failed. (rsReportServerDatabaseLogonFailed) Get Online Help
Logon failure: unknown user name or bad password.
at IIS Manager for default web site Enable Anonymous Access is checked and on the database server and the web.config file use same account and password.
but I heard that somewhere there is encrypted password that i have to change it too.
I need your help
Thanks
View 2 Replies
View Related
Jan 5, 2007
Hi,
I got consistent error of the following:
ReportingServicesService!runningjobs!13!1/3/2007-10:45:21:: e ERROR: Error in timer Database Cleanup (NT Service) : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
--- End of inner exception stack trace ---
The error happens on Reporting Service version 9.00.3017.00 (the version we are running in Production). The Reporting Service and its database are actually resided in the same physical server. And the strange thing is that it does not prevent any functionalities or features working except when I launch the Management Studio on that server, it usually takes 2 minutes to load up. (any other server would just take 5 -10 seconds).
Can any one help?
Thanks!
William.
View 1 Replies
View Related
Feb 15, 2007
I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003 server. The configuration has been unchanged for approx. 3 weeks. Suddenly today, reports being accessed via an ASP.NET 2.0 application (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver became inaccessable. End users received the following error:
Message: An error occurred during rendering of the report. --->
An error occurred during rendering of the report. --->
An error occurred during rendering of the report. --->
An error occurred during rendering of the report. --->
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Stack Trace: at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at IFA.CAP.SQLReportingService.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds) in C:ApplicationsIFACAPWeb ReferencesSQLReportingServiceReference.vb:line 1319
at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID, Boolean isDraft, Boolean isCertified) in C:ApplicationsIFACAPBusinessObjectsIFA.CAP.BusinessObjects.Report.vb:line 551
at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e) in C:ApplicationsIFACAPMainCertificateDetail.aspx.vb:line 2287
Subsequently, the following error is logged on the Report Server/Database server:
Report Server (MSSQLSERVER) cannot connect to the report server database.
I was able to temporarily correct the problem by performing as iisrest on the Report Server/Database server. However, the same problem occured again a couple hours later. I am relatively new to SQL Reporting Services so any help would be appreciated.
MDJ
View 1 Replies
View Related
Jan 9, 2007
I am getting the following error, when trying to deploy. the report should point to a server which is in my network, but the report is on my machine. where i am trying to deploy locally but point to a different machine.
******************************************************
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing.
***********************************
Thank you very much for the information.
View 3 Replies
View Related
Apr 15, 2008
Hi all,
Please tell me about difference between SQL Server 2005 and SQL Server 2008 SSRS(Sql Server report)
Why to upgrade for Sql Server 2008
Thanks,
Ashok
View 3 Replies
View Related
