I am trying to use the Database Engine Tuning Advisor. I have the developer
edition of SQL2005 and SQL2008 installed with several databases on each. I
ahve experienced no issues with anything I have tried to do until I attempted
to run the Database Engine Tuning Advisor.

When I start the Database Engine Tuning Advisor for either version of SQL I
get the same message when I click Connect using either the sa account or a
Windows account with the proper credentials:

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 checked and the stored procedure does not exist in msdb for either
SQL05 or 08.
--
Regards,
James M

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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subs.../aa948874.aspx

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

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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subs.../aa948874.aspx

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

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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subs.../aa948874.aspx

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

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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subs.../aa948874.aspx

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

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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subs.../aa948874.aspx

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

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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subs.../aa948874.aspx

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

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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subs.../aa948874.aspx

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

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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subs.../aa948874.aspx

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

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 (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.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/subs.../aa948874.aspx

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