Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Engine Tuning Advisor does not support Expand / Collapse
Author
Message
Posted Tuesday, January 22, 2008 11:12 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, January 22, 2008 11:31 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:42 AM
Points: 6,743, Visits: 8,515
- Are your trying to connect to a sqlexpress instance ??

- can you post
select @@version

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





Johan


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #446248
Posted Tuesday, January 22, 2008 11:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, January 23, 2008 3:11 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:42 AM
Points: 6,743, Visits: 8,515
as stated in your OP, DTA does not support SQLExpress !

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


Johan


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

- 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"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #446322
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse