January 22, 2008 at 11:12 pm
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
January 22, 2008 at 11:31 pm
- Are your trying to connect to a sqlexpress instance ??
- can you post
select @@version
-- or the
select serverproperty('Edition')
, serverproperty('productlevel')
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
January 22, 2008 at 11:46 pm
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
January 23, 2008 at 3:11 am
as stated in your OP, DTA does not support SQLExpress !
So you cannot use DTA with an SQL2005 express edition instance.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply