SQL 2008 Management Studio connection failure

Question

question

simon asked Oct 18, '09

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'

ADDITIONAL INFORMATION:

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)

BUTTONS:

OK

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

sql-server-2008 ssms

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RBarryYoung commented · Oct 18, 2009 at 03:04 PM

"Katmai"? Do you mean one of the Beta releases?

0 ·

Answer 1 · 2009-10-18T16:01:13Z

simon answered Oct 18, '09

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

http://social.msdn.microsoft.com/forums/en-US/vs2008sp1beta/thread/160a8348-6d03-433b-b513-1888a2787adc/

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

Si

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question