Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Can't see servername after installing SQL Server 2008 Express

2 views
Skip to first unread message

javelin

unread,
Nov 28, 2009, 9:21:49 PM11/28/09
to
I have had SQL Server 2005 Express installed on another system and it
appeared when running the Data source configuration wizard. Now, with
2008, it doesn't show up there, nor in the ODBC manager when trying to
create a new SQL Server data source. It's getting frustrating, but I
don't know what too do. Please advise if you can.

Thanks in advance!!!

J

Erland Sommarskog

unread,
Nov 29, 2009, 4:35:32 AM11/29/09
to
Can't you just type in the instance name?


--
Erland Sommarskog, SQL Server MVP, esq...@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

javelin

unread,
Dec 1, 2009, 10:42:09 PM12/1/09
to
On Nov 29, 4:35 am, Erland Sommarskog <esq...@sommarskog.se> wrote:

I tried this and couldn't seem to get it right. I figured out that the
SQL Server Browser service wasn't started. I still couldn't start it
because, apparently, a failed SQL Server 2008 Express installation was
interfering somehow with SQL Server 2005 Express. I further learned
that a common fix is to download and install the following:
1- SQLSysClrTypes.msi
2- SharedManagementObjects.msi
3 - sqlncli.msi

I was able to install the first two, but the 3rd failed, telling me
that "installation of this product failed because it is not supported
on this operating system". I'm on Vista64. Why must Vista 64 be so
difficult? I tried searching for a 64bit version, but no luck thus
far. If you can, please advise.

Thanks very much!
J

Erland Sommarskog

unread,
Dec 2, 2009, 5:38:40 PM12/2/09
to
javelin (google....@spamgourmet.com) writes:
> I tried this and couldn't seem to get it right. I figured out that the
> SQL Server Browser service wasn't started. I still couldn't start it
> because, apparently, a failed SQL Server 2008 Express installation was
> interfering somehow with SQL Server 2005 Express. I further learned
> that a common fix is to download and install the following:
> 1- SQLSysClrTypes.msi
> 2- SharedManagementObjects.msi
> 3 - sqlncli.msi
>
> I was able to install the first two, but the 3rd failed, telling me
> that "installation of this product failed because it is not supported
> on this operating system". I'm on Vista64. Why must Vista 64 be so
> difficult? I tried searching for a 64bit version, but no luck thus
> far. If you can, please advise.

Look at
http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
0 new messages