Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

United Kingdom
3 Posts

Posted - 01/05/2014 :  17:13:55  Show Profile  Reply with Quote
I have hada copy of SQL 2008 and SQL 2012 for ages on my laptop ( win7 ) and never had a problem. I use VS 2010 for my development. Suddenly yesterday I started getting errors such as 'could not load xpstar.dll or one of its references reason 193....'

After many hours I decided to uninstall 2012 and go onto the Microsoft Website an install SQL 2012 Express SP1. All seemed to go well until about 75% way through the installation an error message popped up 'sql server 2012 service pack 1 setup..provider load failure'

The installation seemed to continue ok but at the end it the status says all have succeeded except for Reporting Services, Database Engine Services, Full Text and SQL Replication

Anyway I rebooted and went into SQL 2012 Management Studio but I simply cant get the Instance to open

SQL 2008 is still working fine

Can anyone help me with this installation error. I have heard things like WMI issues but I have no idea what that is

This is stopping all my local development

Many thanks


Almighty SQL Goddess

38200 Posts

Posted - 01/05/2014 :  17:15:43  Show Profile  Visit tkizer's Homepage  Reply with Quote
If you uninstalled SQL 2012 and then installed SP1, you only updated the tools likely. You need to re-install SQL 2012 before you can add the service pack.

Tara Kizer
SQL Server MVP since 2007
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000