I have installed SP2 successfully a number of times before, but always where the Report Server and the Report Server databases were on the same box. This is the first time trying to install the Service Pack where the Report Server is on server X and the databases are on server Y.
When I try to run the SP (on server X), I get the following message:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I am logged in using a domain account that is a local admin on both servers (and also the SQL Server startup account on server Y). It is also the account used by the Report Server to connect to the RS databases. The startup account for the Report Server service is 'NT AUTHORITYNETWORK SERVICE'.
Hi, This may be a trivial question but neither SQL Server 2000 Reporting Services SP1 or SP2 wil install against our SQL Server 2005 Developer edition installation.
Our Version: Microsoft SQL Server Reporting Services Version 9.00.3027.00
Does anyone know whether the Services Packs are for SQL Server 2000 only? if so, whether the new functionality in SP2 will be made available to SQL Server 2005?
I am trying to migrate my reports from SQL server 2000 reporting services 32bit to 2005 64bit. I am following the migration steps that MS specified. Restored my Reportserver and ReportserverTempDB databases Then I was using the configure Report services to upgrade these databases but I always end up getting the follwoing exception when I run the upgrade on the "Database Setup" configuration for 'ReportServerTempDB' database System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'ReportServerTempDBTempDB'. No entry found with that name. Make sure that the name is entered correctly. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
It's driving me crazy, why is it looking for 'ReportServerTempDBTempDB' in the catalog instead of 'ReportServerTempDB'? Is it possible to migrate from 32bit to 64bit?
I'm attempting to obtain a cost effective solution for my existing customers to develop reports on their SQL 2000 Server installations using their Reporting Services 2000. With products like Visual Basic.NET 2003 becoming almost impossible to obtain, I have at least one customer who is running into a dead end.
One option possibly is the SQL Express with Advanced Services download, which has Reporting Services. My questions are as follows:
Can the report designer component of SQL Express Reporting Services be configured to connect to an external database (which would happen to be a SQL 2000 database) to establish its datasets? Does the resultant designed report end up in an RDL file? If the customer published this report via the Reporting Services 2000 Report Manager, would the report be able to run?
Sorry for asking a question like this that I could probably answer on my own, but my customer needed this answer yesterday. I have scoured the web and microsoft sites - and posted a question on the official SQL Reporting Services cateogy ... in an attempt to answer the basic question of how to design reports for Reporting Services 2000 in the absence of Visual Basic.NET 2003 (or other .NET 2003 tools) with no success.
I have a particular report that fails to run. In the browser, the following is shown when the report is run:The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.There is an error in XML document (1, 84459).'', hexa decimal value 0x01, is an invalid character. Line 1, position 84459.
When I look into the SSRS logs, I find the following:
library!ReportServer_0-125!6dc0!11/05/2015-08:40:58:: Call to GetPropertiesAction(/PathTo/MyReports/MyReport by Hour, PathBased). library!ReportServer_0-125!1d34!11/05/2015-08:40:59:: Call to GetSystemPermissionsAction(). ui!ReportManager_0-126!65f8!11/05/2015-08:40:59:: i INFO: PageCountMode 'Estimate' read from config file ui!ReportManager_0-126!65f8!11/05/2015-08:40:59:: i INFO: AccessibleTablix value not specified in config file. library!ReportServer_0-125!6dc0!11/05/2015-08:40:59:: Call to GetSystemPropertiesAction(). rshost!rshost!1d50!11/05/2015-08:41:02:: e ERROR: WriteCallback(): failed to write in write callback.
[code]...
There are no other system logs at the corresponding time of this failure.Other reports that use the same data source run fine. This problem is confined to a few reports within a larger report set. The reports are provided by a third-party so I don't have a lot of insight to what the report is actually doing.This is running on SSRS 2008 R2.
Hi all, i am tring to install and configure reporting services in Windows 2003 SP2- 64 bit machine as part of installing SCE 2007, and i followed the procedure for confiurng all the options in reportingservices config tool,
all the options show green flag and still could not proceed further as the following error is coming
"The Selected Sql server reportin service instance is not configured , please configure to continue" which halts the further process,
I have installed SQL Server 2005 edition and installed Sql server 2005 SP2 also,
We are facing an issue where the report rendering for specific report parameters is failing with an exceptionÂ
Throwing Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: , Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.TablixContext.CalculateDetailCell(PageItem topItem, Int32 colIndex, Boolean collect, PageContext pageContext)
[code]....
The server is running in Native mode. We tried restarting the services and also verified the disk space. Neither of them worked. The ExecutionLog3 table in the "ReportServer" database shows a rrenderingError as the report execution status. Report rendering with Excel format works fine.We enabled verbose logs and they are shared here. URL....
I can run the following query in Management Studio, but get the error listed below when I run it from the data tab in Reporting Services:
declare @starttime as datetime declare @endtime as datetime declare @timezone as integer declare @date as datetime
set @timezone = 1 set @date = '5/1/2007'
set @starttime = dateadd(hh, @timezone, @date) set @endtime = dateadd(d, 1, @starttime)
select @Starttime, @endtime from site
Error Message:
TITLE: Microsoft Report Designer ------------------------------
An error occurred while executing the query. The variable name '@starttime' has already been declared. Variable names must be unique within a query batch or stored procedure.
The variable name '@starttime' has already been declared. Variable names must be unique within a query batch or stored procedure. (Microsoft SQL Server, Error: 134)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=134&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------
What I am trying to accomplish is the ability for users to select which time zone they want the data in the report to display in. To do this, I created a timezone parameter that has the offset from Central Time (which is how all data is stored in our database).
I'm using the System Center Essential 2007 VHD (http://go.microsoft.com/fwlink/?LinkId=91061). It has an SQL Server Express Edition with Advanced Services installed as a named instance, SCEVHDSCE. I tried to upgrade the SQL Server to Enterprise Edition, because some of the reports are not working in Express. I started the setup with the SKUUPGRADE=1 switch, it found the SQL Engine and Reporting Services components and offered to upgrade them. Upgrading the SQL Engine was successful, however the Reporting Services failed with the following error:
SQL Server Setup did not have the administrator permissions required to copy a file: C:Program FilesMicrosoft SQL ServerMSSQL.4Reporting ServicesReportServer ssrvpolicy.config. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
I checked the file, it exists and the current account (which is a domain administrator) has permissions. I stopped all services which could use the reporting services, rerun the setup now only for reporting services, but the same error occured. For the third try I started Filemon also, and it captured the following trace. http://mit.bme.hu/~micskeiz/files/sql-rs-install-error.jpg From this I guess the following: until row 442 it checks the existense of the target folder and creates the folder for the upgraded instance in C:Program FilesMicrosoft SQL ServerMSSQL.4. In step 443 probably it wants to copy the old config, but it searches them in the C:Program FilesMicrosoft SQL ServerMSSQL.2 folder, which should be the location of a default reporting services install. However, the setup of System Center Essentials installs its SQL Server Express Reporting Services in C:Program FilesSystem Center Essentials 2007Microsoft SQL ServerMSSQL.2, thus the setup fails because it is looking for rssrvpolicy.config in the wrong folder. Do I see the problem correctly? The setup log can be found here: http://mit.bme.hu/~micskeiz/files/SQLSetup0005_SCEVHD_RS.log
I tried to do a command line install, but I did not found a switch to tell the old location of Reporting Services. Neverthless I tried the following command: D:>start /wait setup.exe ADDLOCAL=RS_Server INSTANCENAME=SCEVHDSCE UPGRADE=RS_ Server SKUUPGRADE=1 /qb But the setup said that the requested component could not be found.
Any suggestions?
Thanks, Zoltan (I will be on vacation from next week, so I could not respond for a week.)
I've been reading a lot of posts on this subject. I understand that the issue is due to the fact that the subreport is only rendered once. So after the main report is sorted on another column, the cell with the subreport produces an error.
What I want to know is whether or not this is considered a defect. And if it is a defect, is it fixed in another version?
I am currently running SSRS SQL2008R2 SP2 (20.50.4000.0)
Included the option RS_Tools in ADDLOCAL clause The error message displayed is €œThe feature(s) specified are not valid for any SQL Server products€?, if the RS_Tools is excluded the command works fine.The option doesnt exist in template.ini
The error message displayed on screen is "The feature(s) specified are not valid for any SQL Server products"
Command to Reproduce "D:Serversetup.exe" /qb INSTALLSQLDIR="D:" INSTANCENAME=MSSQLSERVER ADDLOCAL=RS_Server,RS_Web_Interface,RS_Tools RSCONFIGURATION=FilesOnly RSACCOUNT=ServiceAccount RSPASSWORD=xxxxxxxxxx RSAUTOSTART=1 SQLBROWSERACCOUNT= Service Account SQLBROWSERPASSWORD=xxxxxxxx SQLBROWSERAUTOSTART=1
Setup Log : SQLSetupxxxx_MachineName_Core(Local).log <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Failed to find feature:RS_Tools : 70002 Message displayed to user The feature(s) specified are not valid for any SQL Server products.
Product : OWC11 Error : Error 1311. Source file not found: C:DOCUME~1TOMCUR~1LOCALS~1TempIXP000.TMPSKU0A4.CAB. Verify that the file exists and that you can access it. -------------------------------------------------------------------------------- Machine : D7NSJK71 Product : Microsoft Office 2003 Web Components Product Version : 11.0.8003.0 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_D7NSJK71_OWC11_1.log Last Action : InstallExecute Error String : Source file not found(cabinet): C:DOCUME~1TOMCUR~1LOCALS~1TempIXP000.TMPSKU0A4.CAB. Verify that the file exists and that you can access it. Error Number : 1311
When the dialog box appeared indicating file couldn't found, there was no option to look elsewhere for it the only option was retry or cancel which after 5 or 6 retries I cancelled. Everything else appears to have installed correctly for this instance.
Also earlier attempts to install have left services for named instances that I cannot install to such as SQLEXPRESS , SQLEXPRESS1 and CURRIEREXPRESS, I long ago had a beta version installed and have attempted numerous methods to completely wipe these out using the uninstallbetas tool from Microsoft as well as a number of suggestions from some posts.
Please help - The most significant reason I'm installing this is to practice creating SQL Reporting Service reports
I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?
i have a small problem with the data sources in the reporting services, maybe you can clarify the situation... I have a MS CRM 3 solution with the reporting services 2005 installed. From an other vendor we have a arcplan solution on the 2000 analysis services. I would like to get access from the 2005 reporting services to the 2000 cube. Is this possible? Ive read that the SSMS cant connect to the 2000 cubes. Can i connect from the reporting services??
Can report be created with code (XML, SQL, ActiveX?) using the new Reporting Services for SQL Server 2000?
I have to create a report and save it in Excel format. By default the report is saved as - *.rdl. but the web report server has an option of saving it as excel or pdf etc formats. Is there a way to do this automatically? ie by code and not manually
I have used SQL 2005 reporting services for quite sometime and now one of our clients wants the SQL 2005 reports that I developed. There's only one catch: they only have SQL 2000.
Is there any way to deploy my reports to their server on SQL 2000?
I have seen this done by someone else but cant seem to find how to do it...basically I have a sytle sheet which I want to use on all the Reporting Services reports, to so they all look the same....
I am trying to get SQL 2000 reporting services up and running, and am trying to get a condensed explanation of what I need to do, and any other software I may need to purchase.
I have already installed the Reporting Services, and after reading the help, it seems that I have to install MS Visual Studio 2003 in order to design the reports. Is this true.
Anyone that can give me some help in getting this up and running - I would be grateful.
I have used Reporting Services 2000 to create a template, and works in a mail merge sort of way, creating a delivery note for each order.
The problem I have is, if an order goes over two pages.. I need a easy way to present this, so that the user knows to send two pages.... Obviously, the correct way would be to page it in some way but from what I understand, RS 2000 would page the whole documents (ie all orders) and there is no way of paging in respect to a group (ie order no)
The next option is to have cont. at the bottom of page 1 (if there are more than 1 page), does any1 know how to do this? cos of obviously on the screen it will always be 1 page???
I hope I make some sense... any help would be great....
When i save a report as a web archive page breaking for the report is not enabled ?The entire data is displayed in a single page even if paging properties are enabled for the report.
I am trying to figure how to programmatically pass parameters to the report in SQL Reporting Services using web service API and then send this report to the printer. I found code in C# on how to print and it does work very well. I am hoping to add report parameters to this module. Any ideas, samples or help would really be appreciated.
here is the code for printing
using System; using System.Drawing; using System.Drawing.Imaging; using System.Drawing.Printing; using System.IO; using System.Web.Services.Protocols; using PrintReport.reportserver; using System.Runtime.InteropServices; // For Marshal.Copy
namespace PrintReport { /// <summary> /// A simple console application that demonstrates one way to /// print Reporting Services reports to a printer. /// </summary> class app { /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main(string[] args) { PrintExample pe = new PrintExample(); // The name of the printer should be added here; // this could be a local or network printer. pe.PrintReport(@"\jacc-fs120S2500 PCL IT"); } }
class PrintExample { ReportingService rs; private byte[][] m_renderedReport; private Graphics.EnumerateMetafileProc m_delegate = null; private MemoryStream m_currentPageStream; private Metafile m_metafile = null; int m_numberOfPages; private int m_currentPrintingPage; private int m_lastPrintingPage;
public PrintExample() { // Create proxy object and authenticate Console.WriteLine("Authenticating to the Web service..."); rs = new ReportingService(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; }
// Build device info based on the start page deviceInfo = String.Format(@"<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>", "emf");
//Exectute the report and get page count. try { // Renders the first page of the report and returns streamIDs for // subsequent pages firstPage = rs.Render( reportPath, format, null, deviceInfo, null, null, null, out encoding, out mimeType, out reportHistoryParameters, out warnings, out streamIDs);
// The total number of pages of the report is 1 + the streamIDs m_numberOfPages = streamIDs.Length + 1; pages = new Byte[m_numberOfPages][];
// The first page was already rendered pages[0] = firstPage;
for (int pageIndex = 1; pageIndex < m_numberOfPages; pageIndex++) { // Build device info based on start page deviceInfo = String.Format(@"<DeviceInfo><OutputFormat>{0}</OutputFormat><StartPage>{1}</StartPage></DeviceInfo>", "emf", pageIndex+1); pages[pageIndex] = rs.Render( reportPath, format, null, deviceInfo, null, null, null, out encoding, out mimeType, out reportHistoryParameters, out warnings, out streamIDs); } }
private void pd_PrintPage(object sender, PrintPageEventArgs ev) { ev.HasMorePages = false; if (m_currentPrintingPage <= m_lastPrintingPage && MoveToPage(m_currentPrintingPage)) { // Draw the page ReportDrawPage(ev.Graphics); // If the next page is less than or equal to the last page, // print another page. if (++m_currentPrintingPage <= m_lastPrintingPage) ev.HasMorePages = true; } }
// Method to draw the current emf memory stream private void ReportDrawPage(Graphics g) { if(null == m_currentPageStream || 0 == m_currentPageStream.Length || null ==m_metafile) return; lock(this) { // Set the metafile delegate. int width = m_metafile.Width; int height= m_metafile.Height; m_delegate = new Graphics.EnumerateMetafileProc(MetafileCallback); // Draw in the rectangle Point destPoint = new Point(0, 0); g.EnumerateMetafile(m_metafile,destPoint , m_delegate); // Clean up m_delegate = null; } }
private bool MoveToPage(Int32 page) { // Check to make sure that the current page exists in // the array list if(null == this.RenderedReport[m_currentPrintingPage-1]) return false; // Set current page stream equal to the rendered page m_currentPageStream = new MemoryStream(this.RenderedReport[m_currentPrintingPage-1]); // Set its postion to start. m_currentPageStream.Position = 0; // Initialize the metafile if(null != m_metafile) { m_metafile.Dispose(); m_metafile = null; } // Load the metafile image for this page m_metafile = new Metafile((Stream)m_currentPageStream); return true; }
private bool MetafileCallback( EmfPlusRecordType recordType, int flags, int dataSize, IntPtr data, PlayRecordCallback callbackData) { byte[] dataArray = null; // Dance around unmanaged code. if (data != IntPtr.Zero) { // Copy the unmanaged record to a managed byte buffer // that can be used by PlayRecord. dataArray = new byte[dataSize]; Marshal.Copy(data, dataArray, 0, dataSize); } // play the record. m_metafile.PlayRecord(recordType, flags, dataSize, dataArray);
return true; }
public byte[][] RenderedReport { get { return m_renderedReport; } set { m_renderedReport = value; } } } }
I have installed SQL Server 2000 Reporting Services with the default names for the virtual directories , (ReportServer and Reports). Is there any way i can change the name of these directories by running a script or some thing.
Also is there a way to use the Cascaded Style Sheet used in my ASP.NET application for the reports.
We had someone leave work and he was responsible for the reports for our company. He used SQL 2000 w/ Reporting Services. The connection to the report server was tied to his userid and password. Since his account was disabled the website will not connect to the reporting database because it was tied to his account. Is there a way to reset the connection creditions? I looked on the server and I can't find the Reporting Services Admin Tool.
i am working in vs.net 2005 (c#.net & asp.net), my application need reporting functionality, for that i am using Sql Reporting Services 2000 in vs.net 2005, and i am not able to generate the report, can any pls tell me how to use sql reporting services 2000 in vs.net 2005 and configuration setting etc...
it would really help more to build my applications in sophisticated way
I am intalling SQL 2000 Reporting Services on my Development Machine. Win Xp, VS .Net 2005 & VS .Net 2003. I do have ASP .NET 1.1 & 2.I am frustated even though I have ASP .NET 1.1 installed it kept complaining that it is not installed. I also tried registering ASP .NET 1.1 version through Visual Studio command Prompt.
Still it is complaining that I don't have ASP .NET 1.1
i would like to install Report Services on visual studio 1.1 version
using sql server 2000. i currently have sql server 2005 and visual
studio 2.0 and there is no problems and so i remember how that
works.
With sql server 2000 i saw a link to a trial version of reporting services that i can download and install but after 120 days it's no good. I think that provides the gui interface to install reporting
services like the 2005 version except less robust. But i'm wondering with the proper service packs of sql server 2000 installed if i can
bypass download.
Can somebody help me how to install reporting services with sql server 2000, pre-req and software i need. I currently have the
I am a newbie to SQL 2000 Reporting Services. I have been given a task on installing SQL 2000 Reporting services on our servers. We have one database server (SQL 2000) with SP3a. We have one web server with IIS 5.1 and ASP.NET 1.1 installed.
I plan to install the Report Server database on the SQL 2K DB server; but I want to install the Report Server on the web server with IIS. Is that possible ? If yes can you please describe in detail how can I do it ?
The other question I am having is from where can I download SQL 2000 Reporting Services (DEV edition or ENT edition). Is this something available online ?
Please help, as this is very important for the project given to me.
is there a reporting services configuration tool for 2000 that comes with the non-trial version as the trial version did not install this tool - maybe it did not do so because i had the 2005 version already installed. ???
I would like to have an option of selecting the rows in my reports designed using reporting services 2000.
I would like to have a check box inside the table. when the user viewing the report he can select the rows using this checkbox and print only the selected table rows.
can anyone help how to implement this logic in ms reporting services 2000?
I'd like to display the first character of a string in a text field in Reporting Services 2000. First I check to see if the field is blank, if it is then do nothing. If the field is not blank, then display the first character.
