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

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 HELP DESPERATE !

Author  Topic 

smallzoo
Starting Member

3 Posts

Posted - 2014-01-05 : 17:13:55
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

Peter

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-01-05 : 17:15:43
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
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -