what I was doing: Try to migrate thessrs 2005 sp2 in a old web serverto SSRS 2014 in a new server (native mode)
1. old SSRS web server: SSRS 2005 SP2 enterprise edition with window server 2003 (server 1)
2. New SSRS web server: window server 2012 R2, installed sql server 2014 database engine and SSRS. (server 2)
3. backup configuration files, encryption key, we have no custom assamblies from the old SSRS web Server (server 1)
4. Backupthe report server databases from the existing olddatabaseserver. (server 3) (our SSRS web server and SSRS report server databases are in different servers)
5. Created the RSExecRole and grantd all the permissions according to the documentation in the sql server 2014 database server (server 4)
6. Restore the databases to thenew database server that is in sql server 2014. (server 4)
7. Go to server 2 to configure the reporting service using the configuration Manager
I successfully pointed to new databases, but when test the url, I got the error: The version of the report server database is either in a format that is not valid or it can not be read. The found version is '143' and the expected version
is '162'
I worked with Microsoft technician, and he said I have to upgrade my old SSRS from 2005 SP2 to 2005 SP4 first then do the migration. But I saw some article saying that I can migrate the SSRS from 2005 SP2 to SSRS 2014. Any help is
very much appreciated.

Hi Uri,
Thank you for your input. I do not understand how you move the old reports (.rdl) and open it in the new SSDT. I restored the databases to a SQL Server 2008 R2 environment andrestored the encryption key using the configuration tool, and
the reports look good in the new SSRS 2014 server. The only thing left is that we need to upgrade the report server databases from sql server 2008 R2 to Sql server 2014.
Li-hui Chen

How do I upgrade Sql Server 2005 Express to SP2 if I also have SQL Server 2005 Enterprise SP2 already on the same box?  I installed Sql Server 2005 Enterprise first, then applied SP2, then installed Visual Studio 2008 (which installed SQL Server 2005 Express).
 
When I try to upgrade Sql Server 2005 Express to SP2 using the special Express edition of SP2, I get an error message that says None of the selected features can be installed.  I end up having to cancel the install of SP2.
 
I'm left with SQL Server 2005 at level 9.0.3054  and SQL Server 2005 Express at 9.0.3042.  How can I bring SQL Server Express 2005 to the same level as SQL Server 2005 Entperprise?

Vidhya is right.  You are on SP2 already. 
 
Separately, the issue with the failed install is that the default instance is most likely the Enterprise Edition instance.  When upgrading via the GUI, the setup looks at the default instance only to determine whether changes are needed.  Try running your upgrade from the command-line utility instead, and specify the /instancename parameter (I think it's SQLEXPRESS).
 
Good Luck!
Diane.
 

when insatalling SQL Server 2005 Express Edition with Advanced Services SP2,the error messagecab file cannot  open or corrupted,cannot read fron DVD/CD.when ignore that  message installation exit.but,i try to install again.setup installed successfully .but  sqlserevr cannot be connected.thanks in advance.

You don't need admin account to install SQL Server in XP and your original error is related to bad CD/DVD that is the reason I asked you to download and install.  So use XP system restore to roll the operating system back to a date before your first install and download a fresh file and run setup from the fresh download.  Hope this helps.
 

Hi,I am having SQL server 2005 reports(rdl files). I need to make some modifications in these report using SQL server 2008.How can i convert all SSRS 2005 file to SSRS 2008 file and make modification?Thanks.sk

HI,I hope these links might helpfulUpgrading Reportshttp://technet.microsoft.com/en-us/library/ms143674.aspx
Reporting Services Backward Compatibilityhttp://technet.microsoft.com/en-us/library/ms143251.aspxRajesh Jonnalagadda
http://www.ggktech.com

 
Hi,
I am using Visual Studio 2005 for SQL Server Reporting Services Development.  Last week I applied the latest Microsoft updates.  I am currently at Microsoft Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) and Microsoft .NET Framework Version 2.0.50727 SP2.  After applying the updates I am getting an error in VS 2005.  When I open a SSRS project, right click on a report and select View Designer, I receive the error Deserialization failed: Could not load type 'Microsoft.VisualStudio.Shell.IOleMenuCommand' from assembly 'Microsoft.VisualStudio.Shell.Interop.8.0, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. Line 2, position 2..  Please let me know if you have a solution for this.  I already tried uninstalling and reinstalling VS 2005 twice.
Joe

I'm having the same problem.  Hope they found a solution by now.  Anybody know?  Thx.

I have granted this user and the group to which he belongs to content manager role membership and even then I get this error on SQL 2012 SSRS.
I have checked the UAC issue and the local admin run for IE as well.
Has the security changed form SSRs 2005 to SSRs 2012 ?

SQLCHANTer

Hi SQLCHANTER,
The operationsare a little different to grantuser access to a report serverbetween SSRS 2005 and SSRS 2012.Have you assigned the System-level permission (System Administrator or System User role) to the user in the report manager?
If not, it should be the cause.
Besides, when you set the Item-level permissions (Content Manager, Browser, etc.) to the user, make sure to assign the role on the Home folder (i.e. click “Folder Settings” button on the Home page) rather than a specific folder.

Reference:
http://msdn.microsoft.com/en-us/library/ms156034.aspx
Regards,
Mike Yin
If you have any feedback on our support, please click
hereMike Yin
TechNet Community Support

Post Author: ErikCA Forum: DeploymentIs SQL Server 2005 SP2 supported as the CMS (Central Management Server) database for Crystal Reports Server XI R2?I'm getting ready to deploy Crystal Reports Server XI R2 and I was very suprised to find that the documentation only lists SQL Server 2000 or MSDE 2000 as supported (MS SQL Server) database platforms for the CRSXI R2 CMS database. Is that true? Is the documentation outdated? It is currently October, 2007 and CRSXI R2 will not support SQL Server 2005? SQL Server 2008 is due out in a few months now (Q1 2008), but CRSXI R2 only supports the 7yr old version of SQL Server? That would seem odd to me, so I'm asking for clarification.Is anyone currently using CRSXI R2 with SQL Server 2005 as the CMS database?Furthermore, if anyone has additional insight, I'm considering deploying CRSXI R2 on a Windows Server 2003 server with MS SQL Server 2005 SP2 which is also running SQL Server Reporting Services (SSRS). (Should provide for an interesting comparison of product features...SSRS 2005 Vs. CRSXI R2). But another question that comes to mind...will CRSXI R2 play nicely with SQL Server 2005 SP2 running SSRS 2005 all on the same server?SUMMARY OF QUESTIONS:1) Can CRSXI R2 use SQL Server 2005 SP2 as it's CMS database?2) Will CRSXI R2 run nicely on the same server that is also running SQL Server 2005 SP2 with SQL Server Reporting Services (SSRS)?Thank you, in advance, for your reply!Erik

Post Author: ErikCA Forum: DeploymentWell, I never received a response in the forum (obviously). This forum doesn't seem to be reviewed by Business Objects, and thus has questionable value. But I'll endeavor to help you. So the answer I found and am experiencing is that CRSXI R2 does work on MS SQL Server 2005 SP2, and Business Objects does support it. It sounded like CRSXI R2 should also work on MS SQL 2005 or with SQL 2005 SP1 also. As I recall it seemed there were some passing comments from BO support that there were issues with CRSXI R1 and SQL 2005, but they were just passing comments and I did not get into it because it was not my scenario. If I'm not mistaken, I believe the upgrade from CRSXI R1 to R2 is free. Just download and install R2. There may have even been a Service Pack for CRSXI that I saw on the BO website...(?) But our CRSXI came with R2 and the Service Pack was already there. I did have trouble with viewing rights, but that was corrected after applying their CRSXI Fix Pack 2 and 3. (I think Fix Pack 2 alone would have fixed it, but I put them both on as 3 was the newest at the time.) So the gist of the problem was that their documentation was outdated. They emailed me a new PDF documentation file (dated Apr-25-2006 10:26 AM), but it doesn't appear that I can attach it here to this post. I called up BO and requested current documentation. Maybe their website is updated now, but the documentation I found on their website at the time was also outdated. Ok, I Googled it and found a link to the PDF file they sent me. Try this.http://support.businessobjects.com/communitycs/technicalpapers/crs_xi_r2_supported_platforms_windows.pdfor tryhttp://www.google.com/search?hl=enq=crs_xi_r2_supported_platforms_windows.pdfIn their current documentation it does state that it supports SQL Server 2005. For me, one other notable item was that they also discontinued support of older Oracle drivers for older versions of Oracle. However, on a different support call one of the BO Techs told me that the newer Oracle Drivers are backwards compatible with older Oracle databases and with the newer Oracle Driver installed on the server and client, then CRSXI R2 can still use a native Oracle driver for connectivity.So you should be able to run CRSXI R2 with SQL Server 2005 and BO does obviously support it. (I've called quite a few times myself...works better than this forum, I guess.)I will mention that I have experienced a report timeout issue, which required changes to registry and IIS settings...(BO Support helped with it).Also noticed that the ActiveX Print control (one-click printing) is an issue in that non-admin users cannot install and thus cannot use this feature without an admin installing it first (which is not viable in larger scenarios). Their writing up a knowledge base article on how to deploy their Print Control now. If it is helpful for you, we used IIS instead of the Java Application Server, (we did not install the Tomcat server), and we're using Active Directory (single sign-on) authentication.I think you can download the CRSXI R2 from here.http://www.businessobjects.com/products/reporting/crystalreports/server/upgrade.aspFix Packs from here.http://support.businessobjects.com/downloads/critical_hot_fixes/default.aspHope that helps!-Erik

I have a sql query in the VB Query Editor for a report (SsRS 2005) and the sql query is about 700 lines long... the sql works in sql management studio but fails in VS 2005 with this error: I get this error hanging application devenv.exe, version 8.0.50727.42 when This is when I try to create a report with this query.

How long in seconds does the query take? If it's very long you may need to increase script timeouts for IIS since it's rs2005 and uses a website, this may bubble back as an error in the ide, not sure on that but it's worth checking.Also, the number of lines isn't as important as the details of the query and how optimized it is ... sorting out the subqueries to not slow down the main flow is a typical problem.

Hi All,
 
I was trying to install analysis service on SQL Server 2005 SP2 hosted on Windows 2003 server SP2 and I get the version mismatch error.
 
Any help is greatly appreciated.
 
Thanks,
Prudhvi

Hi All,
 
I was trying to install analysis service on SQL Server 2005 SP2 hosted on Windows 2003 server SP2 and I get the version mismatch error.
 
Any help is greatly appreciated.
 
Thanks,
Prudhvi

 
hola buen dia a todos!
 
Tengo instalado WIndows Server 2003 con SP2 e instale SQL Server 2005 Workgroup Edition, al momento de crear Bases de Datos, Restaurarlas de manera visual no tengo problemas! pero cuando me decidi a instalar el SP2 en SQL y dejo de funcionar de maner visual porque mediante sisntaxis SQL si puedo hacerlo, de forma visual solo me mandaba los siguientes errores:
 
Error de create para base de datos nombre base de datos (microsoft.sqlserver.smo)
error de collate
 
Mi pregunta es ¿Tienen problemas de compatibilidad Windows Server 2003 SP2 con SQL Server 2005 ya sea con SP1 o SP2?
 
NOTA: Hago enfasis en esto ya que al momento de descargar ya sea el SP1 o SP2 para SQL Server 2005 mencionan que unos de los sistemas operatvios compatibles con ambos es WIndows Server 2003 pero con SP1.

Como te decía, pregunta también el foro de SQL Server.

I have a 2008 R2 SP2 SQL Server, and want to add SSRS to it. I have the full R2 ISO (4gb), and the SP2 service pack (360kb).

If I install SSRS, do I need to reapply R2 SP2 to SQL Server afterwards ? Or is there a download that contains SSRS R2 SP2 all in one ?

Hi Andrew,
In this scenario, we need to add the Reporting Services service to the existing SQL Server 2008 R2 SP2 instance from the ISO image first, and then apply the Service Pack 2 for SQL Server 2008 R2. For the services and features that have been updated to SP2
already, they will be ignored during the SP2 installation. We can see that from the Select Features page of the SQL Server 2008 R2 SP2 installation.

Regards,
Mike Yin
If you have any feedback on our support, please click
hereMike Yin
TechNet Community Support

Hello,
I have two machines X and Y. X and Y both have SQL2005, SP2. X currently has a ReportServer database (and temp database), with an encryption key, and many SSRS reports that run great. The target data source is a different SQL server
machine.
We want to retire machine X. I have performed the following steps to move the SSRS instance from X to Y:
1. Backup the ReportServer database from the source machine, X.
2. Restore that database to the destination machine, Y.
3. Backup the SSRS Encryption Key from the source machine Xvia the Configure Report Server console.
4. Restore that same exported key (copied to the new machine from the old machine) via the Configure Report Server console on the new server, Y.
The error shown below occurs on step 4, when I try to restore the key. I assure you I am pointing to the correct exported file and am entering the correct recovery password.
Error received:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The feature: Scale-out deployment is not supported in this edition of Reporting Services. (rsOperationNotSupported)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.BackupEncryptionKey(Byte[] encryptedBytes, String password)
I have attempted first removing all existing encryption keys on server Y (via console and via the RSKeyMgmt.exe -r command). The keys remove just fine. Even after removing all keys and performing step 4 restore key file from X to Y, I still
get the error. What is interesting is that even though I get the error, using the RSKeyMgmt.exe -l option shows the key has been applied; but though applied, it is not usable.
I've Googled for a while and am not seeing a similar scenario/solution. Thanks for any help.
Larry

Larry,
Due to the uncertainty and randomness factors which lead to the issue you faced, it requires higher level troubleshooting methods which need you to contact Microsoft Customer Support
Services (CSS) for more professional and dedicated assistance. However contacting phone support will be a charged call, but it will be free if this is a product issue. To obtain the phone numbers for specific technology request please take a look at the web
site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
Thanks,
Bill LuBill Lu
TechNet Community Support

Hello,I am having all sorts of issues installing SSRS 2005 add-in for SharePoint on Windows 2008 server. Details are as following:Server 1 (Win 2008 Standard SP2): MOSS 2007 SP2 (64-bit) + SSRS 2005 component of SQL ServerServer 2 (Win 2008 Standard SP2): SQL Server 2005 SP2 Standard (64-bit) + MOSS 2007 SP2 WFE. The server is successfully joined to the farm (shows in CA).When I install the add-in on the MOSS server, it rolls back. The logs say SSRSCustomActionError: SharePoint is installed, but not configured.. After digging in the forums and Microsoft documentation, I was able to install the add-in (9.00.3294 build) using command lines msiexec /i SharePointRS_x64.msi SKIPCA=1 and rscustomaction.exe /i. However, if I were to go to the SSRS Configuration Tool, it errored out upon start up with a ReportServicesConfigUI.WMIProvider.WMIProviderException: A WMI error has occured.... I uninstalled the add-in andtried other later add-in builds, but they all rolled back during the installation. I am installing the add-in using farm admin account, I made sure that reporting services service is started.Please help,

Hi all,
i am revisiting the problem asi still am not able to resolve it yet.
please anyone confirm one thing first
i have 2 web front ends and a database server. reporting services is configred on this database server in sharepoint integrated mode.
the reporting services add in : is it required to be installed on BOTH front ends, starting from the one which is hosting the central administration?
this link http://technet.microsoft.com/en-us/library/aa905871.aspx
suggests that i should run complete setup on one of the web front ends, and a FILE MODE installation (from command line) from other web front ends (skipping the customactions.exe)
the link is now modified with sharepoint 2010.
if anyone has integrated reporting services with MOSS 2007 in a farm environment, please confirm me on which servers exactly is the reporting server 2008 add in is required to be installed and which order.Adnan Shamim

Werecently installedSQL Server 2005 Developer Edition with SP3 on Windows Server 2008 standard Edition with SP2. Our Application is developed in .Net ,we are using SQL Server 2005 as Database and SSRS 2005 as Reporting Services. When we are printing a report from applicationwhich has barcode, the barcode is not printing properly. We tried exporting it to PDF file and HTML file. The HTML file shows the barcode and prints correctly. But the PDF file does not have barcode. Note: It shows barcode in Print preview but its not printing on paper.The barcode we are using is Code3of9. Windows Server 2003 with SQL Server 2005 this report prints barcode.When I searched for this issue, i found the following related issue:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/7fa4a7eb-8fc7-4fc9-a825-c7490507d3e5
Can some one please suggest me any solution.

Hi,

It seems you create the report with ReportViewer. Could you check the below threads to see if it helps?
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0c1993e3-77ff-4088-92f3-da1ea9ebf59f/
http://social.msdn.microsoft.com/Forums/en/vsreportcontrols/thread/e96ecf32-1cd2-48a9-97ea-c9d18b5504b0

Regards,
Raymond

Hi,
Is there a way to hide the SSRS Select All in the multi value dropdown?
only need to select one or more values not all values.
Thanks in advanced.

This is by design.When a parameter is set to allow muti select, the select all option appear on top as well. I am afraid that this behaviour cannot be changed with settings.
However if you would like submit a feedback to Microsoft Connect requesting this feature, you can do so at this link
https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software
and services the best that they can be, and you can learn about and contribute to exciting projects.Please click Mark as Answer if this resolves your problem or Vote as Helpful if you find it helpful.
BH

My question is what the steps do I need to take to upgrade SSRS from 2005 SP2 to SP4. The web server that host the SSRS is in 2005 SP2, and the OS is in window 2003.

Our SSRS report server and report server database are in different servers. The SSRS in the web server is in 2005 SP2 enterprise edition, the report server database is in sql server 2005 SP4 enterprise edition.
To upgrade the SSRS in web server from 2005 sp2 to sp4, do I need to backup/restore the encryption key? Nothing will be changed in thereport server database. Wewill still pointing to the same database inthe current server, all
I wanted to do is performing a inplace upgrade of SSRS from 2005 SP2 to SP4.

Any response will be greate appreciated. Thank you!

Li-hui Chen

Hi Lihui Chen,
According to your description, you want to install the Services Pack 4 for SQL Server. Right?
In SQL Server, Services Packs are used for fixing issues ofcurrent versionproduct. It's not an Upgrade, you don't have to backup/restore your encryption key. You just need to download the Service Pack 4 on:

Microsoft SQL Server 2005 Service Pack 4 RTM . Please make sure you have administrative rights on the computer to install SQL Server 2005 SP4. For more information, see links below:
How to obtain the latest service pack for SQL Server 2005
List of the issues that are fixed in SQL Server 2005 Service Pack 4
SQL Server 2005 SP4, KBA 2463332, Installation Issues
If you have any question, please feel free to ask.
Best Regards,
Simon Hou

Hi I have installed SQL 2005 without SSRS and updated to SP3. How do I add SSRS to installation?

Hi Alma,
Yes. It can be installed. But it is recommended that updating to SP3 after you adding the new feature.
Thanks,
Jin ChenJin Chen - MSFT

Hi,

We are using the dundas with SQL server 2005 reporting services and the application is developed in asp.net 2.0

Now We have to migrate from SQL server 2005 to SQL Server 2008. We have PUSH SQL Server 2005 SSRS reports in SSRS 2008 successfully.
But we facing problem for report which has Dundas Chart[2005] with subreport, in that case subreport is not loading
on report. Dundas chart is loading properly.

Can anybody please help out for same.

Thanks in advance...

Hi,
We have solved above problem by replacing ReportViewr 8.0 dll with ReportViewer 9.0 dll.
Thanks,
MohammedZaki

I have createds the following report:- Using Ole conection to OLAP DB.- Use a Matrix to display the data. - 3 levels heirarchy on the rows, with Drill Down enabledI show the following measure x/y on all levels.The problem:When drilling down to lower level, I got the numbers of the parent duplicated to the child level, instead of the data for the children.I have two SQL 2005 environment, one of them doesnt have the SP2.The issue happens only in the environment that has SP2 installedHow weird?!Thnx,Eran

Hi Eran,I have a post over on my blog that describes how you can build a drill-down chart against OLAP data.  http://blogs.msdn.com/seanboon.  There's a link to the file there as well.  You may also want to check out Chris Webb's BI blog as well as he offers up another approach as well.  Let us know if you still see issues after looking at these approaches.  I don't believe there's anything in SP2 that would cause the difference, but if I were to try and troubleshoot this I would probably start by opening up a profile trace to the OLAP DB to make sure that the same MDX query is being generated in both cases.-Sean Program Manager, SQL Server Reporting Services
This posting is provided AS IS with no warranties, and confers no rights.
http://blogs.msdn.com/seanboon
http://www.twitter.com/ssrs

On a VM I need to install SSRS but it is present a SQL Server instance (with SP2).
I haven't the DVD: how can I add this component by accessing to Control Panel and Adding/Removing Programs?
Any helps to me, please? Many thanks

Hi Pscorca,
You can use the method which was pointed by Alberto above or use the following method (in which way you still need SQL Server 2005
installation media):
1.
Run the SQL Server 2005 setup.exe
2.
Select SSRS feature
3.
Specify the same instance name of the existing instance of SQL Server
4.
After the installation, SSRS would be added
Since the original instance of SQL Server has applied SP2, I would suggest apply SP2 for SSRS. Of course, you canleave it
at RTM.
If you have more questions, please feel free to let us know.
Regards,
Chunsong

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi,We developed the BI application SSIS 2005 and SSRS 2005 with SQL server 2005. During production move plan to use SSIS and SSRS 2008 with SQL Server 2005 database at backend. Please let me know with this confiugration if any known issues are there or any specific measures need to be taken up.Thanks in davance for quick help.-Raks

Hi,You don´t have to do anything really special, after you install just SSRS 2008, you go to Reporting Services Configuration Manager, and go to Database seccion, and just configure the server and database 2005 version you need.You can refer the following post:http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5a86d6dd-f2bd-4d1b-80b2-cd9e30d202c8Thanks.Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Currently we have Win 2003 64 bit R2 SP2 Cluster AND SQL 2005 Enter. Edition 64 bit SP3 CU3 Cluster installed on it (all services including SSRS 2005).is it supported and possible to install without any problems the SSRS 2008 64 bit on the same box?we wana keep the SSRS 2005 running on the Cluster in parallel? what is the best practice of microsoft and what issues are expected in related to compatibiltiy?we still have many databases set to compatibility mode SQL 2000 on the SQL 2005 cluster. is there any scripting issue connecting SSRS 2008 reports to these databases?

Hi Samo1973,
 
Sure, it is supported and possible to install SQL Server Reporting Services 2008 64bit on the same box.
 
We can deploy the SQL Server Database Engine 2008 in the Cluster and the SQL Server Reporting Services 2008 with a scale-out deployment in a load balancing environment.
 
We are required to use SQL Server 2008 as Reporting Services catalog database. If the database is used as data source database, then whatever the SQL Server Engine is 2000, 2005 or 2008, all is fine.
 
For more information, please see:
Scale-out Deployment (Reporting Services Configuration): http://msdn.microsoft.com/en-us/library/ms181357.aspx
 
Please feel free to ask, if you have any more questions.
 
Thanks,
Jin ChenJin Chen - MSFT

I am using sql server 2005 SP2. I have used in one of the textbox a vertical text and it is showing correct when I preview the report in VS 2005 but when I exporting same report to excel it is not showing properly…I think it is a merging of column in excel issue…
 
Anybody has faced the same issue then please reply me ASAP.
Thanks in advance... Jashish Jain

Hi ashish,
 
I am not quirt sure about this issue. After exporting to the excel file, what did you see? Also, how did you create the vertical textbox in your report? Generally speaking, we select the option “tb-rl” to the writing mode property to create a vertical textbox. And in my case, the vertical textbox works fine both in preview mode and in Excel file.
 
The only difference is the textbox can grow in preview mode, so you will see a whole string in a textbox. But in Excel file, the initial size of the textbox looks the same as the textbox in design mode without growing. So you can only see a part of string in excel. If this is the problem you mentioned, this issue could be simply solved by increase the size of the textbox in report. Otherwise, you have to drag the textbox to a big one in Excel.
 
Please let me know if this helps.
Raymond
 

Hello,We are using SSRS 2005 and currently getting an error while accessing our reports from IE.The error says Could not find file 'C:\WINNT\TEMP\mmenylgr.dll'.. The name of the dll is a random name diaplayed by SSRS. It changes whenever we try to refresh the report url.We have tried restarting the reporting services, but it didn't solve the problem.Note: We have SQL Server 2005 SP2 installed on our server.Can anyone please help us to resolve this issues Regards,Amit Ghosh

Hi experts, I'm facing the same problem. when i try to open the report viewer in my asp.net application, i get this error Could not find file 'c:\windows\temp\*.dll' where the name of dll keeps changing all the time. I have given full rights to Network
service, sqlreportingserviceinstance (to the temp folder) but nothing helped so far. Any suggestions ? Thanks, Vishal.

 
I have MOSS 2007 setup which has reports in it via sql 2005 using SSRS. I am trying to view these reports externally however when trying to run the reports i get the following error -
 
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
Any help would be much appreciated.
Thank you.

This isn't a sharepoint developer programming question so I'm moving it to another forum.
 
Regards,
Paul
 

I am trying to install the SRS dataconnector in a clustered environment at a client.  The CRM Application was installed on SQL Server 2005 SP2.  SSRS is SQL Server 2008.  When I try the install, I get the error stating that is cannot find SSRS on the local computer.  My first question is can CRM exist in a mixed SQL server environment:  Database is 2005 SP2 and SSRS is 2008?My second question is:  How does SRS connector detect if SSRS is installed on the local machine?  We want to verify everything is running that SRS is looking for since only SSRS is on this machine.Please advise.  Thanks

In fact, I had an incident at a client where installing the SRS connector on the Cluster caused the cluster to crash.So be Careful.

Hi.. We have SQL 2005 EE in Window 2008. While i installed the SSRS, it showed me to manually configure the SSRS (greyed in that step, so no choice) and have installed SSRS successfully. I also have configured the SSRS and it showed me all green
in the SSRS config manager. I have successfully build for a Report.

Hi SQL ARS,
When there is no SQL Server Database Engine in the same server of the Report Server, the setup will ask us to manually configure the SQL Server Reporting Services(SSRS).
Based on your description, all configureations is green checked in the SQL Server Reporting Services Configuration Manager. So, I assume the installation is fine.
Currently, the error message is HTTP status 503. This means the Reporting Services is not running. I would suggest you checking if the service is running. We can check this from the SQL Server Configuration Manager or the Services console.
Additionaly, since SSRS 2005 is Internet Information Server(IIS) dependence. Please make sure the IIS service is running.
Also, if possible, could you please post the Reporting Services error logs? By default, it can be found from: C:\Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles
Please feel free to ask, if you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT

Hi All,We have a setup where in we install softwares like SQL Server automatically. No human intervention. So, the SQL Server, SSIS, SQL Server 2005 SP2 and SSRS get installed in a row. But note that Reporting Services will be installed after SP2. Reporting services will NOT be configured with installation. It has be dealt with later. No Automation for this.Now after this, we are installing MOM 2005 Reporting. For this, it is required that SSRS is configured. I found that it will have issues configuring it successfully and to resolve it, we should install SP2 again. http://www.mydatabasesupport.com/forums/ms-sqlserver/329497-reporting-services-error-rsinvalidreportserverdatabase.htmlI did that and SSRS gets configured successfully.However, I am a little skeptical as to whether reinstalling SP2 (without uninstalling it - I think it is not even possible to uninstall) will cause any issue.Any information regarding this will be very helpful.Thanks in advance,Manoj Deshpande.

Great, thanks Vidhya Sagar. That comes as a relief :-)Manoj Deshpande.

Hi,

there is an SBO1 2007A system on MSSQL 2005 database server. Should I expect any error when I upgrade this SQL server to MSSQL 2005 SP2 server?

Does someone have any experience about this?

Thanks!

Peter

You have to apply both Service Pack and Patches. In our systems we have applied SP2 which brings the database to the version 9.00.3042 and then applied General Distribution Release as recommended by SAP.

Link for SQL Server SP2...

http://support.microsoft.com/kb/933508

Link for General Distribution Release

http://support.microsoft.com/?kbid=934458

Server: Windows 2003 Ent R2 with SP2, SQL Server 2005 Ent with SP2
Client: Windows XP Professional with SP2, SQL Server 2005 client with SP2
 
When I try to create a JOB from Server, I got error:
Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectkey'.(Micorsoft.SqlServer.Smo)
But Everything is fine if I create a job from client.
So my concern is: the problem is SSMS is not installed properlly in server machine. anybody know how to setup SSMS manaully? Because I don't have permission to UNinstall and reinstall SSMS.
 
Thank you

Thank you guys, my problem is different from others, it's done now, the reason is:
 
Service Pack2 for SQL Server Tools and Workstation Components 2005 ENU (KB921896)
 
is not installed in my server. I reinstall SP2, it's ok now

This is the error:The following system error occurred:  Key not valid for use in specified state. .In SQL Server 2005, it migrates OK. I did a backup in SQL 2005, and a restore attempt in SQL 2008, I got the same error.Kalman Toth, SQL Server 2008 Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com

UPDATE:The Sample: Analysis Services Writeback Sample OLAP cube migrates OK. After moving the DEMO.mdb to destination server and pointing the data source to it, it processes just with a warning.  Dimensions are visible in browse, but only some of the measures are visible others show

#VALUE!

 with type mismatch in legend.Kalman Toth, SQL Server 2008 Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com

I added the SSRS Web Service tomy VS 2008 Project and foundsome of the methods are simply not exposed or I amdoing something wrong (which is most certainly the case). Below is the article I am referencing:
http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Here the URL I used for the service:
http://192.168.XXX.XXX/reportserver/ReportService2005.asmx?WSDL
SQL Server: 2005 (SP2)
Below is my code:

Imports System.IO
Imports System.Web
Imports TestJunk.SSRS_WebService 'Designated Name of Service

Public Class Form1

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim MyRS As New ReportExecutionService()'Error: Type 'ReportExecutionService' is not defined
End Sub

End Class

Tony,
THANK YOU so much! Clearly this is something I should have picked up on my own. :)
Thanks,
Bobby

Hello,Hopefully this is an easy question. To set up SSRS 2005 in integrated mode, I need to install SharePoint on the ReportServer (separate from MOSS server). Does anyone know if I need to install just basic MOSS installation or install MOSS SP2 to match my SharePoint server? Thanks!

Found the answer elsewhere. The WSS or MOSS version on the report server should indeed be same as the SharePoint environment.

Hello Friends : I have installed SQL server 2005 neterprise edition SP2 reporting service , when i browse the web with localhost/ReportServer$ it dies not show me anything just the version of SSRS. How can i fix it ?Network is my LOVE

I finally solved the problem just put the name of the database instance after the reports like : localhost/ReportServer$InstanceName Thats itNetwork is my LOVE

I am using SQL Server 2005 SSRS and I have around 100 reports scheduled daily. Can I set emails for failures for subscriptions? How can I check detailed error message on server. I can only see short error messagein MySubscriptions.

Hi,
Currently, we can monitor the subscriptions by report server logs and report server tables. See

http://blogs.msdn.com/b/deanka/archive/2009/01/13/diagnosing-and-troubleshooting-subscriptions.aspxfor some informations about monitoring and troubleshooting subscriptions. Also, you can submit a feedback at
http://connect.microsoft.com/SQLServer/Feedbackand hope microsoft enable them in the next release.
thanks,
Jerry

Environment: SQL Server 2005 Standard Edition (9.0.3077)running in Windows Server 2003 Enterprise Edition SP2
SSRS is started but the following entry (Event 120)is logged in Application log:
The report server cannot decrypt the symmetric key. Most likely, the service account or password has changed. To continue, run rsconfig.exe to update the report server account information.\r\n
Does this mean that SSRS is actually not functional at all even though it is running? If yes, I want to stop the SSRS.

I didn't install it and there is no one knows whether it is being used or not. If that message means the SSRS is not functional at all, I can stop it and won't break anything which is working. So, I hope someone can simply tell me
whether the SSRS is actually functional or not.

0xC3EC7A0B
Database error creating the RTC database.
The server is Windows 2003 R2 SP2 32-bit with SQL 2005 SP2 32-bit already installed.  Can I use the SQL 2005 full release instead of Express?   I created the two RTC users as domain admins and universal admins. 
 

 I have a all Windows 2003 servers in the domain.  Most are R2.  5 of 6 are 64-bit.  I have a single Windows 2000 SP4 server in a workgroup.  Its not part of the domain.  Will communicating with this server be a problem for my domain users? OCS 2007 R2 server roles work with Windows Server 2003 domain controllers (x86 and x64). They can communicate with any member server in the domain as long as corresponding permissions and rights are granted.For workgroup servers, users need to be separately authenticated and authorized before access to resources are possible.Hope this helps. Thanks.TechNet Forum Moderator - http://www.leedesmond.com/weblog/

With windows XP not a problem with Printing. With Windows 7, 32 bit IE getting the error 'Unable to Load Cleint print control.'
1)Client using 32bit Internet Explorer on Windows 764 bit.
2)Server: SSRS 2005.
2)registeredRSClientprint.dll on Windows 7, system32 folder.

Hi slyc,

As well know, the client print control is an Active X object. When we click on the print button, the HTML with a
CLASSID will be sent to the browser. If the browser can find the Active X and a same CLASSID, it will print fine. Otherwise, it will probably throw the error Unable to Load Client print
control. To trouble shoot this issue:

Make sure that the rsclientprint.dll is not corrupt or the RSClient print is not blocked by Internet Explorer(IE)
1. Make sure ActiveX is enabled in IE

a. Click Tools Internet Options...

b. Go to Security tab.

c. Select appropriate zone(for example, if Report Server site is added to Trusted sites zone, please select Trusted sites zone)

d. Click Custom Level

c. Make sure Download signed ActiveX controls is enabled or prompted.

2. Delete the temporary

a. Click Tools Internet Options...

b. In General tab, click Setting... in the Browsing history group

c. Click View objects

d. In the new Windows Explorer window, delete the all rsclientprint ojbects.

Make sure that the
CLASSID on the client is the same as the server. You can get the CLASSID by the following steps.
1. Install the Window Resource Kits. We can download it from http://www.microsoft.com/downloads/details.aspx?familyid=9d467a69-57ff-4ae7-96ee-b18c4790cffddisplaylang=en. The tool oleview is in the resource kits.

2. Open the oleview, navigate to the ActiveX we want.

3. Right-click the ActiveX (such as RSClientPrint), and then click Copy CLSID to Clipboard.

4. If we want to use the ActiveX in a web page, we can click Copy HTMLobject Tag to Clipboard

More information about Client Print Fails to Load, please see:
http://blogs.msdn.com/b/brianhartman/archive/2008/11/05/client-print-fails-to-load-after-microsoft-update-956391.aspx

Thanks,
Lola
Please remember to mark the replies as answers if they help.

Hello All, I have run into some difficulty with trying to configure SPS 2003 (with WSS sp2 and SPS sp2) to use a SQL 2005 Cluster. I keep getting  this error  

Error Message

Hello All, I have run into some difficulty with trying to configure SPS 2003 (with WSS sp2 and SPS sp2) to use a SQL 2005 Cluster. I keep getting  this error  

Error Message

Hi All,
I have just created a new virtual machine and installed sql 2005 on it with ssrs reporting service.
In Service list by default sql server reporting service was stopped, i tried to start it by right click on it but it shows error message saying
SOME SERVICES STOP AUTOMATICALLY IF THEY ARE NOT IN USE BY OTHER SERVICES
i am not able to configure my report server as ssrs reporting service is not running. any thing i am missing.
Any Ideas???
Thanks
SKM

http://www.sqlservercentral.com/Forums/Topic186166-146-1.aspxPlease Mark as Answer if my post solved your problem or Vote As Helpful if this helps. Blogs: www.sqlserver2005forum.blogspot.com

I use BIDS 2005 to write SSRS 2005 reports and would like to update this to the latest service pack(s).
In the About window for BIDS it shows I am using:

Visual Studio 2005 Version 8.0.50727.42 (RTM.050727-4200) .NET Framework Version 2.0.50727 SP2 SQL Server Reporting Service Designers Version 9.00.1399.00
Which service packs should I apply to bring my report writing environment up to date?
TIA, magendo_man

Yes, it will update all your related existing environment (e.g. BIDS, SSRS, SQL, etc...).
When you install the SP3, thereis a page that tells you what are the components installed currently.
Hope this helps!Thanks, Michael Mei

I'm trying to reinstall SQL 2005, including SSRS because SSRS didn't seem to install correctly. I uninstalled everything in the control panel having to do with SQL Server but the install package says SSRS is still on the machine. How do I UNINSTALL
ssrs to start over?

(Win Server 2008R2)

Hi JohnSLG,

If you uninstall Reporting Services 2005 successfully, I recommend you that refer to the following articles to install Reporting Services:
List of known issues when you install SQL Server on Windows 7 or on Windows Server 2008 R2
How to: Install and Configure Reporting Services on Windows Server 2008
How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows

Thanks,
Bin Long

TechNet
Subscriber Supportin forum
If you have any feedback on our support, please contact
tnmff@microsoft.comPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

I'm attempting to install the standard version of SQL server 2005 on XP SP2.  I'm getting the following:Errors occurred during the installation:Error 1603 installing Microsoft SQL Server 2005 setup support files. 

Thanks! that worked for me too!

Alternative 1. Updatingsofware as describedon Brian's blog SQL Server 2005 Report Viewer 2005 Redistributable
and VS 2005 did not fix my problem.

It seems likeit turned out to be that IE was running without admin rights due to a policy.
Try with proper permissions.Thanks, Ranjitsingh R | http://mscrm-developer.blogspot.com/ | MS CRM Consultant

My environment is as follows: -

Microsoft SQL Server Reporting Services Version 9.00.4035.00 MOSS SP2 with full hotfixes Windows Server 2003 Internet Explorer 7

I'm having an issue that I hope someone can help me with. I'm running a server farm where in which MOSS 2007 (SP2) and SSRS 2005 are running alongside each other. SSRS has been configured to run in SharePoint integrated mode, with what appears
to be no problem. We've further configured the report generator to tie into a specific site collection, upon which we hope to store, create and retrieve reports as required. The problem that I'm encountering is that whenever I try and access the
Report Builder via this integrated Site collection, I'm generating the following error message: -
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. -- The request failed with HTTP status 503: Service Unavailable
This suggested to me that it was a permissions issue, so these have all been checked correctly and nothing stands out as being incorrect. The items I have inspected thus far are: -

Permissions across SSRS, SQL, MOSS: These all appear correctly SharePoint Integrated Mode: This is running with no problems in the SSRS Configuration Manager
Accessing the instance in SSMS: I'm unable to access the instance in SQL Server Management Studio (I generate a 404 error), but it can be accessed via the browser
I have checked the SharePoint hive 12 logs and no SSRS logs appear here. I've checked theReportServerService logs, and only get one error (see below)
I'm able to access the SSRS configuration screen and default settings via MOSS Central administration

The ReportServerServices log generated this error message: -

Actually, Report Builder uses ClickOnce technology to download and install its application files on a client computer
when you Edit a report. ClickOnce sends requests that specify Windows integrated security in the authentication header. If a server is configured for a different authentication type, the server will fail requests from ClickOnce. To work around this issue,
you must either configure a server for Windows integrated security or you must enable Anonymous access to eliminate the authentication check. Steps for enabling Anonymous access are below:
1.
Open Internet Information Services (IIS) Manager.
2.
Click the sharepoint site, you will see Authentication on the Features View surface.
3.
Click the Authentication icon, then Enable the Anonymous Authentication in the status column.

For more information about How to: Configure Report Builder Access, please see:
http://msdn.microsoft.com/en-us/library/ms365173.aspx

Hope this helps.
Thanks,
Challen FuChallen Fu [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi: 
We have been facing some difficulty using XML Datasets in SSRS 2005.                                                                                                                                                                                                                                                     
More details about the issue as follows…
 
Platform: Windows 2003 SP2
Server: SQL Server 2005 Standard edition
 
 
Problem Description:  We are unable to query a webmethod (hosted on linux platform) using XML Data Source in SSRS 2005 Report Designer.  The web method requires a complex type parameters that include an Array of Strings.  We are unable to determine the exact way in which we need to pass these parameters to the web method.
 
Environment:  SSRS 2005 Report Designer
Web Service (in question):  http://xxx/accessPointV1?WSDL
Web Method (in question): getFameData
Data Source Type:  XML
Data Source Connection String: http://xxx/accessPointV1
Dataset Query String:
Query
    Method Namespace=http://accessPoint.fame.com/accessPointWebService/ Name=getFameData
    Parameters
                                                                                       
            Parameter Name = ticketabcdedf/Parameter
 
Parameter Name = string
Values
ValueMIP_DEV'PTF.RAW.IHPH.DTD.NCW.USD.PAM/Value
/Values
/Parameter
 
Parameter Name = name
Values
Valuefromdate/Value
Valuetodate/Value
Valuescaling/Value
/Values
/Parameter
 
Parameter Name = value
Values
ValueF/Value
Value*/Value
ValueDefault/Value
/Values
/Parameter
 
    /Parameters
 
/Method
    ElementPath IgnoreNamespaces=true*/ElementPath
    SoapActionhttp://accessPoint.fame.com/accessPointWebService/getFameData/SoapAction
/Query
 
Error Message (while executing the Query for the Dataset created above):
 
===================================
 
An error occurred while executing the query.
Failed to execute web request for the specified URL. (Microsoft Report Designer)
 
===================================
 
Failed to execute web request for the specified URL. (Microsoft.ReportingServices.DataExtensions)
 
------------------------------
Program Location:
 
   at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteWebRequest(ICredentials credentials)
   at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.Execute()
   at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.c__DisplayClass1.ExecuteReaderb__0()
   at Microsoft.ReportingServices.DataExtensions.XmlDP.WebRequestHelper.ExecuteServerCallAsNtUser(ServerCall serverCall, WindowsIdentity ntUser)
   at Microsoft.ReportingServices.DataExtensions.XmlDP.InMemoryCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ReportingServices.QueryDesigners.QueryResultsGrid.ExecuteQuery()
 
===================================
 
soap:Envelope xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/ xmlns:xsd=http://www.w3.org/2001/XMLSchema xmlns:xsi=http://www.w3.org/2001/XMLSchema-instancesoap:Bodysoap:Faultfaultcodesoap:Client/faultcodefaultstringNot enough message parts were received for the operation./faultstring/soap:Fault/soap:Body/soap:Envelope
 
Thank You.

Hi Srini: 
Sorry, wrong forum.   This is a forum for SQL Server Data Services (SSDS).  Please repost your question to the appropriate SQL Server forum at: http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19SiteID=1.  Sorry for the confusion.Patric

I need to create a multi column report in SSRS 2008. Gone through almost all the help files. The column tab in the Report Properties they are referring to are only in SSRS 2005 but not in 2008. Atleast not that I could see. Is this feature REALLY available
in SSRS 2008? How can you see the lay out that shows the columns setting in 2008. I need the exact steps please - only in 2008 not in 2005 nor any theoratical statements from technical papers. Thanks in advance.
My current environment is SQL Server 2008 SP2.
Microsoft SQL Server Reporting Services Designers Version 10.0.4000.0
Microsoft Visual Studio 2008 Version 9.0.30729.1 SP

Wonderful. This is what I was exactly looking for. Thank you very much.

Has anyone successfully developed reports on SSRS 2008 using Hyperion 9.3.1 as a datasource?  I have read the whitepaper about Using SQL Server 2005 Reporting Services with Hyperion Essbase and can connect and see the metadata, but I keep getting the Unknown Member PARENT_UNIQUE_NAME  It says to resolve this by installing SP2 for 2005.  Don't we already have that if we are using 2008?  Any suggestions or success stories would be helpful.Thanks,Richard

Hi Richard,
 
This issue may occur because the Hyperion Essbase – System 9 version 9.3.1 release has changed the name of the Essbase provider. Because of this change, Reporting Services can no longer connect to the Essbase Provider.
 
To fix this issue, you can access http://support.microsoft.com/kb/956717/  and download the hotfix to install.
 
This article http://support.microsoft.com/default.aspx/kb/957113 describes your issue.
 
Thanks,
Jerry

Hi.. We have SQL 2005 EE in Window 2008. We also have the SSRS there. While i installed the SSRS, it showed me to manually configure the SSRS (greyed in that step, so no choice) and have installed SSRS successfully. I also have configured the SSRS and
it showed me all green in the SSRS config manager. I have successfully build for a Report.

Hi William \ Jerry,
did u have a chance to loook..? any thing u can pls help me out with.. ?

I'm using RB2 on SSRS 2008 SP1 CU3, reporting against a SQL 2005 database....

Hello Rimstalker,this particular internal error is unrelated to the type of your data source.  It is caused by the specific report structure and expressions you are using.  In order to further investigate this, we would need to see your actual report - in this particular case I think just the RDL file is sufficient for initial investigation.  Could you please create a new bug for this internal error at https://connect.microsoft.com/sqlserver, and attach your report (RDL)?  Just to set expectations though - a bug filed through connect is typically investigated in the context for the next product release and there is no guaranteed response time.  Of course, if we also find a solution/workaround for SSRS 2008 we will let you know :)If you need a quicker response and also specifically in the context of SSRS 2008, you would need to call your Microsoft support contact and open a support ticket.Thanks,RobertRobert Bruckner   http://blogs.msdn.com/robertbruckner
This posting is provided AS IS with no warranties, and confers no rights.