Reporting Services 2000 && 2005 On Same Machine

Aug 3, 2006

How can I get the 2000 and 2005 versions of SQL Server Reporting Services
both working on my development laptop ?????

I have ASP.NET 1.1 and 2.0 installed on my laptop.

I have Visual Studio 2003 and 2005 installed on my laptop.

I have my default website configured for ASP.NET 2.0.

I have the developer edition of SQL Server 2000 installed on my laptop as
instance RMK006 in the MSSQL folder. I have the developer edition of SQL
Server installed on my laptop as instance RMK0062005 in the MSSQL.1 folder.
I have the corresponding versions of SQL Server Reporting Services installed
on my laptop.

I have the Reports web site and the Reports web site and ReportServer web
site configured to ASP.NET 1.1

I have the Report$RMK0062005 web site and the ReportsServer$RMK0052006
configured to ASP.NET 2.0

Entering http://localhost/reports$rmk0062005 in my web browser works fine.

Entering http://localhost/reportserver in my web browser generates the
following error:
Reporting Services Error
--------------------------------------------------------------------------------

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 and then restart the service.
Check the documentation for more information. (rsReportServerDisabled) Get
Online Help
Bad Data.

--------------------------------------------------------------------------------
Microsoft Reporting Services

Entering http://localhost/Reports in my web browser generates the following
error:

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 and then restart the service.
Check the documentation for more information. (rsReportServerDisabled) Get
Online Help Bad Data.

The only way I can seem to get 2000 Reporting Services working is to do the
following:

- run C:WINDOWSMicrosoft.NETFrameworkv2.0.50727aspn et_regiis.exe -u
- uninstall 2000 Reporting Services
- run C:WINDOWSMicrosoft.NETFrameworkv1.1.4322aspne t_regiis.exe -i
- install 2000 Reporting Services

But once I've done that Visual Studio 2005 etc no longer work.

The utlimate goal is an ASP.NET 2.0 application developed in Visual Studio
2005; the application is based on a SQL Server 2000 database and needs to
invoke SQL Server 2000 Reporting Services to run reports.

What am I doing wrong?

ANY HELP WOULD BE GREATLY APPRECIATED - I'M DIEING HERE AND MY CLIENT IS
LOSING PATIENCE !!!!!

View 1 Replies


ADVERTISEMENT

Can We Install Reporting Services 2005 In A Machine In Which Is Not Installed SQL Server 2005

Nov 19, 2007

Hi,


Can we install reporting services 2005 in a machine in which is not installed SQL server 2005.?

Thanks

View 3 Replies View Related

Migrate From 32bit 2000 Reporting Services To 2005 64bit Reporting Services

Mar 22, 2008



Hello,

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?

Any help is appreciated

View 1 Replies View Related

Installing Full Version Of 2005 Server On A Machine That Already Has Reporting Services On It

Jan 7, 2008

Hi there,

I'm trying to install the common components for SQL 2005 on a server that already has Reporting Services 2005 installed on it. It keeps comng up with an error:
"To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter."

The Reporting Services install has had SP2 applied to it, would that be what is messing up the install?

I have very little experience with SQL so any info would be helpful.

Thanks!

View 4 Replies View Related

Analysis Services 2000 + Reporting Services 2005 + Parameters

Sep 16, 2007



Hi All,

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?

Regards,
Joseph

View 1 Replies View Related

Reporting Services 2005 And Analysis Services 2000

Jul 30, 2007



Hello,



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??

thank you
regards
Andreas

View 3 Replies View Related

Select Data From 2000 Machine From A 2005 Machine

Jan 17, 2008

Hi,

here goes the question:

i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)

how do i build a query to select data from 2k machine in a query of 2k5?

i mean something like

select *
from login:passw@machineb.dabatase.dbo.customers

thanks!

View 2 Replies View Related

Select Data From 2000 Machine From A 2005 Machine

Jan 17, 2008



Hi,

here goes the question:

i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)

how do i build a query to select data from 2k machine in a query of 2k5?

i mean something like

select *
from loginassw@machineb.dabatase.dbo.customers

thanks!

View 6 Replies View Related

To Access Reporting Sevices (Report Manager, Reporting Web Services), Does One Has To Be An Admin On The Machine

Mar 12, 2007

Hi There,

Our DBA has installed reporting services on a server and now in order to access the report manager, one has to be an Admin on that Server. I am guessing that there is a mistake in the configuration of Reporting Services. Usually it should allow anybody who was added to the roles in the properties section of the Report Manager, right? I have also added the users to the DB..

Also I am using Windows Authentication to access Report Catalog items (Reporting Services is installed on Server2) from a web Application(deployed on Server1) and displaying the report using report viewer. For some reason, server1 has to be in an Admin role on Server2 to access the report catalog/report. This is kinda strange for me as I don't want everybody to be an Admin on Server2. Can anybody please point in the right direction?

Thanks.

View 3 Replies View Related

Sql Reporting Services 2000 Using VS.NET 2005

Feb 27, 2007



Hi



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

kinds regards

sy

View 1 Replies View Related

2000/2005 Reporting Services

Jul 9, 2007

i have now ordered my sql server 2000 reporting services non-evaluated edition. My new question involves installing it after i installed 2005 edition.

It seems that as long as i have a web home for my report projects

(2005), the server can hold output from the 2000 and 2005 versions.

But i'm wondering if i delete my 2005 version, and just have the 2000

version - will the web home for the 2000 version look the same

and it seems at least on the 2000 trial version level, there is no configuration options menus that really make it easy to establish a web

home server. ????



Please get back to me on clalbert@flash.net



Charles Albert

thanks





View 1 Replies View Related

Reporting Services 2005 With SQL 2000 Database

Sep 14, 2007

Hi friends, i have some questions about Reporting Services 2005:



Can i use RS 2005 with a SQL 2000 Database?
Can i create a report with RS 2005 (with a SQL 2K Database) a show it in a webform?
What do i need to install (in the webserver and in the Database server) in order to start designing reports in RS 2005 against a SQL 2K DB?Thanks in advance.
Regards
Eduardo

View 3 Replies View Related

Reporting Services 2000 / 2005 Parameters

May 29, 2007

Hi all,



Is there any way to pass a dataset parameter in RS 2000? Basicly, I have some data in my web page and want to print it. But I don't want to create another page to pass parameters to RS. I want to print the page as it is with the data already in the page, so if there is a way I can send the data through a dataset to the report directly, would be great. Is there?



Thank you very much,



Marco

View 6 Replies View Related

Migrating SQL 2000 Reporting Services To 2005

Mar 17, 2008



I am little bit scared that if i upgrade reporting server db to 2005, My report won't work. I just wanna test with some reports in SQL 2005 reporting services.

1) what should i do( I have already installed Reporting services in 2005 (64-bit)?
2) Can i backup Report server db and Report Tempdb database and restore in SQL 2005 but these database already exists in SQL 2005.?
3) If i upgrade these database , Will it effect my 2000 Production Reports?

4) i donno what to do

Please help SQL reporting experts.

View 2 Replies View Related

SQL Reporting Services 2005 And Sql Server 2000 Database

Nov 6, 2007

Hello,
We want the reporting tool to be integrated with visual studio 2005. From my understanding SQL reporting services 2000 can be integrated only with visual studio 2003 (Please correct me if I am wrong) . Hence we have decided to go for SQL reporting services 2005
I understand that SQL reporting services 2005 can be used with SQL server 2000 database. I want to know if SQL reporting services 2005 and SQL server 2000 database are on a single machine, would a single license for SQL server 2000 suffice or should we have a license for sql server 2005 (since we use SQL reporting services 2005) as well.

Many thanks in advance,
Vaneeth

View 1 Replies View Related

Reporting Services 2005 On Windows 2000 Server

Mar 19, 2007

Hi,

I successfully got SQL 2005 Express with reporting services running under VISTA. Developed some reports in the VISTA environment. However, my target system is a Windows 2000 server. We installed SQL 2005 w/reporting services onto the Windows 2000 server. SQL2005 Database is up and running. Reporting Services are running, IIS RRS virtual directories are built, RRS databases are built. I can do everything except deploy reports from Business Intelligent Studio. I can preview reports, just cannot deploy. The Reporting Services indicate 1 failure in its configuration; the Web Service Identity. It is loaded with <server>ASPNET. I cannot get rid of this error. I assume this is the problem. After digging around I found that Windows 2000 does not have an ASPNET user, it uses the IWAM user instead. Reporting services did not run at all till I changed the rs config file and put the IWAM user in as <WebServiceAccount>.

Does anyone have Reporting services 2005 running on Windows 2000 server? Anyone know how to fix the Web Service Identity error I am getting?

Thanks

View 8 Replies View Related

Can I Use SQL 2005 Reporting Services With SQL 2000 Server, SQL Express Or MSDE?

Feb 19, 2008

Hi, I'm wondering if I can use SQL 2005 Reporting Services with SQL Server 2000, SQL Express or MSDE, or I need to install SQL Server 2005 in order to use Reporting Services 2005? Thank you in advance.

Regards,
Miguel

View 1 Replies View Related

Reporting Services 2000 With SQL Server 2005 Data Sources

Jul 23, 2007

All,



I apologize for not doing the legwork to see if i can answer my own question, but I am close to a loosely planned SQL 2005 migration and don't have time and resources to test my own theories.



Is there a way for a Reporting Services 2000 server to connect to SQL server 2005 databases? I've tried creating a new data source and changing a report to this data source, but it seems like the report is still using the old data source. I'm guessing i might need to register new data providers on the 2000 RS server and then change the existsing data sources.



Ideas?



Thx in advance,



-Peter

View 3 Replies View Related

SQL Reporting Services 2005: Querying A SQL Server 2000 Database

Feb 5, 2008



Is there any way to deploy reports to a Report Manager in SQL Server Reporting Services 2005 if the reports query SQL Server 2000 databases? Or are only 2005 databases able to deploy to the web?

Also, if I have a report that queries both, can I deploy it to the web on the 2005 Report Manager with a linked server to the 2000 server?

View 4 Replies View Related

SQL Server 2005 Running In 2000 Compatibility Mode And Reporting Services

Sep 17, 2007

Can you run SQL Server 2005 in SQL Server 2000 compatibility mode and still use it with Reporting Services 2005?

View 4 Replies View Related

How Could I Know The Version Of Reporting Services In My Machine?

Aug 15, 2007

How could I know the version of Reporting Services in my machine?

thanks

View 1 Replies View Related

Unable To Start Reporting Services On Local Machine

Apr 6, 2008

I am new to SQL Server 2005 Reporting Services and I€™m having problems starting the service. I am running a Windows XP SP2 with SQL Server 2005 and reporting services but the service will not start. My SQL Server instance logs on using €˜Windows Authentication€™ using a username sysadm with no password

I have installed IIS and made sure that ASP.net is running.

I have opened up the Report Services Configuration Manager and amended the settings but I€™m unable to get the service started!!!

Theses are my settings

i) Report Server Virtual Directory OK
Name: ReportServer1
Website: Default Web Site

ii) Report Manager Virtual Directory
Name: Reports1
Website: Default Web Site

iii) Windows Service Identity
Service name: ReportServer
Service Account: NT AuthorityLocal Service

Iv Web Service Identity (NOT WORKING)


v) Database Setup
Servername €“ Nameofmyserver
Database name - ReportServer1
Credential Type Server Credentials


When I click on start no error message appears, it just seems to time out.

View 5 Replies View Related

Reporting Services :: Why SSRS Is Looking For Using Machine Configuration File

Aug 6, 2014

I am using BIDS 2012.I am getting this error: Unable to load assembly U2.

Data.Client, Version=2.1.0.0, Culture=neutral , PublicKeyToken=9ab9148678f4f448, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. 
---> System.IO.FileNotFoundException: Could not load file or assembly 'U2.Data.Client, Version=2.1.0.0, Culture=neutral, PublicKeyToken=9ab9148678f4f448' or one of its dependencies. The system cannot find the file specified.

[code]....

I am expecting
C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config

how can I force SSRS to use "C:WindowsMicrosoft.NETFramework64v4.0.30319configmachine.config".

View 5 Replies View Related

Problems With SQL 2000 And 2005 On Same Machine - Can't Connect On 2000

Mar 13, 2006

Hi,i have SQL 2000 and 2005 on same machine(with different intance names,of course), my laptop - XP with SP2. The 2005 works fine but i can'tconnect on SQL 2000. All the the SQL services are started.Any idea? Have i to reinstall 2000?Tks,Lourival

View 1 Replies View Related

Reporting Services Configuration Fails In Windows 2003 SP2 ,64-bit Machine

May 14, 2008



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,

any inputs on this issue , i would welcome them,

View 2 Replies View Related

Compatibility Of SQL Express Reporting Services With SQL 2000 Reporting Services

Dec 6, 2006

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.

Thanks to anyone who can help.

-- Mark

View 1 Replies View Related

Error:no Report Server Found On The Specified Machine While Setting Up Reporting Services Configuraion Manager

Feb 19, 2007

Hello,

I have installed sql server 2005 along with reporting services... though i am able to design report using business intelligence studio... i am unable to access the report server.... while trying to start the reporting services configuration manager it says no report server found on the specified machine...Invalid Namespace... the installation is local ...

Due to this problem inspite of designing the entire report i am unable to deploy it on the web..since it is asking for a report server...

Can somebody please help me on this...

Thanks in advance...

Nirupa

View 8 Replies View Related

SQL 2000 And SQL 2005 Both In The Same Machine

Nov 15, 2007

Hi i am new using SQL 2005, i have SQL 2000 Personal Edition SP4 with 2 databases for testing installed in the default instance and i would like to install SQL 2005 standart Edition (i have Windows XP pro sp2) . can i have the same instance for both SQL database engine?. or to create a new instance for the 2005?. what i need is to test SQL 2005 while i keep my database for test in SQL 2000. I was trying to install by typing a named instance, and it gave me an errors. then i try again by choosing the default instance and then it start an upgrade operation and affter a sucess upgrade now i cannot see the sql management studio and neder Enterprice Manager for SQL 2000. i am confuse, some ideas for this issue?

View 5 Replies View Related

SQL 2000 And SQL 2005 On Same Machine?

Aug 9, 2006

Can you have a SQL 2000 and 2005 running on the same machine? Can you direct me to resources regarding this?

View 4 Replies View Related

SQL Sever 2000 And 2005 On Same Machine

Nov 21, 2006

Hi, I am trying to create a connection string that will connect to a SQL Server 2005 Registration on a remote machine.  I have a SQL Server 2000 registration (installed) on the same machine and so I think there may be a conflict.  The SQL 2005 registration is denoted as HARDYSQL5 and the 2000 registration is merely HARDY (the machine name).  I need to connect to a database on the HARDYSQL5 registration but I am not connecting.  I have tried various connection strings but none have worked.  I get a Login failure.  I think this is red herring because I doubt its even finding the database.I can connect to the 2000 db with:"Server=HARDY;Database=Perimeter;UID=use;pwd=example;" But its fails with the following, for example:"Server=HARDYSQL5;Database=Perimeter;UID=use;pwd=example;" "Server=HARDYSQL5;Database=HARDYSQL5Perimeter;UID=use;pwd=example;" "Server=HARDY;Database=SQL5Perimeter;UID=use;pwd=example;"  I'm gon go nuts.  What am I doing wrong? Thanks. 

View 10 Replies View Related

SQL 2005 Express && SQL 2000 On Same Machine?

Dec 31, 2005

Hi all,
I'm about to download the VWD ASP.NET 2.0 with SQL Express 2005, but i currently have Visual studio.net 1.1 and SQL Server 2000 installed on my PC, XP Pro.
Has anyone had problems with this or are they happy to run along side one another without over writing projects already created in the older versions?
Thanks in advance.
Allen

View 3 Replies View Related

SQL Server 2000 And 2005 On One Machine?

Jul 17, 2006

Hi,

i have SQL Server 2000 running on my notebook for learning purposes. Is it possible to run SQL Server 2005 on the same notebook without using virtual machines?

Thank you,

Tobias

View 11 Replies View Related

RS On Sql Server 2000 And 2005 On Same Machine

Oct 18, 2006

Hi Samuel,

I'd like to draw on your expertise on this topic. I've been browsing at many blogs/forums about installing SQL Server 2000 and 2005 on the same machine.

What I'd like to know is how does that work with Reporting Services? Your machine's IIS will need to work with Reporting Services 2000 and Reporting Services 2005. The RS 2005 requires .NET Framework 2.0 and RS 2000 requires .NET Framework 1.1. IIS can only support 1 version of the .NET Framework at a time.

Thanks kindly.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved