943,800 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 8789
  • MS SQL RSS
You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page
Sep 8th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

It never hurts with Microsoft products to have fresh installs. Love their products, but sometimes they just don't play well together, or at least if not installed in some certain order.
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Sep 9th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

Ok I removed VS 2005 and VS 2008 and all remnants of SQL server. I then rebooted and ran the install for VS 2008, making sure SQL Server 2005 Express was selected. Ran the install and the ending message was your program installed successfully...no errors. So just to be sure, I rebooted and then checked Services and installed programs and the only SQL installed is SQL VSS Writer????

So now, I want to install an express version of sql - so I'm going to download and attempt to install 2005. Will post back the results. This is just nuts!!! LOL
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Hers2keep is offline Offline
22 posts
since Jul 2007
Sep 9th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

I got two warnings upon the initial install of express 2005: Edition Change Check (Warning)
Messages
Edition Change Check

To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.

and the other one was the asp.net error. I've been through IIS and configured all the non-default options required.

We'll see if this install goes through.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Hers2keep is offline Offline
22 posts
since Jul 2007
Sep 9th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

Still no go. I get the same error as I was before:

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.

Now what?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Hers2keep is offline Offline
22 posts
since Jul 2007
Sep 9th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

Looks like a corrupt wmi

How to fix it:
http://slashstar.com/blogs/tim/archi...ct-format.aspx


Also from microsoft's site.
http://www.microsoft.com/downloads/d...displaylang=en
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Sep 9th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

C:\>winmgmt /verifyrepository
WMI repository is consistent

This is the response I get when I query the repository. I tried this before but tried it again this morning just in case it got jacked up in my uninstalling and reinstalling apps.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Hers2keep is offline Offline
22 posts
since Jul 2007
Sep 9th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

Hmmm.

Here's another microsoft link with that exact problem if you haven't tried it already.

http://support.microsoft.com/?kbid=926623
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Sep 9th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

Ok - I had tried that last one, but misread it. So I just tried it again and got the same blasted error...ARGH. It should NOT be this difficult - LOL.

Any more suggestions?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Hers2keep is offline Offline
22 posts
since Jul 2007
Sep 9th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

Lol seems to be pretty hard.

Here's another
http://blogs.msdn.com/echarran/archi...03/509061.aspx

After doing that make sure your wmi repository is still good.
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Sep 9th, 2008
0

Re: Installing SQL Server Express on Vista Home Premium

Okay - maybe this is part of the problem??? Here's the response I get from running the command on the blog you just posted:

Microsoft (R) MOF Compiler Version 6.0.6000.16386
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
File 'C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof' not found!

This is after I ran the regular 2005 Exp, got past the prerequisites installing, canceling and running the 2005 Exp SP2 that failed, which then uninstalls when I click on cancel.

Where does that file come from?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Hers2keep is offline Offline
22 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: Working Offline with MS SQL DEv
Next Thread in MS SQL Forum Timeline: Meeting at least n criteria from given criteria





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC