Database Engine Tuning Advisor does not support

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Database Engine Tuning Advisor does not...

Database Engine Tuning Advisor does not support

Rate Topic

Display Mode

Topic Options

Author

Message

josethomasrajesh

Posted Tuesday, January 22, 2008 11:12 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 13, 2009 8:39 AM
Points: 2, Visits: 34

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

Post #446242

ALZDBA

Posted Tuesday, January 22, 2008 11:31 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 6,862, Visits: 8,049

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

- can you post

select @@version

-- or the 
select serverproperty('Edition')
 , serverproperty('productlevel')

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #446248

josethomasrajesh

Posted Tuesday, January 22, 2008 11:46 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 13, 2009 8:39 AM
Points: 2, Visits: 34

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 Edition RTM

I executed the above query and its result is above.

Regards,
Jose.P

Post #446251

ALZDBA

Posted Wednesday, January 23, 2008 3:11 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 6,862, Visits: 8,049

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

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

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #446322

« Prev Topic | Next Topic »

Permissions