SQL 2008 Management Studio connection failure

Hi I installed early version of SQL Katmai 2008 on my Vista. Install was smooth but When I run Management Studio and enter either SQL or windows logins at initial login page I get following:

TITLE: Microsoft SQL Server Management Studio

Error connecting to 'servername\instancename'


Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorCore)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Microsoft.SqlServer.Smo.UnSafeInternals.ManagementUtil.EnterMonitor(System.Object) (Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorCore)



it is rather annoying because I installed SQL twice but cannot get pass through this error...

more ▼

asked Oct 18, 2009 at 07:07 AM in Default

simon gravatar image

36 1 1 1

"Katmai"? Do you mean one of the Beta releases?
Oct 18, 2009 at 03:04 PM RBarryYoung
(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

that's correct, however I found the solution!

basically after Katmai install I installed VS SP1 which breakes most of the previous CTP installs, hence SQL logins via Management Studio (Code Name 'Katmai') was impossible! Reinstall of product in correct order resolved the issue. following is the thread where I noted solution, which worked..


many thanks to all and Ben for review/comments..


more ▼

answered Oct 18, 2009 at 04:01 PM

simon gravatar image

36 1 1 1

If this is the answer to your question, you should mark it as such (click on the big tick next to it!).
Oct 19, 2009 at 05:46 AM Melvyn Harbour 1 ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 18, 2009 at 07:07 AM

Seen: 5924 times

Last Updated: Oct 19, 2009 at 05:46 AM