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
ADVERTISEMENT
Mar 10, 2008
Hi All,
Probably a dumb question but our network guy has installed 64 bit Win2003 on one of the servers onto which I'm tasked with running our 32bit SQL Server 2005 server.
The installation goes through without a hitch and I'm able to get the SP2 installed over the top with no problem. I am, however, having trouble when trying to browse into the Reporting Services pages. I simply get a std "Page Not Found" web page. I've gone through the Report Server Configuration to see if I can get things to come up properly and everything appears to be initializing properly but still "no go"...
Can one of you MVP's give me a direction? I know it's relatively few details to get started but I'll provide whatever's necessary to get me pointed in the right direction.
Thanks
REM7600
"Jack of All Trades, Master of SQL (NOT)"
View 4 Replies
View Related
Mar 3, 2008
I have Report server and Report Tempdb database in SQL 2000. Is there anyone who has done. Please explain how to migrate Reporting Services from 2000 to 2005 in steps.
View 7 Replies
View Related
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
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
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
Jan 2, 2007
Hi, All:
We have to migrate several 64Bit SQL Servers to 32Bit platform. Due to the 64Bit source systems are all production system, the downtime is too limited. So we can only get the DB files via Detach way. Among the source systems, both SQL2000 and SQL2005 exist.
My question are:
Is it possible to migrate the DB from 64Bit to 32Bit via Detach/Attach?
If ok, how to do that?
Any info will be highly appreciated! Thanks!
Best Regards,
Kevin
View 1 Replies
View Related
Oct 9, 2006
Hi
I just started a new job and one of my first assignments was to determine and prove the improvement between SQL Server 2000 32 bit and SQL Server 2005 64bit extension. (Itanium may come later but for now we will live with x64)
I have used SQL 2005 before but only with a fresh install and a new application built from the ground up. Now we want to upgrade our present databases to 2k5. In a previous test by another DBA, he found the SQL 2005 ran slower. However, he realized that he was using SQL 2005 32bit on Windows 2003 64bit. Now we have everything in place, here are the steps I have accomplished so far.
Loaded Windows 2003 64 and SQL 2005 64.
Made a copy of an existing database from a SQL 2000 32 bit
Attached this database to the new SQL 2005 server. However, I keep the compatibility at 8.0.
Updated the statistics and backed the db up.
Had another DBA run a Profiler trace on the production server.
Replayed the trace on the new server.
My problem is this doesn€™t seem to give the information I am looking for. First, we were only looking at queries over 5 minutes and only looking at things from a duration standpoint. We are going to change this. Second, even though I created a template that looks like the one used on the production server, it is not using it.
So how do I compare performance on this 64bit server verses the 32bit SQL 2000. Any and all help is greatly appreciated.
View 4 Replies
View Related
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
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
Aug 3, 2006
How can I get the 2000 and 2005 versions of SQL Server Reporting Servicesboth 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 asinstance RMK006 in the MSSQL folder. I have the developer edition of SQLServer installed on my laptop as instance RMK0062005 in the MSSQL.1 folder.I have the corresponding versions of SQL Server Reporting Services installedon my laptop.I have the Reports web site and the Reports web site and ReportServer website configured to ASP.NET 1.1I have the Report$RMK0062005 web site and the ReportsServer$RMK0052006configured to ASP.NET 2.0Entering http://localhost/reports$rmk0062005 in my web browser works fine.Entering http://localhost/reportserver in my web browser generates thefollowing error:Reporting Services Error--------------------------------------------------------------------------------The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline HelpBad Data.--------------------------------------------------------------------------------Microsoft Reporting ServicesEntering http://localhost/Reports in my web browser generates the followingerror:The report server cannot decrypt the symmetric key used to access sensitiveor encrypted data in a report server database. You must either restore abackup key or delete all encrypted content and then restart the service.Check the documentation for more information. (rsReportServerDisabled) GetOnline Help Bad Data.The only way I can seem to get 2000 Reporting Services working is to do thefollowing:- 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 ServicesBut 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 Studio2005; the application is based on a SQL Server 2000 database and needs toinvoke 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 ISLOSING PATIENCE !!!!!
View 1 Replies
View Related
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
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
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
Jul 30, 2015
I have old sql server 2008 with reporting service and new one 2012 version and I need to move single report folder from old server to new server. Is there any tool or script can make that possible.
View 5 Replies
View Related
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
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
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
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
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
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
Jun 6, 2007
I just installed the 64bit Vista and than wanted to install the 64bit SQL 2005 Std. Server on it.
Note: I downloaded my license from https://licensing.microsoft.com/eLicense/L1033/ProductDetail.Asp?SKU=228-05338.
Installing from SQLSTDSEL.ISO file results in the warning that for the REPORT- Server the .NET version has to be 32bit.
Stopping the installation at this point and try to install from SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57664 + SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57665 does not give the above error but on the other hand installs no server at all since somehow the installation routine is not working at all.
Installing now - after at least analysis server and reports server are 64bit and installed - from the first mentioned ISO results in the installation of the DB- Server.... but as a 32bit installation.
Now I wonder what did not work out - so maybe someone here has an idea if and how this problem is solveable.
View 1 Replies
View Related
Mar 23, 2007
Hi,
I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found"
Does anyone have any ideas?
Thanks
View 5 Replies
View Related
Apr 14, 2015
I need to migrate Reports from a SQL Server 2008 R2 Server to SQL Server 2014 Reporting Services.
Reporting Services is installed on one Server and the Reporting Services is installed on another Server.
On the existing Server the Encryption was never backed up.
What do I do with the key?
The following article provides some good information but it does not identify what to do with the Destination URL.
It mentions to download the files but it does not specify how to identify the path and it does not state where to upload them.
Do you restore the existing Reporting Services Databases to the new Server?
[URL] .....
View 2 Replies
View Related
Mar 31, 2008
Hi,
I'm migrating SQl Server Reporting Services from 2000 to 2005.The reports are generated normally in 2000 but it seems that it is taking more time in 2005 or sometimes it does not generate the report at all.Could you kindly suggest a solution?
Thanks,
anne
View 1 Replies
View Related
Feb 25, 2008
I'm trying to install SQL Server 2005 on a server 2000 machine, everything is working with the exception of the Web Service Identity. It is putting machinenameASPNET, and I don't know where to go to make it use something else. I've look around but I have really seen any answers that have worked for me.
Thanks in advance
Will
View 3 Replies
View Related
Mar 31, 2008
We just built a new server with Windows 2003 64bit OS and installed SQL2005 64bit (named SQLServer let's say) as the default instance and SQL2000 32bit (named SQLServerSQL2000 let's say) as a second instance. The first instance is listening on the 1433 port and the second instance is on the 1344 port.
I can connect to the default instance with Management Studio without issue using the SQL instance name, but to connect to the second instance I have to create an alias with the port number (SQLServerSQL2000,1344) on my machine. I have never had to do that before with a second instance.
I am trying to figure out if this is an issue with 32bit SQL running on 64bit OS or what. I am kind of stumped.
Any information would be greatly appreciated! Thank you!!!
Jim Youmans
St. Louis, Missouri, USA
View 5 Replies
View Related
Jul 27, 2015
I work in a big project and we will begin in using reporting services as the base technique for reports and I will be responsible for this part. but I have a problem I will discuss in the following:
Currently: We use currently devexpress reports and we have 2 languages(Arabic and English). the data in tables saved in two ways (Arabic and English). when the end user change the language of the web site the report data language changed when run it.
Example:
we have table with (ID, NAME_AR, NAME_EN, JobTitle_AR, JobTitle_EN). designed report will display(ID, NAME_EN, JobTitle_EN) . but the end user change the language of the system the report will
dispaly(ID, NAME_AR, JobTitle_AR)Â
Hint:this done pragmatically
how to do this in reporting services.
View 7 Replies
View Related
May 28, 2004
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
Please help
View 3 Replies
View Related
Aug 23, 2007
Yes folks that's right, I said SQL 2000 RS.
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?
View 8 Replies
View Related
May 24, 2007
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....
Thanks
View 2 Replies
View Related
Apr 27, 2006
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.
Thanks so much - Joe
View 1 Replies
View Related
Aug 20, 2007
Could someone assist me in setting up Data Driven Subscriptions for Reporting Services 2000?
Thank you in advance.
Ken
View 1 Replies
View Related
