Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Mgmt Studio Express won't connect...

  
   Database Help (Home) -> Setup RSS
Next:  help: advanced shell interaction (exec and the li..  
Author Message
JackBlack

External


Since: Apr 24, 2010
Posts: 1



(Msg. 1) Posted: Sat Apr 24, 2010 10:26 pm
Post subject: Mgmt Studio Express won't connect...
Archived from groups: microsoft>public>sqlserver>setup (more info?)
OK, finally managed to get SQL Server 2008 Express to install under
Windows 7, and the service is staring without errors. However, after
(also) finally managing to get the Studio for Express to install
without errors, I can't connect to the default instance. Is there a
trick to getting it to connect? Error returned is as follows:

------------
TITLE: Microsoft SQL Server Management Studio
------------------------------

Error connecting to 'Tenaya7\SQLEXPRESS'.

------------------------------
ADDITIONAL INFORMATION:

Method not found: 'Int32
Microsoft.SqlServer.Management.Sdk.Sfc.ISfcDomain.GetLogicalVersion()'.
(ObjectExplorer)
------------------------------

No clue where to even go from here. My experience with 2008 has been
absolutely horrible up to now; any suggestions for getting past this
latest roadblock from MS?

Thanks much.
Jack

 >> Stay informed about: Mgmt Studio Express won't connect... 
Back to top
Login to vote
Harpreet

External


Since: Apr 25, 2010
Posts: 1



(Msg. 2) Posted: Sun Apr 25, 2010 3:41 am
Post subject: RE: Mgmt Studio Express won't connect... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Try connecting with local\SQLExpress if still din't connect check the SQL
Server configuration manager to see whether the instance running fine.

Otherwise I think the best is go uninstall and do the clean install again.

If you have any problem with clean install let me know.

Harpreet


"JackBlack" wrote:

> OK, finally managed to get SQL Server 2008 Express to install under
> Windows 7, and the service is staring without errors. However, after
> (also) finally managing to get the Studio for Express to install
> without errors, I can't connect to the default instance. Is there a
> trick to getting it to connect? Error returned is as follows:
>
> ------------
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Error connecting to 'Tenaya7\SQLEXPRESS'.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Method not found: 'Int32
> Microsoft.SqlServer.Management.Sdk.Sfc.ISfcDomain.GetLogicalVersion()'.
> (ObjectExplorer)
> ------------------------------
>
> No clue where to even go from here. My experience with 2008 has been
> absolutely horrible up to now; any suggestions for getting past this
> latest roadblock from MS?
>
> Thanks much.
> Jack
> .
>

 >> Stay informed about: Mgmt Studio Express won't connect... 
Back to top
Login to vote
Sylvain Lafontaine

External


Since: Mar 21, 2009
Posts: 6



(Msg. 3) Posted: Sun Apr 25, 2010 4:13 am
Post subject: Re: Mgmt Studio Express won't connect... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Tenaya7\SQLEXPRESS is not the default instance, it's a named instance. The
default instance would be simply Tenaya7 or (local) or . or localhost (if
using TCP/IP as the protocol).

You should check at the list of services on your machine to know if this is
really the default (or unnamed) instance or a named instance.

If this is a named instance, the SQL-Server Browser service should also be
started if you are using TCP/IP as it will be used to determine the
destination port of the instance.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"JackBlack" wrote in message

> OK, finally managed to get SQL Server 2008 Express to install under
> Windows 7, and the service is staring without errors. However, after
> (also) finally managing to get the Studio for Express to install
> without errors, I can't connect to the default instance. Is there a
> trick to getting it to connect? Error returned is as follows:
>
> ------------
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Error connecting to 'Tenaya7\SQLEXPRESS'.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Method not found: 'Int32
> Microsoft.SqlServer.Management.Sdk.Sfc.ISfcDomain.GetLogicalVersion()'.
> (ObjectExplorer)
> ------------------------------
>
> No clue where to even go from here. My experience with 2008 has been
> absolutely horrible up to now; any suggestions for getting past this
> latest roadblock from MS?
>
> Thanks much.
> Jack
 >> Stay informed about: Mgmt Studio Express won't connect... 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 2061



(Msg. 4) Posted: Sun Apr 25, 2010 6:25 am
Post subject: Re: Mgmt Studio Express won't connect... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
JackBlack ( ) writes:
> OK, finally managed to get SQL Server 2008 Express to install under
> Windows 7, and the service is staring without errors. However, after
> (also) finally managing to get the Studio for Express to install
> without errors, I can't connect to the default instance. Is there a
> trick to getting it to connect? Error returned is as follows:
>
> ------------
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Error connecting to 'Tenaya7\SQLEXPRESS'.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Method not found: 'Int32
> Microsoft.SqlServer.Management.Sdk.Sfc.ISfcDomain.GetLogicalVersion()'.
> (ObjectExplorer)
> ------------------------------
>
> No clue where to even go from here. My experience with 2008 has been
> absolutely horrible up to now; any suggestions for getting past this
> latest roadblock from MS?

Something is obviously broken; that is not a regular error message.
But what is broken I have no idea.

I like to point out that since SQL 2008 was released before Windows 7,
there may be glitches. Since I don't have Windows 7 myself, I have not
dug into the details myself. I found one thread on the MSDN forums
where a poster had this error, and he had been able to resolve with a
reinstall.

--
Erland Sommarskog, SQL Server MVP, esquel.RemoveThis@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 >> Stay informed about: Mgmt Studio Express won't connect... 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Express: Installed, running, but cannot connect? - Windows authentication. I'm working on the same PC that Express is installed on. Using SQL Server Studio Mangement Express, I have set my ID's permissions to everything that I can think of. But when MS Access tries to connect to the server to upsize a...

Visual Studio 2008: Where is the Business Intelligence Stu.. - Hallo, Till now I've worked with SQL Server 2005 and VS 2005. With the SQL Server installation comes a VS 2005 Shell, which offers Business Intelligence projects. After installation of VS 2008, I recognized, that there are no such projects in VS 2008...

Can't upgrade sql express 2005 to sql express 2008 - I have never tried an upgrade on a sql server, and this first attempt is going nowhere. What already installed: - sql server 2005 as instance sqlexpress - sql server 2008 developer as instance sqlserver I want to upgrade the 2005 express to 2008..

Management Studio -

Management Studio - SQL Server Management Studio creates a default "Projects" folder (as well as others) in "My Documents". I would like to change the default location of this folder. In the registry I was able to successfully move all the folders exc...
   Database Help (Home) -> Setup All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]