RE: Database Engine Tuning Advisor

In this case I am using an account that has sys admin rights. I have tried
both with my domain account which is in the sys admin group and with the sa
account.

I have tried with both 2005 and 2008.

I have uninstalled and reinstalled 2005 with dev and standard versions,
latest available download from MSDN site, 3 times and each time with the same
result:

Database Engine Tuning Advisor
Failed to open a new connection.
Additional information:
Could not find stored procedure 'msdb..sp_DTA_help_session'. (Microsoft SQL
Server.Error:2812)

I have installed the latest service packs as well.

I am attempting to run this on a 64bit machine with XP 64bit installed. I am
running the 64 bit version of SQL 2005. I have the exact same issue on my
laptop. If i look at the tables and stored procs in MSDB I can see that they
are indeed missing.

I was able to install SQL to Server 2003 and use the tool but need to do so
from my workstation.
It appears that if I script the tables and stored procedures created in MSDB
when run for the first time from the server installation that is working and
run that against MSDB on my workstation that the tool works correctly. But I
would like to know why it is failing to work properly on my workstation.
Searching for the resolution to this issue revealed that many other users are
having the same issue.
--
Regards,
James M


"Mark Han[MSFT]" wrote:

Hi James,

Thank you for using the Microsoft MSDN Managed Newsgroup. My name is Mark
Han. I am delighted to work with you on this issue.

From your description, I understand that we failed to use Database Engine
Tuning Advisor to connect to SQL server database.
If I have misunderstood, please let me know.

Based on the current situation, it seems to be a known issue. The cause of
the issue seems to be the DTAEngine not able to initialize MSDB tables when
user is not a sys admin. To work around, we need to log in as sysadmin when
launching DTA for the first time.

Besides, if the above doesn't resolve the issue, the issue might be related
to the version of the SQL Server. are you using RTM or SQL 2005 sp2 version?

Besides, You may experience problems if you use a pre-June Community
Technology Preview (CTP) version of Microsoft SQL Server 2005 Database
Tuning Advisor (DTA) client to tune Microsoft SQL Server 2000 or pre-June
CTP versions of SQL Server 2005. There is an article to share with
you:http://support.microsoft.com/kb/899634.

Hope the above helpful.

If there are any additional questions or concerns, please let me know.

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


.

Relevant Pages

  • RE: Configuration parameter in SQL database
    ... Welcome to Microsoft Newsgroup Support Service! ... how to store&return the configuration ... SQL Server + SQL Dependency Cache ...
    (microsoft.public.dotnet.general)
  • RE: Connecting remotely through VPN
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... TCP port is listening by your SQL Server. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • Re: Writing a Decimal to SqlServer loses the fraction
    ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server Express 2005 stopped working--urgent
    ... Microsoft SQL Server Management Studio Express ... may want to attach the database files you found to this new instance. ... Microsoft Product Support Services so that a dedicated Support Professional ...
    (microsoft.public.sqlserver.setup)
  • *How MSFT *Deliberately, Arrogantly, Egregiously, and Totally* Fails to Support their Products*
    ... this support into the ground. ... Microsoft, particularly developers, as well as those who don't will become ... who adapted MSDE 2000 to Buggy BCM Version 1--aprimitive Beta in a package. ... Support you have ceded to incompetent Convergys. ...
    (microsoft.public.windowsxp.help_and_support)
Loading