Database engine tuning advisor does not support sql express dtaclient как исправить - Исправление ошибок и поиск оптимальных решений проблем

Archived Forums 361-380

SQL Server Database Engine

Question
0

Sign in to vote

Hi to all,

I am using SQl 2014 & 2017 (express edition), when i am connecting to Database Engine Tuning Advisor i am getting an error message from
both versions like this..

Failed to open a new connection. Database
Engine Tuning Advisor does not support SQL Express. (DTAClient)

Help me to solve my problem. Thanks in advance.

Regards,

MOHD MUQEEM NASIR

Monday, August 5, 2019 6:59 PM

All replies

0

Sign in to vote
As per the message, it’s not supported on Express edition. If you want to use DTA, you’ll need a supported edition, see following links:

https://docs.microsoft.com/en-us/sql/getting-started/features-supported-by-the-editions-of-sql-server-2014?view=sql-server-2014#Mgmt_Tools

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017#SSMS
- Proposed as answer by
  Dedmon DaiMicrosoft contingent staff
  Tuesday, August 6, 2019 8:18 AM
Monday, August 5, 2019 8:05 PM

Источник

January 22, 2008 at 11:12 pm

#202502

Hi to all,

I am using sql 2005, when i am connecting to Database Engine Tuning Advisor i am getting an error message like this

Failed to open a new connection. Database Engine Tuning Advisor does not support SQL Express. (DTAClient)

Help me to solve the problem. Thanks in advance.

Regards,

Jose.P
Johan Bijnens

SSC Guru

Points: 135009

January 22, 2008 at 11:31 pm

#770753

— Are your trying to connect to a sqlexpress instance ??

— can you post

select @@version

-- or the

select serverproperty('Edition')

, serverproperty('productlevel')
josethomasrajesh

Old Hand

Points: 328

January 22, 2008 at 11:46 pm

#770755

Hi,

Thanks for your kind reply.

Yes i am trying to connect its instance.

select @@version :

Microsoft SQL Server 2005 — 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

select serverproperty(‘Edition’) , serverproperty(‘productlevel’) :

Express EditionRTM

I executed the above query and its result is above.

Regards,

Jose.P
Johan Bijnens

SSC Guru

Points: 135009

January 23, 2008 at 3:11 am

#770811

as stated in your OP, DTA does not support SQLExpress !

So you cannot use DTA with an SQL2005 express edition instance.

Viewing 4 posts — 1 through 3 (of 3 total)

Источник

Remove From My Forums

Question
As I tried to open SQL Server 2016 database engine / profiler, Error message pops up saying «Database Engine Tuning Advisor does not support Microsoft Azure SQL Database (DTAClient)», please any idea how I can solve this.

Answers

- Marked as answer by
  kanu c
  Sunday, December 18, 2016 12:21 AM

All replies

- Marked as answer by
  kanu c
  Sunday, December 18, 2016 12:21 AM
Thanks Alberto, link you sent solved the problems. Thanks a lot.
Hello,

Thank you for visiting MSDN forums!

Have a great day!

Regards,

Alberto Morillo
SQLCoffee.com
Hello,
just installe dthe SP1 but things do not change at all

Just to be sure, should I install this on my pc, or on the azure server ?
If this is a SQL Azure database you will not be able to install Service Pack 1 on it.
Right…

So?
No way to use Database Engine Tuning Advisor with Microsoft Azure SQL Database ??
Hello,

As a workaround, you can restore a bacpac of a SQL Azure database into a SQL Server instance, and then run the DTA over the restored database.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com
I am confused with answers from different persons on this thread.
Does Database Engine Tuning Advisor work with Microsoft Azure SQL Database or not?
According to https://docs.microsoft.com/en-us/sql/relational-databases/performance/start-and-use-the-database-engine-tuning-advisor, it should work with SQL
ServerAzure
SQL DatabaseAzure
SQL Data Warehouse Parallel
Data Warehouse .
But on my
Sql Server Management Studio v17.3 (Database Engine Tuning Advisor 14.0.1000.169) it gives me

Database Engine Tuning Advisor does not support Microsoft Azure SQL Database. (DTAClient).
Is any workaround (apart of restore DB locally?)

Michael Freidgeim, http://geekswithblogs.net/mnf/
Es lo mismo que yo me pregunto, esto ya que necesito capturar y analizar consultas desde el cliente.

Espero nos puedan ayudar.

Cordialmente.

Источник

Remove From My Forums

Question
As I tried to open SQL Server 2016 database engine / profiler, Error message pops up saying «Database Engine Tuning Advisor does not support Microsoft Azure SQL Database (DTAClient)», please any idea how I can solve this.

Answers

- Marked as answer by
  kanu c
  Sunday, December 18, 2016 12:21 AM

All replies

- Marked as answer by
  kanu c
  Sunday, December 18, 2016 12:21 AM
Thanks Alberto, link you sent solved the problems. Thanks a lot.
Hello,

Thank you for visiting MSDN forums!

Have a great day!

Regards,

Alberto Morillo
SQLCoffee.com
Hello,
just installe dthe SP1 but things do not change at all

Just to be sure, should I install this on my pc, or on the azure server ?
If this is a SQL Azure database you will not be able to install Service Pack 1 on it.
Right…

So?
No way to use Database Engine Tuning Advisor with Microsoft Azure SQL Database ??
Hello,

As a workaround, you can restore a bacpac of a SQL Azure database into a SQL Server instance, and then run the DTA over the restored database.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com
I am confused with answers from different persons on this thread.
Does Database Engine Tuning Advisor work with Microsoft Azure SQL Database or not?
According to https://docs.microsoft.com/en-us/sql/relational-databases/performance/start-and-use-the-database-engine-tuning-advisor, it should work with SQL
ServerAzure
SQL DatabaseAzure
SQL Data Warehouse Parallel
Data Warehouse .
But on my
Sql Server Management Studio v17.3 (Database Engine Tuning Advisor 14.0.1000.169) it gives me

Database Engine Tuning Advisor does not support Microsoft Azure SQL Database. (DTAClient).
Is any workaround (apart of restore DB locally?)

Michael Freidgeim, http://geekswithblogs.net/mnf/
Es lo mismo que yo me pregunto, esto ya que necesito capturar y analizar consultas desde el cliente.

Espero nos puedan ayudar.

Cordialmente.

Источник

Remove From My Forums

Question
As I tried to open SQL Server 2016 database engine / profiler, Error message pops up saying «Database Engine Tuning Advisor does not support Microsoft Azure SQL Database (DTAClient)», please any idea how I can solve this.

Answers

- Marked as answer by
  kanu c
  Sunday, December 18, 2016 12:21 AM

All replies

- Marked as answer by
  kanu c
  Sunday, December 18, 2016 12:21 AM
Thanks Alberto, link you sent solved the problems. Thanks a lot.
Hello,

Thank you for visiting MSDN forums!

Have a great day!

Regards,

Alberto Morillo
SQLCoffee.com
Hello,
just installe dthe SP1 but things do not change at all

Just to be sure, should I install this on my pc, or on the azure server ?
If this is a SQL Azure database you will not be able to install Service Pack 1 on it.
Right…

So?
No way to use Database Engine Tuning Advisor with Microsoft Azure SQL Database ??
Hello,

As a workaround, you can restore a bacpac of a SQL Azure database into a SQL Server instance, and then run the DTA over the restored database.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com
I am confused with answers from different persons on this thread.
Does Database Engine Tuning Advisor work with Microsoft Azure SQL Database or not?
According to https://docs.microsoft.com/en-us/sql/relational-databases/performance/start-and-use-the-database-engine-tuning-advisor, it should work with SQL
ServerAzure
SQL DatabaseAzure
SQL Data Warehouse Parallel
Data Warehouse .
But on my
Sql Server Management Studio v17.3 (Database Engine Tuning Advisor 14.0.1000.169) it gives me

Database Engine Tuning Advisor does not support Microsoft Azure SQL Database. (DTAClient).
Is any workaround (apart of restore DB locally?)

Michael Freidgeim, http://geekswithblogs.net/mnf/
Es lo mismo que yo me pregunto, esto ya que necesito capturar y analizar consultas desde el cliente.

Espero nos puedan ayudar.

Cordialmente.

Источник

Archived Forums 361-380

SQL Server Database Engine

Question
0

Sign in to vote

Hi to all,

I am using SQl 2014 & 2017 (express edition), when i am connecting to Database Engine Tuning Advisor i am getting an error message from
both versions like this..

Failed to open a new connection. Database
Engine Tuning Advisor does not support SQL Express. (DTAClient)

Help me to solve my problem. Thanks in advance.

Regards,

MOHD MUQEEM NASIR

Monday, August 5, 2019 6:59 PM

All replies

0

Sign in to vote
As per the message, it’s not supported on Express edition. If you want to use DTA, you’ll need a supported edition, see following links:

https://docs.microsoft.com/en-us/sql/getting-started/features-supported-by-the-editions-of-sql-server-2014?view=sql-server-2014#Mgmt_Tools

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017#SSMS
- Proposed as answer by
  Dedmon DaiMicrosoft contingent staff
  Tuesday, August 6, 2019 8:18 AM
Monday, August 5, 2019 8:05 PM

Источник

Archived Forums 361-380

SQL Server Database Engine

Question
0

Sign in to vote

Hi to all,

I am using SQl 2014 & 2017 (express edition), when i am connecting to Database Engine Tuning Advisor i am getting an error message from
both versions like this..

Failed to open a new connection. Database
Engine Tuning Advisor does not support SQL Express. (DTAClient)

Help me to solve my problem. Thanks in advance.

Regards,

MOHD MUQEEM NASIR

Monday, August 5, 2019 6:59 PM

All replies

0

Sign in to vote
As per the message, it’s not supported on Express edition. If you want to use DTA, you’ll need a supported edition, see following links:

https://docs.microsoft.com/en-us/sql/getting-started/features-supported-by-the-editions-of-sql-server-2014?view=sql-server-2014#Mgmt_Tools

https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017#SSMS
- Proposed as answer by
  Dedmon DaiMicrosoft contingent staff
  Tuesday, August 6, 2019 8:18 AM
Monday, August 5, 2019 8:05 PM

Источник

INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Thanks. We have received your request and will respond promptly.

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It’s Free!

*Tek-Tips’s functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Now that I’ve got things working…..

(OP)

19 Apr 10 09:15

… in my SQL Server 2008, it’s time to fine-tune things a little.

Where do I find the Index Tuning Wizard (or query analyzer, or whatever tool looks at my stored procedures and makes recommendations for indexes) in SSMS 2008?

TIA!

Happy Monday!

Just my 2¢

«What the captain doesn’t realize is that we’ve secretly replaced his Dilithium Crystals with new Folger’s Crystals.»

—Greg http://parallel.tzo.com

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Join Tek-Tips^® Today!

Join your peers on the Internet’s largest technical computer professional community.
It’s easy to join and it’s free.

Question

All replies

<img decoding="async" onError="javascript: wp_broken_images = window.wp_broken_images || function(){}; wp_broken_images(this);" alt="RRS feed" src="https://i1.social.s-msft.com/globalresources/Images/trans.gif?cver=0001" />

Question

Answers

All replies

<img decoding="async" onError="javascript: wp_broken_images = window.wp_broken_images || function(){}; wp_broken_images(this);" alt="RRS feed" src="https://i1.social.s-msft.com/globalresources/Images/trans.gif?cver=0001" />

Question

Answers

All replies

<img decoding="async" onError="javascript: wp_broken_images = window.wp_broken_images || function(){}; wp_broken_images(this);" alt="RRS feed" src="https://i1.social.s-msft.com/globalresources/Images/trans.gif?cver=0001" />

Question

Answers

All replies

Question

All replies

Question

All replies

Contact US

Come Join Us!

Posting Guidelines

Now that I’ve got things working…..

Now that I’ve got things working…..

Red Flag Submitted

Join Tek-Tips® Today!

Читайте также:

Join Tek-Tips^® Today!