I've got a software development PC that was running SQL 2000 + Analysis Services + Reporting Service (sp4 from memory). I then installed SQL Express 2005 and later then SQL 2005 Standard (dev) + Analysis + Reporting and upgraded to Sp2 last month.
To help improve the performance of this poor little PC, I've gone to Control Panel and uninstalled SQL 2000 service. I've also used the SQL 2005 Surface area configuration tool to switch off the SQL Express instance from running. Practically, I probably should remove the $SQLExpress instance.
The problem I'm faced with is the SQL 2000 Analysis and SQL 2000 Reporting service is still registered as Windows Services and showing the the SQL Server Configuration Manager (2005), but there is no uninstall option in the control pannel. So I can't work out how to uninstall these software and services.
It is also apparent that there are a series of "files" in the C:Program FilesMicrosoft SQL Server80* directory like ..ToolsDevToolssamples*.* directory and others that shouldn't really be there if I've uninstalled SQL 2000 via the control panel.
Is there a SQL 2000 cleanup or removal tool that will help remove these old services and files?
Does anyone have some suggestions on how to cleanup my development PC without the full operating system installation?
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??
I have some questions about SQL Servers 2000 and 2005 compatibility. In my configuration I have to use both servers. The cubes are stocked in 2005 server. May I transfer from 2005 to 2000 Analysis Services the cubes?
If yes, what is the procedure? The result of migration is the same in the two different versions?
Tried to uninstall SQL Server 64-bit on Windows 2003 remotely. All components uninsntalled properly except Reporting Services.
The log file lists the following error -
/***** ReportingServicesService!library:: e ERROR: Throwing 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., ; Info: 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)
*******/
Now I cannot see Reporting Services under Add/Remove programs (ARPWrapper.exe /remove). It is also not displayed when using Windows Installer Cleanup Utility (msicuu2.exe). I can start the default instance of RS via Reporting Services Configuration manager and it can also be also started under Windows Services. BTW, the IIS folder structure is under the default website for Reports and ReportServer is present.
So, now how do I go about uninstalling SQL Reporting Services when I cannot see it (as an installed program) without rebuilding the machine ?
Tried to uninstall SQL Server 64-bit on Windows 2003 remotely. All components uninsntalled properly except Reporting Services.
The log file lists the following error -
/*****
ReportingServicesService!library:: e ERROR: Throwing 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., ; Info: 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)
*******/
Now I cannot see Reporting Services under Add/Remove programs (ARPWrapper.exe /remove). It is also not displayed when using Windows Installer Cleanup Utility (msicuu2.exe). I can start the default instance of RS via Reporting Services Configuration manager and it can also be also started under Windows Services. BTW, the IIS folder structure is under the default website for Reports and ReportServer is present.
So, now how do I go about uninstalling SQL Reporting Services when I cannot see it (as an installed program) without rebuilding the machine ?
I think I've seen a similar post on a blog or on the forums - but it seems like this should be possible -
I have an MDX query - that works fine in SQL Enterprise Manager, and has my dimension members on columns, and my measures on the rows. When I try the same query in Reporting Services, I get the error:
"The query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies, nor should it reference any dimension other than the Measures dimension.. Parameter name: mdx (MDXQueryGenerator)"
Although it works when you pivot the view, I really need my data presented with the members on the columns and the measures on the rows. Another forum post mentioned using the SQL 9.0 driver, but I can't see this listed anywhere (the only one I see is the .NET framework Data Provider for Microsoft Analysis Services).
Here's what my query looks like -
SELECT { [Time].[Month].&[2006-09-01T00:00:00] , [Time].[Month].&[2006-10-01T00:00:00], [Time].[Month].&[2006-11-01T00:00:00], [Time].[Month].&[2006-12-01T00:00:00] } on COLUMNS, { [Measures].[Unique Users], [Measures].[UU Pct 1], [Measures].[UU Pct 2], } ON ROWS FROM [Cube]
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?
Setup: Reporting Services and Analysis Services are on the same server. Active Directory User. Default configuration of Reporting Services.
Problem: Reporting Server does not apply Analysis Services Role after login.
Details:
I have created a report that retreives data from the Analysis Service. I created a role and added my user company/myUserName to the role.
On the Reporting Server I set the data source to :
* Credentials supplied by the user running the report and Use as Windows credentials when connecting to the data source
Internally when I connect devsql2005/Reports/ReportName I get the user and password fields. When I fill them in I get the report but I can see all the data while my role was restricted to see only few results.
Can anyone suggest what may be wrong? Any articles or tutorials on how to setup and deploy solutions where Report Server is talking to Analysis Services and NOT Sql Server.
Are both reporting and analysis services of SQL Server are same or different. I mean if I install reporting services so analysis services is a part of it or do I need to install it separately?
I am asking because when I tried to install Visual Studio Team Foundation Server 2005 it said that I do not have SQL Server 9 Analysis Services installed which is a prerequisite but I do remember that I have installed SQL Server reporting services on the system. So it means Analysis Services has to be installed separately from a different CD?
We're looking at several tools to do reporting and analysis of our SQL 2005 data.
We want to create canned web based reports We want internal - non-developers to create canned reports for our customers We want internal - non-developers to create ad hoc reports We want to slice and dice the data in various way and produce graphs and trend reports - pretty stuff for management
Tools like Business Objects Edge satisfy many of these requirements but we already have SQL 2005 which I understand can do similar things. I can easily get a demo of a companys products to show me what can and can't be done.
Does anyone know how I can get a SQL demo using these services ? I tried contacting Microsoft but didn't get anywhere
I don't have the luxury of time to learn all the benefits and functionality to understand if SQL is the best way to go. Database wise - yes - but Analysis and Reporting ??
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 Reporting Services on one server and SQL and Analysis Services on another Server. I can develop a report using Analysis Services as the source from my local machine and it works fine. When I deploy it to the Reporting Services Server, it gives the following error:
An error has occurred during report processing. Cannot create a connection to data source 'DataSource1'. A connection cannot be made. Ensure that the server is running. No connection could be made because the target machine actively refused it
Hello I have been working on reporting services fetching data out of Sql Server. I want to know,if there are any sites than have information on working with MS.Services and Analysis Services together. Analysis Services is something I have no knowledge about.
I have an important question and I've been roaming on MSDN and the internet to find a CLEAR answer. I'm really stuck here.
Is there a way to build a DYNAMIC Report with Visual Studio 2005 (SQL Server Business Intelligence Development Studio) and having a Cube (SQL Server 2005) as datasource?
I want a report that will act as the interface of the Cube browser in Analysis Services. I don't want to give access to the Cube Browser to users, but I want them to be able to drill-through the cube.
Hi, I'm trying to learn about analysis, integration and reporting services. I have install SQL server 2005 management Studio Express. but I cant find these in the Start menu as mentioned in the tutorial Click Start > SQL Server 2005 > Business Intelligence Development Studio.(for reporting services). what do I need to do? Please help me.
I have a cube with 20 dimensions. I have two dimensions with more than one million of members. When I process these dimensions Analysis Services 2000 create files with "axis" extension. What are these files? Why, when I start MSSQLServerOLAPService or when I process another cube in another OLAP database, these files sre updated?
I have a problem with Microsoft Analysis services, we already configure the boot.ini and the registry to use 3GB in RAM, but 2 or 3 times in a day we should restart the services to clean the memory, as you can see that€™s not acceptable. The application that use the OLAP is OutlookSoft . Here the scenery SO. Windows Server 2003 Enterprise Edition with SP 1 RAM 4 GB Analysis services 2000 with SP 4
Hi, I've created an SSIS package to process cubes on Analysis Services 2005. This works fine.
Now I wish to use the same package to run Cubes on Analysis 2000. I have changed My connection manager to point to this DB. When I test connection it works fine.
The problem lies, when I try to edit the Analysis Service Processing Task. I get an error message saying: "A connection cannot be made-Make sure the server is running".
I can get into Analysis Manager ok, and see the database there.
Hope someone can point me in the right direction here?
How do I connect to an Analysis Services 2000 cube while in Integration Services? My idea is to execute an MDX query from within a package, and then stage the data to a SS 2005 table for a RS report to query.
I've installed SSAS 2012 as a failover cluster instance on a 2-node Windows 2012 R2 cluster. Â All was fine in that regard but I now need to change the instance name so am going about the process of uninstalling and re-installing. Â I've successfully removed the second node from the configuration using the "Remove cluster node" wizard from the Setup options, but when it comes to removing it from the final node I'm getting the error "the cluster group **** could not be moved from node x to node 'null'". Â At this point the uninstall fails and the cluster resource remains in cluster administrator. Â It's obviously done some work/damage because the service won't start now, but it's left in limbo land where I can't do anything with it.
Is there a manual way of removing the instance to overcome this issue (file deletions, registry entry deletions etc.)?
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....
