• RELEVANCY SCORE 3.98

    DB:3.98:How To Convert Ssrs 2005 To Ssrs 2008? k3





    Hi, I have SQL Reporting Service 2005 SP2 in our production environment. How to convert SSRS 2005 to SSRS 2008 for individual report file or entire visual studio solution (.sln)? Pls reply ONLY answerswhere someone wrote with step-by-step instruction and possible error/warning lists during converion. Thanks...

    DB:3.98:How To Convert Ssrs 2005 To Ssrs 2008? k3

    Hi, I have SQL Reporting Service 2005 SP2 in our production environment. How to convert SSRS 2005 to SSRS 2008 for individual report file or entire visual studio solution (.sln)? Pls reply ONLY answerswhere someone wrote with step-by-step instruction and possible error/warning lists during converion. Thanks...

  • RELEVANCY SCORE 3.71

    DB:3.71:Is Anybody Successfully Migrated Ssrs 2005 Sp2 To Ssrs 2014? dm





    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.

    DB:3.71:Is Anybody Successfully Migrated Ssrs 2005 Sp2 To Ssrs 2014? dm

    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

  • RELEVANCY SCORE 3.67

    DB:3.67:Datetimeoffset In Report Parameters pd





    This is with SSRS 2008 SP1.Since upgrading to SSRS 2008 SP1 (from SSRS 2005 SP2) we have had trouble with dates.We have some roprts where people enter a start end date. The parameter types is datetime. Before the upgrade they could enter 1/1 and it would resolve automatically to 1/1/2009 12:00am - since the upgrade it instead resolves automatically to 1/01/2009 12:00:00 AM +11:00, which causes the report to throw the error: The version of SQL Server in use does not support datatype 'datetimeoffset'. Our SQL servers are all still on SQL 2005 - its only RS (which is on a separate server) that  we have upgraded. Does anyone have any solutions to make it not add the time offset onto it? Thanks!.

    DB:3.67:Datetimeoffset In Report Parameters pd

    Hi Laridae,
    Please can you tell me theroot cause of behaviorfor displaying DateTimeOffset format in parameter.Vir14

  • RELEVANCY SCORE 3.62

    DB:3.62:Cannot Upgrade Sql Server 2005 Express To Sp2 After Upgrading Sql Server 2005 Enterprise To Sp2 9f


    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?

    DB:3.62:Cannot Upgrade Sql Server 2005 Express To Sp2 After Upgrading Sql Server 2005 Enterprise To Sp2 9f

    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.
     

  • RELEVANCY SCORE 3.60

    DB:3.60:Ssrs Sql 2005 Express And Ssl 8a


    Hi there,
    I'm new to SQL Server management and I'm struggling to achieve SSL with SSRS 2005 Express. I'm trying to test it with a self signed cert created in IIS management window. How do I then install this for use with my SSRS instance?
    Thanks,
    Jack

  • RELEVANCY SCORE 3.47

    DB:3.47:Sql Server 2005 Express Edition With Advanced Services Sp2 Error 2350 38


    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.

    DB:3.47:Sql Server 2005 Express Edition With Advanced Services Sp2 Error 2350 38

    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.
     

  • RELEVANCY SCORE 3.39

    DB:3.39:Inputs Required Related To Sql Reporting Services pj


    Hi, I need inputs on following points related to SQL Sercver Reporting Services (SSRS).
    1. SSRS capability which is bundled with SQL Server(2005/2008) in terms of number of concurrent threads and performance.
    2. Difference between SSRS basic version and SSRS server edition.
    3. Migration from crystal reports to SSRS
    4. Limitations of SSRS
    5. Authentication

    Regards,
    Sachin

    DB:3.39:Inputs Required Related To Sql Reporting Services pj

    Hi Sachin_G,

    Question 1: SSRS capability which is bundled with SQL Server(2005/2008) in terms of number of concurrent threads and performance.
    Reporting Services is a reporting platform that combines the scalability and manageability of a centrally managed report server with the flexibility of Web-based and desktop-based report delivery. I recommend you that refer to the article about Planning for
    Scalability and Performance with Reporting Services, please see:
    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/fd545d6c-1d69-46e5-9442-5f926faab362

    Question 2: Difference between SSRS basic version and SSRS server edition.
    There is an article about SQL Server version list, please see:
    http://www.sqlteam.com/article/sql-server-versions
    Reporting Services is available in Standard Edition, Enterprise Edition, Developer Edition, and Evaluation Edition. Editions vary by licensing restrictions and by the features they support. For more information, please see:

    Programming Features for Reporting Services Editions:
    http://technet.microsoft.com/en-us/library/ms365156.aspx
    How to: Detect Version information:
    http://technet.microsoft.com/en-us/library/bb630446.aspx

    Questions 3: Migration from crystal reports to SSRS
    Please refer to the article about Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services, please see:

    http://technet.microsoft.com/en-us/library/aa964127(SQL.90).aspx

    Question 4: Limitations of SSRS
    I think youll have a better understanding of SQL Server Reporting Services after refer to the article:

    http://technet.microsoft.com/en-us/library/ms159106.aspx

    Questions 5: Authentication
    Reporting Services provides default authentication based on Windows integrated security and assumes trusted relationships where client and network resources are in the same domain or a trusted domain. For more information, please see:

    http://technet.microsoft.com/en-us/library/bb283249.aspx

    Thanks,
    Bin Long

    TechNet
    Subscriber Supportin
    forum
    If you have any feedback on our support, please contact
    tnmff@microsoft.com

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

  • RELEVANCY SCORE 3.38

    DB:3.38:Converting Ssrs 2005 Rdl To Ssrs 2008? f7


    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

    DB:3.38:Converting Ssrs 2005 Rdl To Ssrs 2008? f7

    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

  • RELEVANCY SCORE 3.38

    DB:3.38:Error When Evaluate A Policy Against Sql 2000/2005 Server ka


    When I try to evaluate one policy against SQL 2000 or 2005 on SQL 2008 R2 , it shows one error that 'operation not supported on SQL 2000' . On sql 2008, I fixed it with SP2 but I dont know if SQL 2008 R2 contains the fixes of SQL 2008 SP2.

  • RELEVANCY SCORE 3.37

    DB:3.37:Sql Server Reporting Services - Deserialization Failed: Could Not Load Type Microsoft.Visualstudio.Shell.Iolemenucommand From Assembly Microsoft.Visualstudio.Shell.Interop.8.0, Version=8.0.0.0 c7


     
    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

  • RELEVANCY SCORE 3.35

    DB:3.35:Sql Server 2005 Reports With Sql Server 2014 xx


    Can i upload SSRS 2005 reports as it is on SSRS 2014 and use it without doing anything extra or without changing anything ??
    I can use SSRS 2005 reports as it is with SSRS 2012. But for SSRS 2014 not sure.

    h2007

    DB:3.35:Sql Server 2005 Reports With Sql Server 2014 xx

    You can upgrade the the RDL schema will be upgraded.
    Report definition (.rdl) files are automatically upgraded in the following ways:

    When you open a report in Report Designer in SQL Server Data Tools (SSDT), the report definition is upgraded to the currently supported RDL schema. When you specify a SQL Server 2008 or SQL Server 2008 R2 report server in the project properties, the report
    definition is saved in a schema that is compatible with the target server.

    When you upgrade a Reporting Services installation to a SQL Server 2014 Reporting Services (SSRS) installation, existing reports and snapshots that have been published to a report server are compiled and automatically upgraded to the new schema the first
    time they are processed. If a report cannot be automatically upgraded, the report is processed using the backward-compatibility mode. The report definition remains in the original schema.

    Reports are not upgraded when you upload a report definition file directly to the report server or SharePoint site. Upgrading a report definition in SQL Server Data Tools is the only way to upgrade the .rdl file.

    After a report is upgraded locally or on the report server, you might notice additional errors, warnings, and messages. This is the result of changes to the internal report object model and processing components, which cause messages to appear when underlying
    problems in the report are detected. For more information, see Reporting Services Backward Compatibility.
    For more information about new features for SQL Server 2014 Reporting Services (SSRS), see
    What's New (Reporting Services).
    Check the below Microsoft link for more information
    http://msdn.microsoft.com/en-us/library/ms143674.aspxMudassar

  • RELEVANCY SCORE 3.33

    DB:3.33:The Permissions Granted To User Domainname\Userxxx Are Insufficient For Performing This Operation. (Rsaccessdenied fa


    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

    DB:3.33:The Permissions Granted To User Domainname\Userxxx Are Insufficient For Performing This Operation. (Rsaccessdenied fa

    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

  • RELEVANCY SCORE 3.33

    DB:3.33:Moving The Sql 2005 Ssrs Databases To A Sql 2008 Server ps


    I am running SSRS 2005 in a server and the SQL SSRS DBsare located in a different server running SQL 2005 standard edition; we want to move the SSRS databases from the SQL 2005 server to a new and more powerful box running SQL 2008 Standard edition
    but keep SSRS running the SQL 2005 standard edition. What are my options here?

    DB:3.33:Moving The Sql 2005 Ssrs Databases To A Sql 2008 Server ps

    Hi carlosalbertoarangoororco,

    Thanks for your post.

    According to your description, you want to migrate your Reporting Services database to SQL Server 2008 server. If so, you can refer to the articles below, which demonstrate the details steps for you:
    http://msdn.microsoft.com/en-us/library/ms156421(v=SQL.100).aspx

    Thanks,
    Bill LuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.33

    DB:3.33:Sql Server 2005 Sp2 Supported With Crystal Reports Server Xi R2 For Cms Database? zd


    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

    DB:3.33:Sql Server 2005 Sp2 Supported With Crystal Reports Server Xi R2 For Cms Database? zd

    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

  • RELEVANCY SCORE 3.32

    DB:3.32:Ssrs 2005 Standard And Data Driven Subscriptions 38


    We have SQL Server 2005 Standard and were looking into using data driven subscriptions. From what I've read you need the Enterprise version of SSRS to use this feature. Just wondering:
    1) Has anyone found a way to do this with SSRS 2005 standard?
    2) Is it possible to install SSRS Enterprise on SQL Server Standard?Janice Juszczec

    DB:3.32:Ssrs 2005 Standard And Data Driven Subscriptions 38

    FYI: If you need to extend SSRS with data driven reports you can try also R-Tag Report Manager and RemiVare - reallycheap desktop additions.

  • RELEVANCY SCORE 3.31

    DB:3.31:Visual Studio 2005 Hanging Application Devenv.Exe ck


    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.

    DB:3.31:Visual Studio 2005 Hanging Application Devenv.Exe ck

    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.

  • RELEVANCY SCORE 3.31

    DB:3.31:Thread: Sql Server 2005 Sp2 jc


    is ZAM 7.5 compatible to run on SQL Server 2005 SP2?

    DB:3.31:Thread: Sql Server 2005 Sp2 jc

    Jared Jennings said on 8/18/2008,

    is ZAM 7.5 compatible to run on SQL Server 2005 SP2?

    Donno, I will ask though.

    It\'s supported.

    -' + '-

    Jared Jennings - Data Technique, Inc.

    Novell Support Forums Sysop

    My Blog and Wiki with Tips, Tricks, and Tutorials

    http://jaredjennings.org

  • RELEVANCY SCORE 3.28

    DB:3.28:Version Mismatch Error While Installing Analysis Serivices On Sql Server 2005 Sp2 19


    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

    DB:3.28:Version Mismatch Error While Installing Analysis Serivices On Sql Server 2005 Sp2 19

    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

  • RELEVANCY SCORE 3.28

    DB:3.28:Error Code 2b08 - Unknow Error Sp2 Sqlserver 2005 c9


    L'installazione dell'aggiornamento in SP2 per SQLServer 2005 fallisce con l'errore2B08 - Unknow error. Dal registro eventi visualizzo il codice di errore:Installation Failure: Windows failed to install the following update with error 0x80070643:
    Security Update for SQL Server 2005 Service Pack 2 (KB960089).
    Grazie,
    Stefano

    DB:3.28:Error Code 2b08 - Unknow Error Sp2 Sqlserver 2005 c9

    questo è l'unico errore che noti sul server ? ci sono altri errori nel registro eventi che potrebbero essere correlati a questo ?Edoardo Benussi
    Microsoft MVP - Directory Services
    edo[at]mvps[dot]org

  • RELEVANCY SCORE 3.28

    DB:3.28:Compatibilidad Windows Server 2003 Sp2 Con Sql Server 2005 kc


     
    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.

  • RELEVANCY SCORE 3.27

    DB:3.27:Error Connecting To Ssrs Ssis 2005 Instances From Ssms 2008 Rtm cc


    I have installed the SSMS 2008 RTM and am having problems connecting to 2005 Reporting Services and 2005 Integrated Services Instances. When connecting to 2005 Reporting Services I receive an error WMI Provider Error - Invalid Name Space. For 2005 Integrated Services the error Connection to SSIS Services Failed - Class Not Registered.
     
    I do not have a problem connecting to SQL Server 2005 instances or 2005 instances of SSAS.
     
    Thanks,

  • RELEVANCY SCORE 3.27

    DB:3.27:Install Ssrs If R2 Sp2 Already Installed ? cc


    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 ?

    DB:3.27:Install Ssrs If R2 Sp2 Already Installed ? cc

    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

  • RELEVANCY SCORE 3.26

    DB:3.26:Sql Server 2005 Ssrs Eventid 7000 / 7009 - Service Did Not Respond / Start pd


    Hi!
    Ive got a problem regarding SSRS on a SQL Server 2005 Server.
    The Service isnt able to start.
    The following Events were logged:
    Event Type:Error
    Event Source:Service Control Manager
    Event Category:None
    Event ID:7009
    Date:09.05.2011
    Time:09:05:02
    User:N/A
    Computer:SERVER
    Description:
    Timeout (30000 milliseconds) waiting for the SQL Server Reporting Services (INSTANCE) service to connect.

    Event Type:Error
    Event Source:Service Control Manager
    Event Category:None
    Event ID:7000
    Date:09.05.2011
    Time:09:05:02
    User:N/A
    Computer:SERVER
    Description:
    The SQL Server Reporting Services (INSTANCE) service failed to start due to the following error:

    The service did not respond to the start or control request in a timely fashion.

    Windows Version is: 5.2 Build 3790.srv03_sp2_gdr.101019-0340 (SP2)
    SQL Version. 9.0.3080

    Any Idea?
    Thanx,
    Karsten Mueller

    DB:3.26:Sql Server 2005 Ssrs Eventid 7000 / 7009 - Service Did Not Respond / Start pd


    Hi Karsten Mueller,
    Thanks for your question. After looking over the log information, I think it might be the issue of timeout. Below is
    a process that correct it, please follow these:
    1.
    Click Start, click Run, type regedit, and then click OK
    2.
    Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
    3.
    In the right pane, locate the ServicesPipeTimeout entry.
    Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:

  • RELEVANCY SCORE 3.26

    DB:3.26:Move Ssrs 2005 From One Machines Sql Instance To Another Machines Sql Instance Results In Wmiproviderexception Error kf


    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

    DB:3.26:Move Ssrs 2005 From One Machines Sql Instance To Another Machines Sql Instance Results In Wmiproviderexception Error kf

    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

  • RELEVANCY SCORE 3.25

    DB:3.25:Installing Ssrs 2005 On Different Machine Than Sql Server (Authentication Problem) cc


    Hi guys,
    I tried to install ssrs 2005 on a different machine than SQL Server, but during SSRS 2005 configuration I get error for user authentication.
    What is the best way to have the right authentication?
    Many thanks

    DB:3.25:Installing Ssrs 2005 On Different Machine Than Sql Server (Authentication Problem) cc


    Hi fasttrack,

    Do you mean your Reporting Services 2005 and the Report Server database are setup on separate servers, but you do not have domain architecture? So, can we say currently the issues
    access database on another server without domain? If I have misunderstood, please point out.

    Generally, we can use the Reporting Services Configuration tool to create and configure a connection to the report server database. For the detailed steps, please refer to
    http://msdn.microsoft.com/en-us/library/ms157300(v=SQL.90).aspx

    If you have any more questions, please feel free to ask.

    Thanks,
    Tony Chain

    Forum Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact
    tnmff@microsoft.com.

  • RELEVANCY SCORE 3.23

    DB:3.23:Installing Ssrs 2005 Add-In For Sharepoint On Win 2008 pc


    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,

    DB:3.23:Installing Ssrs 2005 Add-In For Sharepoint On Win 2008 pc

    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

  • RELEVANCY SCORE 3.22

    DB:3.22:Is Reportviewer 2012 Compatible With Ssrs Server 2005 For Remote Access? pj



    While attempting to view a report in ReportViewer 2012 from SSRS 2005 in remote mode I am getting error: Remote report processing requires Microsoft
    SQL Server 2008 Reporting Services or later.

    Are they compatible or not? Or is it just a matter of changing endpoint WebService URL fromhttp://machine/ReportServer/ReportService2005.asmxto
    something else? It seems to work fine connecting to SSRS 2008 though.

    If they're incompatible, could someone please provide a full compatibility list - which ReportViewer can be run with which SSRS service:

    ReportViewer v11 (2012) is compatible with SSRS (2005, 2008, 2008 R2, 2012) ?

    ReportViewer v10 (2010) is compatible with SSRS (2005, 2008, 2008 R2, 2012) ?

    ReportViewer v9 (2008) is compatible with SSRS (2005, 2008, 2008 R2, 2012) ?

    Thanks!

    DB:3.22:Is Reportviewer 2012 Compatible With Ssrs Server 2005 For Remote Access? pj

    Hi Trekstuff,
    Yes, the Report Viewer 2012 and Report Viewer 2010 remote processing mode refers to report processing that is performed by a SQL Server 2008 or higher Reporting Services report server. Similarly, the Report Viewer 2008 remote processing mode requires that
    the version of the report server is SSRS 2005 or higher.
    For more information, please see the following document for different versions of SQL Server:
    ReportViewer Controls (Visual Studio)
    Regards,Mike Yin
    TechNet Community Support

  • RELEVANCY SCORE 3.20

    DB:3.20:Ssrs 2005 Installed On Windows Server 2008 Standard Edition Has Barcode Issue 88


    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.

    DB:3.20:Ssrs 2005 Installed On Windows Server 2008 Standard Edition Has Barcode Issue 88

    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

  • RELEVANCY SCORE 3.20

    DB:3.20:Error Code 1603 When Install Sp2 For Sql 2005 3p


    i have this error in the event log when i install sp2 for sql
    the sp2 falied with the client componnets instalion
    my server is sbs 2003 with sp2

    DB:3.20:Error Code 1603 When Install Sp2 For Sql 2005 3p

    i have this error in the event log when i install sp2 for sql
    the sp2 falied with the client componnets instalion
    my server is sbs 2003 with sp2

  • RELEVANCY SCORE 3.19

    DB:3.19:Hiding Select All In Multivalue Parameter In Sql 2005 Sp2 And 2008 Sp2 77


    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.

    DB:3.19:Hiding Select All In Multivalue Parameter In Sql 2005 Sp2 And 2008 Sp2 77

    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

  • RELEVANCY SCORE 3.19

    DB:3.19:Sql Server 2005 Express: Error 2356 d3


      i tried to install sqlserver 2005 express on windows xp sp2 and got error 2356.

    DB:3.19:Sql Server 2005 Express: Error 2356 d3

    Might be a corrupt installer.  Can you try downloading it again, and let us know how you fare?Aaron Alton | thehobt.blogspot.com

  • RELEVANCY SCORE 3.18

    DB:3.18:I Plan To Upgrade The Ssrs 2005 Sp2 Enterprise Edition In Our Internal Web Server To 2005 Sp4, The Reporting Server Database Is Hosted In Another Sql Server In Sql Server 2005 Sp4. Do I Need To Do Anything On The Reporting Server Database Side? ss


    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

    DB:3.18:I Plan To Upgrade The Ssrs 2005 Sp2 Enterprise Edition In Our Internal Web Server To 2005 Sp4, The Reporting Server Database Is Hosted In Another Sql Server In Sql Server 2005 Sp4. Do I Need To Do Anything On The Reporting Server Database Side? ss

    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

  • RELEVANCY SCORE 3.18

    DB:3.18:Relocating Ssrs 2005 Databases 9c


    Hi,
    Can SSRS 2005 databases be hosted on a SQL 2008 R2 instance? There is a move to shutdown the 2005 instance, we would continue using SSRS 2005 reporting services hosted on a web server but the databases would be on 2008 R2.

    Regards,

    DB:3.18:Relocating Ssrs 2005 Databases 9c

    Yes, we can use an existing Report Server Database onSSRS 2005as theSSRS 2008 R2 Report Server database.Katherine Xiong
    TechNet Community Support

  • RELEVANCY SCORE 3.17

    DB:3.17:Install Ssrs On Sql 2005 Sp3 km


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

    DB:3.17:Install Ssrs On Sql 2005 Sp3 km

    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

  • RELEVANCY SCORE 3.15

    DB:3.15:Erroe While Installing Sql Server 2005 Sp2 fz


     
    Hi,
    While installing SQL SERVER 2005 SP2 , I get an error screen saying
    Extraction Failed
    hotfix.exe is not a valid Win32  application.
    Please let me know what is the reson for this error
    Regards,
     
     

  • RELEVANCY SCORE 3.14

    DB:3.14:After Pushing Ssrs 2005 Report To Ssrs 2008. Error: Subreport Could Not Be Shown, Report Which Has Dundas Chart[2005]. 7s


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

    DB:3.14:After Pushing Ssrs 2005 Report To Ssrs 2008. Error: Subreport Could Not Be Shown, Report Which Has Dundas Chart[2005]. 7s

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

  • RELEVANCY SCORE 3.11

    DB:3.11:Sql 2005 Sp2 Installation Blocked 8a


    I'm getting the following error when I try to run SQL05 SP2 on my server.  When I get to the Authentication screen, I select Windows Authentication and check the box to use for all services.  I am logged in using my personal admin account.  I click the 'Test' button.  Connection to Database Services, instance name 'MSSQLSERVER' is successful.  However, connection to Reporting Services, instance name 'myserver\SSRS' fails.  The error message is: Login failed: HResult 0x2, Level 16, State 1, Named pipes provider: Could not open a connection to SQL Server[2]. Sqlcmd: Error: Microsoft SQL Native Client: An error has occurred while establishing a connection to the server.  When connecting to SQL Server.I've had problems getting Reporting Services to work.  Is this message a result of SSRS not being set up properly?  How can I correct this?

    DB:3.11:Sql 2005 Sp2 Installation Blocked 8a

    I started a new thread to deal with the Reporting Services config issue:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1258874SiteID=1I'll mark this one as answered.  The SP2 doc should mention that Reporting Services needs to be running for the validation check to succeed.

  • RELEVANCY SCORE 3.11

    DB:3.11:Drill Down Doesnt Work Properly In Ssrs 2005 Sp2 aj


    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

    DB:3.11:Drill Down Doesnt Work Properly In Ssrs 2005 Sp2 aj

    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

  • RELEVANCY SCORE 3.11

    DB:3.11:.Net Dll Not Being Called From Ssrs 2008 f1


    I have created a .Net dll which inserts some image data to SQL server database. This assembly needs to be called from SSRS 2008 report. When called from SSRS 2008, the return from this assembly has been added to a text box which outputs #Error in report.

    The assembly has been added to GAC assembly of the system. I have also added the required configuration to following files:
    security.config
    RSPreviewPolicy.config
    rssrvpolicy.config
    The dll is giving correct results in SSRS 2005. Is there any other security configuration required to run the dll in SSRS 2008?

    DB:3.11:.Net Dll Not Being Called From Ssrs 2008 f1

    Hi virushukla,
    Based on my experience, the issue is generally caused by the incorrect configuration.
    Please make sure that:
    1. The custom code group is a child element of this element:
    CodeGroup class=FirstMatchCodeGroup version=1 PermissionSetName=FullTrust Description=This code group grants MyComputer code Execution permission.
    2. Since the assembly is deployed to GAC, the code group shoule be like this:
    CodeGroup class=UnionCodeGroup version=1 PermissionSetName=FullTrust Name=PrinterDeliveryCodeGroup Description=Code group for my delivery extension
    IMembershipCondition class=StrongNameMembershipCondition version=1 PublicKeyBlob=0024000004800000940000000602000000240000525341310004000001000100735967BD048A8E4A52777C088B8CDC80DCCA427573F4635EF3DAC1640F2B52FA0A0B6054EAD8B0B5EB0D014C9F6747B3C9E0EA0A78303676F7C59EC3EC9D2C7F6E82CA5CD9A40B838D4B9A9A674AA808294422972FA17277440FA708C544B619C2A9ACACC1D194A869485B91AC8F83340543C602884715386ED65C6EF96C0AB2
    /
    /CodeGroup
    Note: The class is StrongNameMembershipCondition.
    3. We need to configure the code security settings in both rssrvpolicy.config and rsmgrpolicy.config
    You can also post these configuration files in this thread, which will help us to resolve the issue too.
    For more information about Code Access Security in Reporting Services, please see:
    http://msdn.microsoft.com/en-us/library/ms154658.aspx
    If you have any more questions, please feel free to ask.
    Thanks,
    Jin ChenJin Chen - MSFT

  • RELEVANCY SCORE 3.09

    DB:3.09:Installing Ssrs 2005 On A Sql Server Already Installed aj


    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

    DB:3.09:Installing Ssrs 2005 On A Sql Server Already Installed aj

    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.

  • RELEVANCY SCORE 3.09

    DB:3.09:Are Pivot And Unpivot Supported In Ssrs kx


    We're upgrading from SSRS 2005 to 2008 R2. I'm rewriting some of my reports and using Unpivot. In SQL it works fine when I run it against the database. But in SSRS (BIDS 2008) when I paste the working SQL statement into the Query Builder, I get
    an error that The UNPIVOT SQL construct or statement is not supported. If i click OK and preview my report, it does run. So, I'm not sure why I'm getting this error. Has anyone had experience with this?

    Milissa Hartwell

  • RELEVANCY SCORE 3.09

    DB:3.09:Visual Studio (Bi Tools - Ssis, Ssrs) 2008 With Database Sql Server 2005 s9


    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

    DB:3.09:Visual Studio (Bi Tools - Ssis, Ssrs) 2008 With Database Sql Server 2005 s9

    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.

  • RELEVANCY SCORE 3.08

    DB:3.08:Error While Running A Report In Ssrs Using Data From Ssas Cube f8


    We have SSRS reports that get their data from a cube. When we open a predefined report or create a new report and select the same measures and dimensions
    as in the predefined report in the cube browser the following error message appears:
    The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples.

    We are developing using SQL Server 2005 SP2

    DB:3.08:Error While Running A Report In Ssrs Using Data From Ssas Cube f8

    This is the result of an internal limitation of the NON EMPTY statement in your MDX query, used to filter out non empty rows from the query. You should be able to work around it, though. Can you tell us some more details about your cube and the query you're
    using in your report?
    ChrisBlog: http://cwebbbi.spaces.live.com Consultancy: http://www.crossjoin.co.uk/

  • RELEVANCY SCORE 3.08

    DB:3.08:Ssrs 2008 On Win 2003 64 Bit R2 Sp2 Cluster And Sql 2005 64 Bit Sp3 Cu3 Cluster On The Same Box! dd


    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?

    DB:3.08:Ssrs 2008 On Win 2003 64 Bit R2 Sp2 Cluster And Sql 2005 64 Bit Sp3 Cu3 Cluster On The Same Box! dd

    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

  • RELEVANCY SCORE 3.08

    DB:3.08:No Reports Under Reporting 87


    I have installed SCOM reporting and afterwards the default reports do not show under the Reporting folder afterwards. I have unistalled and reinstalled mulitple times. I have tried diferent server and same results. I have housed SSRS
    front and backend, OPsDW db on the same server and same results. Any suggestions?
    Setup:
    SCOM 2007 R2 active/passive RMS cluster (2008 R2 OS).
    SQL 2005 SP3 (2003 Enterprise SP2 OS)backend holds the Ops DB and the OPsDW DB. SSRS (2008)DBs live here also.
    Web Console server and SSRS (2008)front end server (2008 R2 OS).

    DB:3.08:No Reports Under Reporting 87

    I haven't seen this particular error before myself, but here are a few promising sites that Bing returned when I searched on the error message:
    http://social.technet.microsoft.com/Forums/en-US/operationsmanagerdeployment/thread/47c85aff-00ed-4b01-ba3a-928a0353590e
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/357fb0ed-6b91-4d39-80f9-97b773547fbe
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/db04dd1e-8639-4c94-a01e-6b58e7d0b224
    I haven't personally followed any of these suggestions so YMMV.
    -ChrisChris Harris [MSFT] Program Manager System Center Operations Manager

  • RELEVANCY SCORE 3.08

    DB:3.08:Vertical Text Is Not Showing Properly When Exported To Excel In Ssrs 2005 Sp2 jj


    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

    DB:3.08:Vertical Text Is Not Showing Properly When Exported To Excel In Ssrs 2005 Sp2 jj


    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
     

  • RELEVANCY SCORE 3.08

    DB:3.08:Setup Sql Server 2005 Express Sp3 Failed : Blue Screen Occurred With Stop:C000021a Unknown Hard Error f9


    Hi,I formatted my PC with a new Windows XP professional sp2 and setup the 'SQL Server 2005 Express SP3' buta blue screen occurred with code 'c000021a Unknown Hard Error'.Only whenever installing 'SQL Server 2005 Express SP3' my PC stopped and go into blue screen.Any one help?sql server 2005,C++,C#

    DB:3.08:Setup Sql Server 2005 Express Sp3 Failed : Blue Screen Occurred With Stop:C000021a Unknown Hard Error f9

    I encountered the same issue after installing SQL ServerExpress 2005. Dell PowerEdge 600SC Widows XP SP2. First you will need to remove your installation of SQL Server Express. To do this reboot the machine, pressing F8 during boot to get to the Boot Menu. Select Safe Mode and continue. Login, then click start, run, and type MSCONFIG. Once the MSCONFIG window appears click the services tab.Nearthe bottom right corner of the window you will see an option to Enable All Services and Disable All Services. Click disable all, this will disable all non-essential windows services. Now scroll through the services list and find Windows Installer, put a check mark next to it (this enables Windows Installer, which will allow you to remove programs from the Add/Remove programs applet). Click OK and restart your computer. After the restart you will see a dialogue box informing you that you are running in a special configuration mode, click OK, then when the MSCONFIG window appears click Cancel. Do not put a check mark in the do not show this again box as later you do want to see it again.Your computer should boot normally. Login, click start, control panel, Add/Remove Programs, look for all SQL Express programs that were installed, starting from the bottom work your way up removing each one. You may get an error dialogue when trying to remove SQL Server Express 2005, click okay and go on. Once you have uninstalled SQL Server Express and all related installed programs. Click start, run, type MSCONFIG, click the services tab, click enable all. Click OK and restart your computer.Your computer should reboot as normal without SQL express installed. Now apply the hotfix located here http://support.microsoft.com/kb/921337the other hotfix mentioned in other responses I did not apply because the one for SP2 is no longer available, and it ended up not being necessary. Once you have installed the hotfix install SQL ServerExpress, I would avoid trying to install the whole developers package bundled with SQL Server Express Management Studio, just get throughthe basicinstallation first. Once you have successfully installed SQL Server Express, then install the Management Studio and perform any customizations you like.The above mentioned MSCONFIG method is very handy in removing any program that causes you errors after installation, as long as you can boot in Safe Mode.Enjoy!Joshua

  • RELEVANCY SCORE 3.07

    DB:3.07:Ssrs 2005 Error: Could Not Find File C:\Winnt\Temp\Mmenylgr.Dll. 3m


    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

    DB:3.07:Ssrs 2005 Error: Could Not Find File C:\Winnt\Temp\Mmenylgr.Dll. 3m

    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.

  • RELEVANCY SCORE 3.07

    DB:3.07:Sql Specifications For 2005 2008 9p


    I've experienced many limitations and problems inSSRS 2005 and I am wondering if those same limitations exist in SSRS 2008. Does anyone know ofanywhere that describe in detail the limitations/specificationsof SSRS 2005 and SSRS 2008? Thanks!Nathon Dalton
    Software Developer
    Systems Administrator
    Network Administrator
    Blog: http://nathondalton.wordpress.com

    DB:3.07:Sql Specifications For 2005 2008 9p

    Here's an example I just ran into this morning. SQL Server Reporting Services 2005 only supports Excel 97-2003 format. So, exporting to Excel only supports reports up to 256 columns. Will SSRS 2008 support exporting in Excel 2007 format, thus supporting more columns?Nathon Dalton
    Software Developer
    Systems Administrator
    Network Administrator
    Blog: http://nathondalton.wordpress.com

  • RELEVANCY SCORE 3.07

    DB:3.07:Ssrs Report Error s9


     
    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.

    DB:3.07:Ssrs Report Error s9

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

  • RELEVANCY SCORE 3.07

    DB:3.07:Edit Report (Rdl) And Import Again Into Ssrs Throws Error The Report Definition Is Not Valid. zf


    Hello,
    I edit a report on sql2005 reporting services.
    I use BIDS 2005 tomodifythe .rdl and do some changes in the layout. I save the report.
    But when I try to import the .rdl back into SSRS 2005 I get the foll error:
    The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. (rsProcessingError) (Report Services SOAP Proxy
    Source)
    This is driving me nuts !!!!
    BIDS about info are:
    Microsoft Visual Studio 2005
    Version 8.0.50727.867 (vsvista.050727-8600)
    Microsoft .NET Framework
    Version 2.0.50727 SP2
    Microsoft SQL Server 2005 - 9.00.5057.00 (X64) Mar 25 2011 13:33:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
    Grateful if anyone could please advise.
    Thank you.

    DB:3.07:Edit Report (Rdl) And Import Again Into Ssrs Throws Error The Report Definition Is Not Valid. zf

    Somehow, when I updated the report by using the web url it worked fine !!!
    1) SSRS server - Home - Folder - ...
    2) properties
    This is very strange !!

  • RELEVANCY SCORE 3.07

    DB:3.07:Installing Srs Dataconnector In A Nlb Environment 8d


    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

    DB:3.07:Installing Srs Dataconnector In A Nlb Environment 8d

    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.

  • RELEVANCY SCORE 3.06

    DB:3.06:Ssrs Instaltion 31



    dear all,

    i am having win 2008 server, was installed SQL server 2005 with visual studio 2008 team system. i am trying to install SQL server Reporting service in the same mession, i am getting follwing error message.
    can anybody help me, on this, becoz it is a production server, wanted to know in-debth how can install SSRS 2005 into mission, without destrubbing other services.
    - ASP.Net Version Registration Requirement (Warning)
    Messages
    ASP.Net Version Registration Requirement
    64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).
    regards
    Nasser

    DB:3.06:Ssrs Instaltion 31

    Hi,
    See if follwoing link can help
    http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/22e298f0-9669-4f72-8afa-d3cfa6490e17/
    -Chintak

  • RELEVANCY SCORE 3.06

    DB:3.06:Communincation Error While Connecting To Rs 7c


    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.

    DB:3.06:Communincation Error While Connecting To Rs 7c

    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

  • RELEVANCY SCORE 3.06

    DB:3.06:Need Advice On Scaling Out Ssrs 2005 j1


    I have SSRS 2005 running on W2K3. I am upgrading servers to W2K8, but staying on SQL/SSRS 2005. My SSRS database was created using standard edition, but I need to scale out to a second server. I have done some initial testing but each
    time thereports becomes unusable after I connect the second server. The error I get indicates the encryption key is missing or is invalid. I went to the first enterprise edition SSRS connected to the database and export the key, then execute
    a change from the second server. Now I get an error stating Error executing, random alpha numeric string I am obviously doing something wrong, however I have found no documentation on this process. Can someone point me in the right
    direction?

    DB:3.06:Need Advice On Scaling Out Ssrs 2005 j1

    Hi,
    Please follow
    http://technet.microsoft.com/en-us/library/ms159114.aspxon how to configure a report server scale-out deployment and
    http://technet.microsoft.com/en-us/library/ms155931.aspxon how to add encryption keys for scale-out deployment. If you have more question about this, please let us know and post the
    detailed information.
    thanks,
    Jerry

  • RELEVANCY SCORE 3.06

    DB:3.06:Can Installing Sql Server 2005 Sp2 Twice Cause Any Issues? xs


    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.

    DB:3.06:Can Installing Sql Server 2005 Sp2 Twice Cause Any Issues? xs

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

  • RELEVANCY SCORE 3.06

    DB:3.06:Cannot Install Sql 2005 Sp2, Error: Your Account Information Could Not Be Verified s9


    Hi all,
        I am running a named instance of SQL Server 2005 Enterprise Edition, side by side with named instance of SQL Server 2000 in Windows Server 2003. When I start the installation. I am unable to proceed from authentication stage.
    The error description for Database Services and Reporting Services under both sa and windows authentication mode is:  Encryption not supported on client Sqlcmd error: Microsoft SQL Native client: Client  Unable to establish connection
    In Service Manager, all SQL Server 2005 services are running with Logon as Administrator,  and I am also able to connect to SSAS, SSRS, SSIS via Management studio both via Windows authentication and sa account information.
     
    Would you please inform if I have to change any security settings before SP2 installation here.
    How to add myself a Sql Server Administrator. The link in Surface Area Configuration to Add new Administrator doesn't work.

    DB:3.06:Cannot Install Sql 2005 Sp2, Error: Your Account Information Could Not Be Verified s9

    Hi Barlo,
       Are you using a local account (Windows authentication), If so then make sure you have NT Administrator privileges while installing.  In my case I run all the services under local account. If you are doing the same, verify the type of account installed. Run Services.msc -  For all the Sql 2005 Services running - properties - log on with local account. Make sure that you are able to connect to all the services.
    Still if you face error during authentication mode, Please look at the error instructions on the third column in the table on authentication modes for list of services, after it prompts the error. e.g: Table might show that Reporting Services and Database cannot connect, since native client failed..

  • RELEVANCY SCORE 3.06

    DB:3.06:Sql 2005 Upgrade To Sql2005 Sp2 (Sbo1 2007a) f8



    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

    DB:3.06:Sql 2005 Upgrade To Sql2005 Sp2 (Sbo1 2007a) f8


    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

  • RELEVANCY SCORE 3.05

    DB:3.05:Sql Server 2005 Sp2 Support sk


    Is sql server 2005 SP2 supported on windows server 2003 SP2?

    DB:3.05:Sql Server 2005 Sp2 Support sk

    Hi,SQL 2000 SP4 is supported on Win 2003 server with SP2.  You can get sql 2000 sp4 here.SQL 2000 is not supported on Windows Vista. FYI.

  • RELEVANCY SCORE 3.05

    DB:3.05:Can Not Create Job From Sql Server 2005 With Sp2 9s


    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

    DB:3.05:Can Not Create Job From Sql Server 2005 With Sp2 9s

    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

  • RELEVANCY SCORE 3.05

    DB:3.05:Database Setup: Service Credential And Windows Credential sj


    I have just installed SSRS 2005 SP2 and I am going to configure it:the only doubt is during Database setup:for credential types there are 3 option:Service CredentialWindow credential SQL credentialI have used Windows credential by assigning a user.What is the different if I used Service credentialThank

  • RELEVANCY SCORE 3.04

    DB:3.04:Error In Migrating Wizard For Foodmart 2000 To Sql Server 2008 xk


    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

    DB:3.04:Error In Migrating Wizard For Foodmart 2000 To Sql Server 2008 xk

    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

  • RELEVANCY SCORE 3.04

    DB:3.04:Sql Server Install On A Post Sp2 Machine mj


    Today I attempted to install SQL Reporting Services on a box that only has the OLE DB driver for Analysis Services and the MSXML components; both of which are SP2.
    When running the SQL Server 2005 install to install SSRS, I get an error:
    SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
    This box has barely anything on it aside from ProClarity Analytics Server and the components I mentioned above. My only guess is that the SQL 2005 installer sees some newer components that are SP2 and it thinks they are beta? I know for sure I do not have any beta software on this machine.
    Any ideas?

    DB:3.04:Sql Server Install On A Post Sp2 Machine mj

    This box was built fairly recently and no beta software has been installed on it.

  • RELEVANCY SCORE 3.03

    DB:3.03:Ssrs 2005 Web Service Issue 13


    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

    DB:3.03:Ssrs 2005 Web Service Issue 13

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

  • RELEVANCY SCORE 3.03

    DB:3.03:Unable To Connect To Ssrs 2005 19


    Hi Sir/Mam,
    I am not able to login to SSRS. I have tried to login into the Reporting services from reporting Configuration Manager to end up in the error
    The Unknown error has occured in the WMI Provider. Error code 80070008. In hte Event Viewer an Event of Type Error, Source Rep Services(MSSQL)and ID 107 is logged with msg Report Server (MSSQLSERVER) cannot
    connect to the report server database.

    I also tried to login using SS Management Studio it gives the error The operation could not be completed. (WinMgmt) and it details as Program
    Location: at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
    at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()
    at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
    at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
    at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType
    server)
    at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser() and the same event is logged in the Event Viewer.

    So I tried to check the instances of SSRS using the wbemtest(using
    http://msdn.microsoft.com/en-us/library/dd353297%28SQL.90%29.aspx) and gave me the errorNumber:
    0x80070008 Facility: Win32 Description: Not enough storage is available to process this command

    Also I notice that the SSRS isnot being shown in the SQL Configuration Manager and the Surface configuration as well.
    OS : WIN Server 2003Standard Edition SP2
    SQL SErver 2005
    Microsoft SQL Server Reporting Services Version 9.00.1399.00

    I expect the Memory limit to be changed in the rsreportserverconfig but I am afraid. Pleaseguide me to a solution
    Thanks and Regards,
    Saideep

    DB:3.03:Unable To Connect To Ssrs 2005 19

    Hi,

    By default, Management Studio uses the Reporting Services Windows Management Instrumentation (WMI) provider to establish a connection to the report server. Based on the error messages, I think the WMI provider is not installed correctly. I recommend that you
    run Setup to repair Reporting Services, or reinstall Reporting Services.

    For more information about WMI error when connecting to a report server in Management Studio, please see:

    http://msdn.microsoft.com/en-us/library/ms156468.aspx

    Thanks,
    Ai-Hua QiuAi-hua Qiu[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.

  • RELEVANCY SCORE 3.02

    DB:3.02:Integrating Sql 2005 Ssrs With Moss: Set Up Question 9s


    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!

    DB:3.02:Integrating Sql 2005 Ssrs With Moss: Set Up Question 9s

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

  • RELEVANCY SCORE 3.02

    DB:3.02:Ssrs Error Code 7403 After Moving To Sql 2008 R2 fm


    Hello all.
    Environment is single site running SCCM SP2 R2 on Server 2003 (virtual) with SQL database on separate server.
    I migrated the SCCM database and reporting services from SQL 2005 to SQL 2008 R2. Now, I keep getting an error once an hour in the SMS_SRS_REPORTING_POINT under site system status stating SMS SRS web service is not running on SRS Reporting point server
    XXXX.
    Everything works fine, I just cannot seem to get rid of this error 7403, and searching for a solution on the web has not provided a solution. I am guessing that it is looking for IIS on my SQL 2008 R2 server, but of course that is not installed since
    2008 SRS doesnt require IIS anymore.
    Any ideas on a solution so I can get back to green status?

    DB:3.02:Ssrs Error Code 7403 After Moving To Sql 2008 R2 fm

    Hi,
    Now the CU4 for SQL Server 2008 R2 fix the error 7403
    http://support.microsoft.com/kb/2345451/en-us

  • RELEVANCY SCORE 3.02

    DB:3.02:Problem Browsing Localhost/Reportserver$ 3k


    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

    DB:3.02:Problem Browsing Localhost/Reportserver$ 3k

    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

  • RELEVANCY SCORE 3.02

    DB:3.02:Tfs 2008 - Create Project Issues zf


    I'm currently running into some problems creating a new team project in TFS 2008, and having browsed the posts here, my situation seems a little different than the others already answered.
    Some background info:
    - We're running a separate Application Tier and Data Tier installation
    - We're running TFS 2008 SP1, and I've verified that Visual Studio SP1 was re-applied after the installation of Team Explorer
    - At one point we lost our Application Tier due to a hardware failure, and this is a re-install/restore situation, so I'd be willing to bet that there are some things amiss there.

    At any rate, when creating a project I receive the infamous Insufficient permissions to create a new SQL Server Reporting Services at server message. The thing that worries me is that it's inserting the AT server name in this message, rather than
    the DT server name. SSRS is installed on the DT, not the AT in our environment, and all of the configs I see check out that for any reporting service data should be pointing to the DT.

    The 2008 BPA gives me 7 errors:
    4x - Web service failures contacting SSRS on the DT -The remote server returned an error: (401) Unauthorized.
    1x - SQL Server and SSRS Versions do not match - I've verified that all SQL installations involved are running SQL 2005 SP2,so this message is puzzling
    1x - tfsservice account does not have Content Manager rights in SSRS - I've verified that it does,so this message is puzzling
    1x - tfsservice account does not have System Administrator permissionsin SSRS - I've verified that it does,so this message is puzzling

    Any thoughts? I'll copy/paste the actual create project log in a subsequent post here

  • RELEVANCY SCORE 3.02

    DB:3.02:Can I Set Email For Failures For Subcriptions (Scheduled Reports) In Sql Server 2005 zm


    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.

    DB:3.02:Can I Set Email For Failures For Subcriptions (Scheduled Reports) In Sql Server 2005 zm

    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

  • RELEVANCY SCORE 3.02

    DB:3.02:Error In Creating Reporting Services Based Report In Pps Dashboard. mc


    Hello all, I am trying to create a report in PPS 2007 based on an existing SSRS report but getting error Unable exceptions has occurred in your application. Could not load file or assembly 'Microsoft.ReportViewer.WinForms,Version=9.0.0.0.0, Culture=neutral,PUblicKeyToken=b03f57f11d50a3a' or one of its dependencies. The system cannot find the file specified.  I tried installing Microsoft Report Viewer Redistributable 2005 but it doesn't seem to be working. Here is the configuration on server Windows Server 2003 SP2 SQL Server 2005, Analysis, reporting, integration services What may be causing this issue? Thanks in advance.

  • RELEVANCY SCORE 3.01

    DB:3.01:Is Sql Server 2005 Ssrs Still Working With The Error The Report Server Cannot Decrypt The Symmetric Key? as


    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.

    DB:3.01:Is Sql Server 2005 Ssrs Still Working With The Error The Report Server Cannot Decrypt The Symmetric Key? as

    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.

  • RELEVANCY SCORE 3.01

    DB:3.01:Upgrade From Sql Server 2005 To Sql Server 2008 From Sharepoint 2007 Ssrs 2005 Integrated Mode za


    Im attempting to upgrade from SQL Server 2005 to SQL Server 2008 R2 x64 Enterprise on a server running Windows Server 2003 x64Enterprise,SharePoint 2007 Enterprise, and SQL Server 2005 and SSRS 2005 Enterprise running in integrated mode.
    I installed the Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies from here:

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=35c3a13f-4b5e-4d4a-86e4-07ee307b9638displaylang=en.
    When attempting to install Report Builder 2.0, I get the error Reporting Services Add-in for SharePoint products and technologies is not installed.
    When I try to run a report (existing 2005 reports already deployed), I get the error: Operation is not valid due to the current state of the object. The log has repeating ReportingServicesService.exe errors: #20015: Cannot open Resources.en-US.resx:
    no such file or folder, and: Localized resource for token 'ManageDatasetCaching_Desc' could not be found for file with path: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Features\ReportServer\ItemCustomActions\ecbExtension.xml
    among other things.
    I've tried reconfiguring Reporting Services in SharePoint admin and deactivating/activating the report server feature on the site collection.
    We have hundreds of reports. Will they all have to be manually upgraded to work with 2008 R2 in integrated mode with SharePoint 2007?

    DB:3.01:Upgrade From Sql Server 2005 To Sql Server 2008 From Sharepoint 2007 Ssrs 2005 Integrated Mode za

    After further testing: some reports worked and some didn't. Re-deploying and reconnecting the data connections seems to have fixed the ones that were broken.

  • RELEVANCY SCORE 3.01

    DB:3.01:Trying To Install Ocs 2007 Standard Eval 83


    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. 
     

    DB:3.01:Trying To Install Ocs 2007 Standard Eval 83

     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/

  • RELEVANCY SCORE 3.00

    DB:3.00:Sql 2005/Sp2 Supported ? zd


    Hi,
     
    Is SQL 2005 SP2 officially supported for use with FCS ?
    Chris

    DB:3.00:Sql 2005/Sp2 Supported ? zd

    Hi Chris
    Yes, SQL 2005/SP2 is officially supported - thanks!
     
    Thanks
    Chris
    Forefront Client Security PM

  • RELEVANCY SCORE 3.00

    DB:3.00:Client:Windows 7(64 Bit), 32bit Ie,Server: Ssrs 2005 Sp2 33


    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.

    DB:3.00:Client:Windows 7(64 Bit), 32bit Ie,Server: Ssrs 2005 Sp2 33


    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.

  • RELEVANCY SCORE 3.00

    DB:3.00:Ssrs 2012 Rendering Issue/Enabling Anonymous Access - Upgraded Ssrs From Sql 2005 To Sql 2012. 7f


    Hi,
    I just recently upgraded SQL 2005 SSRS to SQL 2012 SSRS. Everything is working great other than small issue.
    Sounds like some authentication issue. SQL 2005 SSRS - IIS, we enabled anonymous access and we never hadthis problem. SQL 2012 SSRS /WIN 2008 R2 - I am not sure how to enable anonymous access.

    If anyone can help me on this? I really appreciate your help.
    Thanks,
    Vel

    Vel Thavasi

    DB:3.00:Ssrs 2012 Rendering Issue/Enabling Anonymous Access - Upgraded Ssrs From Sql 2005 To Sql 2012. 7f

    Hi Vel,
    According your description, you want to know how the enable anonymous access to SSRS 2012. Right?
    In SSRS 2008 or later version, we are not using IIS any more. If we want to configure the authentication, we need to configure in RSReportServer.config. This file locate at:
    drive:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer
    However, in SSRS 2012, Anonymous authentication is not supported on report server. Please see:
    Authentication with the Report Server
    In this scenario, we need to custom an authentication type to achieve the Anonymous goal. Please refer to the link:
    Configure Custom or Forms Authentication on the Report Server
    If you have any question, please feel free to ask.
    Best Regards,
    Simon Hou

  • RELEVANCY SCORE 3.00

    DB:3.00:Configuring Sharepoint With Sql 2005 Cluster p1


    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

    DB:3.00:Configuring Sharepoint With Sql 2005 Cluster p1

    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

  • RELEVANCY SCORE 3.00

    DB:3.00:Ssrs 2005: Point Ssrs 2005 Sp3 To Sql 2008 Sp1+Cu4 Ssrs Metabase m8


    I have my ssrs 2005 SP3 web server pointing to a SQL Server 2008 SP1CU4 for its metadatabase ReportServer and ReportServerTemp. (For now, assume I have a valid reason why my SSRS is not on 2008).
    I have a web app that calls the reportserver/ web services to render reports for end user.
    Everything works fine - except that sometimes - my users get a timeout error. When I go to the ssrs log, I see:
    Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report
    server database. A connection to the database is required for all requests and processing., ;
    Then I noticed that ifi manually browse the report manager and run a report, then the timeout goes away and my web service call to render the report starts working all over again...until later when this happens again. This happens intermintelly
    so it's been hard to troubleshoot.
    Does SSRS 2005 SP3 suppot a SQL 2008 Report Server DB? it seems like it does because this works fine otherwise.
    Thoughts?
    Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException

    DB:3.00:Ssrs 2005: Point Ssrs 2005 Sp3 To Sql 2008 Sp1+Cu4 Ssrs Metabase m8

    Hi edgarsanchez40,
    First, it is sure we can storeSQL Server Reporting Services 2005 catalog databases in SQL Server 2008.
    The error message you posted means the Report Server can't connect to the report server database. Generally, it can be caused by network issue, SQL Server database engine issue or Reporting Services configuration issue(e.g. service account has insufficient
    privilege to access the database engine, encryption key is corrupt).
    In this case, the most likely cause should be network issue or SQL Server database engine issue, as you are able to connect the database about all the time. The issue happens intermintelly.
    To verify and solve the issue, please follow these steps:
    1. Please check if there is any error regarding network in the System logs from the Report Server machine.
    2. Check the DNS/DHCP settings, make sure there is no potential cause that cause the issue. For example, the DNS record redirect users to incorrect server.
    3. Please check if there is any error in the SQL Server error logs from the SQL Server machine. If so, please post the error message.
    4. Using Network Monitor to monitor the network activities in SQL Server mahicne till the issue happen.
    Alternatively, once the issue happens, please try using SQL Server Managerment Studio to connect to the SQL Server from another client. If we are not able to connect to it, we can verify this is a network or database engine issue. Then follow the steps we
    described before to find the root cause.
    If there is anything unclear, please feel free to ask.
    Thanks,
    Jin Chen

    Jin Chen - MSFT

  • RELEVANCY SCORE 3.00

    DB:3.00:Ssrs Reporting Service 2005 Is Not Starting On Windows 7 89


    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

    DB:3.00:Ssrs Reporting Service 2005 Is Not Starting On Windows 7 89


    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

  • RELEVANCY SCORE 3.00

    DB:3.00:Running Ssrs 2005 With Sql Server 2008 13


    We have a SSRS 2005environment already in place. The metadata of SSRS 2005 is managed on SQL Server 2005. For a new application we are thinking of using SQL Server 2008 standard edition as the backend database.We want todevelop reports
    for this application in SSRS 2005 and deploy this to our existing SSRS 2005 environment. Can the reports use the new SQL server 2008 as backend

    database for getting data?skbar

    DB:3.00:Running Ssrs 2005 With Sql Server 2008 13

    Hello,
    Yes, of coursethat's possible to get data from SQL Server 2008/2008R2 and it's also possible to host the ReportServer repository database on 2008.Olaf Helper
    * cogito ergo sum * errare humanum est * quote erat demonstrandum *
    Wenn ich denke, ist das ein Fehler und das beweise ich täglich
    Blog
    Xing

  • RELEVANCY SCORE 3.00

    DB:3.00:Bids 2005 Service Pack Update cm


    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

    DB:3.00:Bids 2005 Service Pack Update cm

    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

  • RELEVANCY SCORE 3.00

    DB:3.00:Ssrs 2005 Cant Create Or Edit A Named Query Against A Sql 2008 R2 Database (This Server Version Is Not Supported. You Must Have Sql Server 2005 Beta 2 Or Later) 8a


    The situationinvolves SSRS 2005 on the front end and SQL 2008 R2 databases on the backend. For a number of years we had SSRS 2005 on the front end and SQL 2005 on the backend, but the backend database platform has been upgraded recently to SQL 2008
    R2. As a result,we can no longer add or edit Named Queries within the SSRS 2005 Data Source Views. A dialogue comes up now with the following error- This server version is not supported. You must have SQL Server 2005 Beta 2 or later.

    It obviously can't deal with the newer SQL Server 2008 R2 databases gracefully, so is there a work around for this? We're planning to upgrade/migrate the front end to SSRS 2008 R2 (or SSRS 2012) later this year, but we still need to work with what
    we have in the meantime.Thanks in advance.

    Bill Thacker

    DB:3.00:Ssrs 2005 Cant Create Or Edit A Named Query Against A Sql 2008 R2 Database (This Server Version Is Not Supported. You Must Have Sql Server 2005 Beta 2 Or Later) 8a

    I was able to find a workaround. This problem (for me) only affected certain datasets. However, I was still able to go into the edit dataset and see details about the query and any parameters. I copied the queryparameters out, deleted the old dataset,
    created a new one with the same name, copied the query and parameters back in, fixed one or two problems with field names being wrong, and it worked.

  • RELEVANCY SCORE 3.00

    DB:3.00:Completly Remove Ssrs 2005 From The Server f3


    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)

    DB:3.00:Completly Remove Ssrs 2005 From The Server f3

    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.

  • RELEVANCY SCORE 2.99

    DB:2.99:How Do I Get Ssrs 2005 Sp3 Cu5 Working In Sharepoint Integrated Mode, With Multiple Wfes? p9


    Hi,I've succesfully installed SSRS2005 into my dev SharePoint environment (dual server: 1 - MOSS, 2 - SQL), by installing on the MOSS server in Integrated mode. Had some fun with Kerberos, but got it all working happily in the end.Our production and test environments use three servers and I'm struggling to get SSRS working in that environment.I can't seem to locate any documentation about installing into this kind of farm (they all assume single server style, or installing SSRS onto it's own server).So this is what I've done:Myfarm consists of three servers:Server 1 - SQL2005 SP2 on server 2003 sp2 x86Server 2 - MOSS2007 SP2 Ent on server 2003 sp2 x86 (Central Admin, SSP, MySites, Index and Query)Server 3 - MOSS2007 SP2 Ent on server 2003 sp2 x86 (Main Content)

    I've installed SSRS2005 SP3 CU 5 onto both MOSS servers
    I've configured up SSRS on both servers, completing Server 2 first.I've tried giving SSRS it's own URL/port and sharing a URL/port with MOSS (e.g. http://servername:82/ReportServer vs http://servername/ReportServer)
    I've installed the SSRS Sarepoint add-in onto both servers
    I've configured the SSRS bits in Central Admin
    I've created a new site collection, using the Enterprise | Report Centre template
    I've activated the Reporting Site Collection Feature

    But the SSRS related content types don't appear in the appropriate lists (e.g. "Report Data Source" in Data Connections), which means I can't upload/publish any data connections, models or reports.Anyone got any ideas?

    DB:2.99:How Do I Get Ssrs 2005 Sp3 Cu5 Working In Sharepoint Integrated Mode, With Multiple Wfes? p9

    Excellent! Thanks Eric!  This appeared to have happened automatically in my dev environment, but this manual method has worked a treat!

  • RELEVANCY SCORE 2.99

    DB:2.99:Error 1603 Installing Microsoft Sql Server 2005 Setup Support Files xp


    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. 

  • RELEVANCY SCORE 2.98

    DB:2.98:Ssrs 2012 Error- Service Unvailable. 3d


    We have upgrade the Sql server 2005 to SQL server 2012. We are trying to connect SQL Server reports2012. we are getting the below error.
    Service Unavailable.
    HTTP Error 503. The service is unavailable.

    Thaks
    Srini

    DB:2.98:Ssrs 2012 Error- Service Unvailable. 3d

    Hi Srini,
    For HTTP 503 errors that occur when you first open Report Manager or access a report server, you must review the HTTP.SYS log file for information about what is causing the error. By default, HTTP.SYS logging is not enabled. For the detail information, please
    see:
    HTTP 503 Service is Unavailable
    Hope this helps.
    Regards,Charlie Liao
    TechNet Community Support

  • RELEVANCY SCORE 2.98

    DB:2.98:Unble To Load Print Conrol Error When Client Click On Print Button In Ssrs Report cd


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

    DB:2.98:Unble To Load Print Conrol Error When Client Click On Print Button In Ssrs Report cd

    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

  • RELEVANCY SCORE 2.98

    DB:2.98:Ssrs 2005 And Ssrs 2008r2 mm


    Bonjour!
    I need to keep my SSRS 2005 for some reports. But I'm moving some database to SQL Server 2008R2. My SSRS 2005his on a Web Server and the database is on another server, can I install SSRS 2008 R2 on the same web server?
    Regards, Joel :)

    DB:2.98:Ssrs 2005 And Ssrs 2008r2 mm

    Thanks guys I appreciate your response.
    JoeL :)

  • RELEVANCY SCORE 2.98

    DB:2.98:503 Issue When Access Ssrs Report Builder Via Moss 2007 7x



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

    DB:2.98:503 Issue When Access Ssrs Report Builder Via Moss 2007 7x

    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.

  • RELEVANCY SCORE 2.97

    DB:2.97:Ssrs Reports(Sql Server 2005) ca



    Hi,
    This is sahu i have a small doubt in sql server (ssrs reports)
    i am excecuted the report page the error was displayed this is the error
    (The item '/AwesReports/Reporttrancforcertificate' cannot be found. (rsItemNotFound))
    what it means
    Thank you

    DB:2.97:Ssrs Reports(Sql Server 2005) ca

    Uhhh one more thread,
    http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/8bd4e06a-ac43-4fb1-8f9f-135b89ceb796

    Thats very much bad.Please do let us know your feedback. Thank You - KG, MCTS

  • RELEVANCY SCORE 2.97

    DB:2.97:Ssrs - Calling Webservice Using Xml Data Loader 71


    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.

    DB:2.97:Ssrs - Calling Webservice Using Xml Data Loader 71

    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

  • RELEVANCY SCORE 2.97

    DB:2.97:Installation Of Sql 2005 Express Error j3


    while installing SQL 2005 Express edition on Windows 2003 server sp2, i get the following error
    TITLE: Microsoft SQL Server 2005 Setup------------------------------
    The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine MILES Error:2148007941 (0x80080005).
    For help, click: http://go.microsoft.com/fwlink?LinkID=20476ProdName=Microsoft+SQL+ServerProdVer=9.00.4035.00EvtSrc=setup.rllEvtID=70342
    ------------------------------BUTTONS:
    OK------------------------------what is this WMI configuration
    biju

    DB:2.97:Installation Of Sql 2005 Express Error j3

    This isn't a problem with the forums, post it instead to a SQL Server 2005 Express forum.Ask here for where one is.http://social.technet.microsoft.com/Forums/en-US/whatforum/threads/WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx

  • RELEVANCY SCORE 2.97

    DB:2.97:Multiple Column Report In Ssrs 2008 ks


    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

    DB:2.97:Multiple Column Report In Ssrs 2008 ks

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

  • RELEVANCY SCORE 2.97

    DB:2.97:Rendering To Pdf - Ssrs 2005 xp


    Hello,I'm having a problem with rendering a specific report to PDF. The report executes fine in HTML, even sometimes in PDF, but for some reason it occassionally doesn't render to PDF. The report contains 2 subreports and 3 tables. I'm getting this error at the server: Server error in '/Reports' application. Object reference not set to an instance of an object. The used version of SQL Server is SQL Server 2005 Standard Edition SP2.Is anyone familiar with this problem?Thanks in advance.

    DB:2.97:Rendering To Pdf - Ssrs 2005 xp

    Yes Thomas,exactly that hapens ,when some component does not fit to the space provided then it does not render properly and it thows the exception error saying object refernce has not been set.And some times the same hapens when you are refering through any report items, and the control is not able to fetch the same then also it throws the same error.More over there is no direct solution for the same,we have to just try and fix the same.Thanks,Mahasweta Mahasweta das

  • RELEVANCY SCORE 2.97

    DB:2.97:Ssrs 2008 And Hyperion Essbase 9.3.1 pp


    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

    DB:2.97:Ssrs 2008 And Hyperion Essbase 9.3.1 pp

    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

  • RELEVANCY SCORE 2.96

    DB:2.96:Cannot Open An Ssrs Project (That Was Developed In 2005 Std. Edition) In 2005 Developer Edition mk


    I have a need to set up a data-driven subscription. This feature is not available in SQL Server 2005 Standard Edition. It is available in SQL Server 2005Developer edition.removed/Installed the following in this order on my cpu:installed XP svc. pack 3 (from MS web site)installed .net 3.5 (from MS web site)removed SQL Server 2005 std. editioninstalled SQL Server 2005developer edition (from MS licensing cd dated 12/2005)installed SQL Server 2005 svc. pack 2 (from MS licensing cd dated 5/2007)opened BIDS (Visual Studio 2005 version 8.0.50727.762 sp2)opened existing projectreceived the following error message:The application for project full network path and file name.rptproj is not installed.Make sure the application for the project type (.rptproj) is installed.I have tried a few of the suggestions I have found on the web with no success.This is my third day of lost productivity. Thanks MicrosoftAny suggestions?

    DB:2.96:Cannot Open An Ssrs Project (That Was Developed In 2005 Std. Edition) In 2005 Developer Edition mk

    Hi Goldentoe,Welcome to MSDN forums.Some clarification with you:Did youopen the SSRS project with BIDS 2005?You can go to Start menu All Programs Microsoft SQL Server 2005 SQL Server Business Intelligence Development Studio. Then open the SSRS project via BIDS.By default, BIDS feature is supported both in SQL Server 2005 Standard Edition and Development Edition.Please check: http://msdn.microsoft.com/en-us/library/ms143761%28SQL.90%29.aspxSo, the SSRS project should be opened.If the SSRS project cannot be opened via BIDS,I would suggest you touninstall and reinstall BIDS to fix corruptions in BIDS.You can follow the steps mentioned in the following thread to reinstall BIDS:http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/5cb86221-f5cb-4ce1-ab9e-dd4f298c11a7(Please check my reply)Hope this helps! If you have any concern, please feel free to let me know.Best regards,Yichun ChenPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

  • RELEVANCY SCORE 2.96

    DB:2.96:Connection Error While Deploying The Report d8


    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.

    DB:2.96:Connection Error While Deploying The Report d8

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

  • RELEVANCY SCORE 2.96

    DB:2.96:Upgrade From Ssrs 2005 To 2008 d1


    Currently my database is sql 2005 and im using ssrs 2005. Now i want to used ssrs 2008, so i think i need to upgrade database to sql 2008 so that i can use ssrs 2008.
    so then how do we take care of upgrading from 2005 to 2008 ??
    Because existing all the reports and database is in SQL 2005.
    Please guide me.
    Regards,
    AKM

    DB:2.96:Upgrade From Ssrs 2005 To 2008 d1

    L E Computing have just released software that will batch all your ssrs reports, check which will upgrade, and which will fail. It also checks any Dundas components.
    Errors with schema or not well formed XML will be reported with locations of the error
    One click to upgrade.
    Works on 2000 2005 2008
    Demo available @ www.lecomputing.com

  • RELEVANCY SCORE 2.96

    DB:2.96:Rownumber Throws Error In Rb2 When Reporting Against Sql 2005 Database 3j


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

    DB:2.96:Rownumber Throws Error In Rb2 When Reporting Against Sql 2005 Database 3j

    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.

  • RELEVANCY SCORE 2.96

    DB:2.96:Is It Possible To Have Both Instances Of Ssrs 2005 And Ssrs 2008 Running On Same Server (Both Using Sql Server 2005)? dj


    I am currently using SSRS 2005 and SQL server 2005.
    I'd like to install SSRS 2008 to test some of the new features still using SQL server 2005. But in the meatime I still want to be able to use SSRS 2005...
    Question: is it possible to have bothversions of SSRS 2005 and SSRS 2008 simultaneously installed and running on the same machine? Is-there any precaution to take care?
    Thanks in advance
    jpa