.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

2008 R2 Tuning Advisor reports "Error: Exception encountered(DTAEngine)"

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I am encountering an error when I try to use the SQL 2008 R2 Database Engine Tuning Advisor. I create a very simple workload (either by right-clicking a query in SSMS or by loading a file), and click Start Analysis.  In the "Consuming Workload" step DTA aborts, and in the message column displays "Error: Exception Encountered(DTAEngine)". When I click on the error message, I get a dialog box with a title of DTAEngine, and a message "Error: Exception encountered". This is a clean test environment (SQL 2008 R2 Data Center Edition 64-bit, on Windows Server 2008 R2 64-bit, in a VM) against a local database. Any ideas about what the problem is or how to resolve it? See below for detailed version information: 10.50.1600.1 RTM Data Center Edition (64-bit) Database Engine Tuning Advisor      10.50.1600.1 Microsoft Data Access Components (MDAC)      6.1.7600.16385 Microsoft MSXML      3.0 6.0 Microsoft Internet Explorer      8.0.7600.16385 Microsoft .NET Framework      2.0.50727.4952 Operating System      6.1.7600    

View Complete Post

More Related Resource Links

Business Intelligence Reports Project in Visual studio 2008 ?



I wonder how to add a project template called  Intelligence Reports, something like that, to Visual studio 2008. I have SQL 2008 installed. Do I need to install some updates to get Intelligence Reports template to Visual studio 2008 ?

Thank you..

Schedule reports with integrated authentication SSRS 2008

Hi All,  Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be hones

SSRS 2008 SP1 - Enabling "My Reports" allows users delete reports in folders they should not be able

Issue: Users that have “My Reports” SSRS Role assigned to them can delete reports in other “shared” folders. My understanding was that they will be able to do the tasks specified only  in the “My Reports” workspace not everywhere. I have “My Reports” enabled via SSMS. Users have “My Reports” role assigned to them at the root level. My SSRS Role “My Reports” has only the following tasks assigned: 1.       View Reports 2.       Manage reports 3.       View Folders 4.       Manage Folders To test, I'm using Development version of SQL Server 2008 SP1. Thanks in advance, Martina

Reports are not showing on management studio for SQL 2008 reporting services

I just did the side by side upgrade for reproting server from 2005 to 2008 and everything was fine. But when I login to the reporting server from management studio I am not able to see the report server folders like we do in SQL 2005. The only think i saw is jobs, security and shared schedules. I dont even see any jobs under this jobs folder. Do i need to do anything after the upgrade to be able to see the reports, subscriptions and data sources from the management studio? please let me know. Thanks!  kp

Where are the 2008 SSRS sample reports?

All the CodePlex 2008 links now go to the 2008R2 examples. Are the 2008 report samples still around somewhere?

sql server 2000 to SQL Server 2008 in place upgrade -- Upgrade advisor help

Hello Every body Please advise me the steps i am following are correct I need to improve some more... I want upgrade from sql server 2000 to SQL Server 2008, Plese confirm the steps 1.Setup Test SQL Server 2000 similar to Production SQLServer 2000. 2.Setup other server with SQL Server 2008. 3.Install the Upgrade advisor in SQL Server 2008 system 4.Select the  Play back(under "sql server 2000 server") in Upgrade advisor tool  and fill the SQL Server2000 Server name and authontication. 5.Click on Capture play back(take the all the backups run some top 10 queries or application on top of SQL server 2000) 6.Please in shared drive(whcih can access by the SQL Server 2008 server) 7.Now click the "setup the test server" 8.Now click the upgrade test server 2008.. 9.camapre the trace files 10.View the Trace files differance. some body help me and plese confirm those steps are correct...I am in right direction..SNIVAS


Hi All, Yesterday we installed SQLSERVER 2008 R2 in our development mechine , and already it have Microsoft TFS 2008. When i open my report project it came up with the upgrade messagebox i clicked on Yes.And i try to run the reports locally its giving me exception like "An attempt has been made to  use the data extention 'custom datasource extention 1.2' that is eaither not registered for this report server or is not supported in this edition of reporting services'.So i did the changes like adding the dlls into the reportserver bin and added the data block which i have configured for SSRS 2008 i have applied the same setting for the SSRS 2008 R2 but still i am gettign the same exception do we need to do any changes in SSRS 2008 R2. because i am able to run the reports sucessuflly in SSRS 2008 but not SSRS 2008 R2? Any body have ideas on this. Thanks, Veeren.

SSRS 2008- redirect to /Reports virtual directory?

We have just configured a new SQL Server Reporting Services 2008 server. So far, everything is going well, with the exception of one thing: we want anyone who hits the root of the webserver to be redirected to the /Reports virtual directory. So, if the user enters http://servername.domain.com/ it would redirect to http://servername.domain.com/reports. In SSRS 2005, it was easy to configure IIS to do this, but with SSRS 2008, I cannot figure out how to make this change. Help?

"Load Report failed " after migration of VS 2008 to VS2010 with SAP crystal reports installed

i have migrated VS 2008 application in VS2010  including crystal report. i have installed SAP crystal reports to support  crystal reports in VS 2010. how can i migrate the old reports into SAP crystal reports please suggest me.

Are there workarounds for SSRS 2008 Reports that have issues in SSRS 2008 R2

We have some SSRS 2008 reports which have a few issues in SSRS 2008 R2: - Page Numbering: Our reports use [PageNumber] of [TotalPages] however, in R2 [Total Pages] only relates to a particular section.  Do we really need to update every single report in design mode to use [OverallTotalPages]?  Is there a workaround? - Report Rendering: Each page of a report is only rendered when each new page of the report is requested.  How do we prevent this is R2? - Missing Data: If we run a report that should have 50 pages of data, not all pages are shown when viewing the report.  For example, only 2 pages might show.  However, if we export to PDF the whole 50 pages are exported.  Does anyone know why this is happening? Looking for patches, workarounds, etc.  Hoping that we don't need to upgrade desktops to R2 and edit hundreds of reports to fix these issues. Thanks, Howie999

SSRS 2008 Against OLAP Cube reports rendering slow in IE 6 and IE8

We have SSAS cube built on SQL Server 2008 that has multiple parameters that have a default vault on running of all. The first time we run the report it renders the report in less than 30 seconds, but when we change one value on the data cube pull the reports can take up to 5 mins to run. If I do the same report in Firefox 3.6 it renders the report in 30 seconds. I have change changing the cache size in the IE explorer and ave the latest .net frame work on the computer. What would be causing this issue? The company upgrade from SSRS, SSIS, SSAS, SQL 2005 to 2008. Please advice, this is very annoying for our business end users.   Thanks for your help in advance.

OK to uninstall microsoft sql server 2008 r2 upgrade advisor?

After upgrading to microsoft sql server 2008 r2, is it OK to uninstall microsoft sql server 2008 r2 upgrade advisor and microsoft  sql server 2008 r2 setup support files?

Win server 2003+ Sharepoint 2007+SQL Server 2008 ,reports view issue?


I hope someone may shed some light on a serious obstacle encountered on a client site:

We have implemented a SharePoint integrated report services solution for the client on a single server

Server = Windows 2003

SQL = 2008

MOSS 2007

Web application = servername:8888 (default) - windows auth

Web application extension 1 servername:8889 (extranet) forms auth

Web application extension 2 servername:8887 (intranet) forms auth

Reports are visible and can be run (renders) on internal sites

However, there is an external site which allows users to access the reports - the issue is, the reports then dont run and I get this:

"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode."

Though I have not actually seen the firewall config of the AAM, the client assures me it has been setup properly.

If the AAM is setup correctly, what could be the problem? The server is clearly available and confgured in SharePoint integrated mode.


has anyone experienced the scenario where clients want to publish their reports on an external site? What can one do to see any errors other than the one line message (tried enabling custom errors, but no good)

does the sql server 2008 R2 support movable columns in a tablix (in Reports)



is there a way to build a report with a tablix and let the columns movable for the users?
from another post i figured out, that this feature is not supported in sql server 2008.
is it featured in  2008 R2 or in 2010? :)

thanks Johnny


Need RSClientPrint.dll help for printing from both SQL 2005 & 2008 RS Reports

We recently upgraded our sharepoint environment to SQL 2008 and migrated SQL Reporting Services from 2005 to SSRS 2008. I worked with our Citrix admin to roll out the RSClientPrint.cab files to all of our 90+ Citrix servers so that the SQL reports could be printed. I tested printing 2008 reports from citrix servers with success, but now am having issues printing reports on other SQL 2005 RS instances. Is the SSRS 2008 RSClientPrint.dll not backwards compatible with SSRS 2005? Is there any way around this?

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008


Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.

1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

3) Also one more point about the s

Deploying SSRS Reports from Visual Studio 2010 to Report Manager 2008


Our Report server is using Report Manager 2008. Previously I would load reports to it that I created via BIDS. Now I have to use VS 2010. I see that I can build and deploy reports there. Can I send it from VS 2010 to the REport manager 2008 on the other machine? I should add that now i have to develop on laptop only before i was on the server.

If not what are my options? I recall that vs 2005 objects were not taken in Report manager 2008.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend