TopMenu

SQL Server 2008 R2 on windows 8 Error 17058 when starting the service

Windows 8 is the new operating system from Microsoft and now it’s spreading through the development systems replacing windows 7. So you may need to re-install your sql server and Visual studio etc. Recently I was trying to install the sql server 2008 on my x64 based windows 8 machine, I ran into this error after installing the Sql Server 2008 R2 the service was not getting started. When opened the service configuration manager then I got “WMI provider Error” Unable to call a remote procedure or something like that.

Now do not panic and just install the Sql server 2008 SP1 and the problem will be gone.

After installing this if will able to see everything is back in Sql server configuration manager. But if you’re still not able to restart the service just go to the error log of Sql server. You can find it by right clicking on the service from configuration manager and select properties. Now go to advance tab and open the Dump directory option.

clip_image001

Now open the error log file and see what the last error has logged there. Most probably you’ll see the error for VIA service enable and VIA is deprecated in this version something like that. So just come back to the configuration manager select the client protocols for <<Your Sql server instance name>> and disable the VIA protocol.

No comments:

Post a Comment