如何解决我的Sqlserver在我的系统中打开的问题 [英] How Do I Solve My Sqlserver Problem Of Opening In My System

问题描述

我有一台安装了SQL Server的PC我已经使用sql server工作了一年2013年

但是现在从最近几天它没有用我的用户凭据连接打开它显示错误-40即

无法连接到<我的系统名称> 
 
附加信息：
 
建立与sql server的连接时发生网络相关或特定于实例的错误。未找到服务器或无法访问服务器。验证实例名称正确，并且sql server配置为允许远程连接。（提供程序：命名管道提供程序，错误：40-无法打开与SQL Server的连接）（Microsoft SQL Server，Erroe：2）

一般我为此做的是去

 mycomputer  - > R .Click  - >管理 - >服务和应用程序 - > MSSQLSERVER  - > R.Click  - >开始。

这个我的mssqlserver即将开始，像往常一样我开始使用这个..

创建表格......等等......



但是现在当我按照上面的方式启动服务时，它会抛出另一个错误，如下所示

 Windows无法在本地comp上启动SQL Server（MSSQLSERVER）有关详细信息，请查看系统事件日志。如果这是非Microsoft服务，请与服务供应商联系，并参阅服务特定的错误代码17051. 

我不知道如何克服这个问题...

任何人都可以解决这个问题，这样我就可以像往常一样工作...... div class =h2_lin>解决方案

您的SQL服务器试用版似乎已过期： http://social.msdn.microsoft.com/Forums/sqlserver/en-US/68c555a8-fbba-4aec -9331-6161c800b3ef / sql-2008-r2-express-with-error-17051 [ ^ ]

I have a PC with me with SQL Server installed i had worked with sql server for one year of 2013
but now from recent days it was not connecting to open with my user credentials it was displaying an error-40 ie

Cannot connect to <my system name>

additional information:

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)(Microsoft SQL Server,Erroe:2)  

and generally what i do for this is i go for

mycomputer-->R.Click-->Manage-->services and applications-->MSSQLSERVER-->R.Click-->Start.

with this my mssqlserver was going to start and as usual i start's to work with this..
of creation of tables and...so on..

but now when i start the service as above it was throwing another Error which seems like below

Windows could not start the SQL Server (MSSQLSERVER)on local computer.For more information,review the system Event Log.If this is a non-Microsoft service,contact the service vendor,and refer to service-specific error code 17051.

I don't Know How to overcome this problem...
Could any one giude me towards solving this problem so that i can work as usual...

解决方案

It seems your SQL server trial is expired : http://social.msdn.microsoft.com/Forums/sqlserver/en-US/68c555a8-fbba-4aec-9331-6161c800b3ef/sql-2008-r2-express-with-error-17051[^]

这篇关于如何解决我的Sqlserver在我的系统中打开的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！