Sql server 2008 r2不是从Services开始的

问题描述:

很多天前我安装了SQL Server 2008 R2之后我安装了VS2012专业版。

现在我正在尝试登录SQL Server我收到此错误是例程错误



Many days ago i installed SQL server 2008 R2 after that i installed VS2012 professional.
now i am trying to Login SQL Server i getting this error which is the routine error

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)





通常我会去服务并从那里开始使用sqlexpress,但是令人惊讶的是我也失败了也启动它并得到这个错误





usually i go to services and start sqlexpress from there but surprisingly i failed there also to start it and get this error

Windows could not start the sql server(SQLEXPRESS) on local computer. For more  inforamation, review system event log. ...  



这是什么,我也打开事件日志,但不知道发生了什么。我搜索很多但没有找到正确的解决方案记得当我从sql配置检查sql server服务时我也得到了这个


what is this i also open Event log but dont know whats going on . i search alot but didnt find right solution remember when i checked sql server services from sql configuration i also got this

remoter procedure call failed...

可能是你安装东西的顺序。

VS使用SQL并安装它自己的版本(我不要认为以前的经验是完整的。)



我还没有安装VS2012 - 我还在2010年 - 但我在2010年和2008年遇到过类似的问题。



我能做的最好的建议是:卸载VS和SQL,然后以相反的顺序安装。
Probably, it's the order in which you installed things.
VS uses SQL and it installs it's own version (which I don't think is complete from previous experience).

I haven't installed VS2012 - I'm still on 2010- but I had similar problems with 2010 and 2008.

The best suggestion I can make is: uninstall both VS and SQL and install then in the opposite order.


For更多信息,审查系统事件日志。 ...



检查系统日志,并报告与SQL服务器实例相关的错误。如果你不首先进行这项研究,就无法找出发生了什么。我们(您)至少需要一个错误编号。
For more inforamation, review system event log. ...

Check for System Log, and report errors related to SQL server instance. There is no way to find out what is going on if you do not do this research in the first place. We (you) need at least an error number to start from.