SQL Server 2008 R2 on Windows 8 Error 17058 When Starting the Service

Recently I was trying to install SQL Server 2008 on my x64-based Windows 8 machine; I ran into an error after installing SQL Server 2008 R2; the service was starting. Windows 8 is the newest 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.

When the service configuration manager was opened, I got a "WMI provider Error" Unable to call a remote procedure.

Now do not panic and install the SQL Server 2008 SP1; the problem will disappear.

After installing this, everything is back in SQL Server Configuration Manager. But if you're still unable to restart the service go to the error log of SQL Server. You can find it by right-clicking on the service from the Configuration Manager and selecting properties. Now you can go to the advanced tab and open the Dump directory option.

sql.jpg

Now you can open the error log file and see the last error logged there. You'll likely see the error for the VIA service enabled, and VIA is deprecated in this version or something like that. To return to the configuration manager, select the <<Your SQL Server instance name>> client protocols and disable the VIA protocol.

Recommended Ebook

SQL Queries For Beginners

Download Now!
Similar Articles