x

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

more ▼

asked Oct 18 '09 at 07:07 AM in Default

simon gravatar image

simon
36 1 1 1

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

1 answer: sort voted first

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

more ▼

answered Oct 18 '09 at 04:01 PM

simon gravatar image

simon
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 '09 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x123

asked: Oct 18 '09 at 07:07 AM

Seen: 5440 times

Last Updated: Oct 19 '09 at 05:46 AM