Fix Microsoft SQL Error 'Connect To Server'

In this tutorial you will learn how you can fix on of the MS SQL errors which is connect to your local server, hope this tutorial be useful for you.

[zviadkharazishvili]

Thanks a lot, you saved my ASP.NET MVC application  :))

[riturajsingh]

sql server  configuration manager > sql server service ( there is an error "remote procedure call fail") 
Plz help me how to resolve this error?