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

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" <sierraphotog (AT) gmail (DOT) com> wrote

JackBlack (sierraphotog (AT) gmail (DOT) com) writes:
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 (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

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: