无法连接sql2005

Question

我的用win7旗舰版的操作系统，刚装好sql2005时还能正常使用，但是重启电脑后就无法连接 以下是数据库提示的内容 ==================================================================================================

在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接) (.Net SqlClient Data Provider)

 ------------------------------

有关帮助信息，请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

 ------------------------------

错误号: 2 严重性: 20 状态: 0

 ------------------------------

程序位置:

 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

 在 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

 在 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

在 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

在 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

 在 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

在 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

 在 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

 在 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

 在 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

 在 System.Data.SqlClient.SqlConnection.Open()

 在 Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)

 在 Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser() ====================================================================================================================== 我重新装过很多次sql2005.每次都是这样，我在外围应用配置器里选择了同时允许TCP/IP和named pipes连接，还是不行。我实在不知道该怎么办？请哪位达人教教我怎么处理这个问题，谢谢

Answer 1

Did you enable tcp/ip and named pipes on server? Enabled remote access? Is sql instance name correct?

Answer 2

我在外围应用配置器里选择了同时允许TCP/IP和named pipes连接，还是不行。重装过很多次sql2005.还是会出现这个问题

Answer 3

What's instance name? How did you connect to it? From where?

 

Answer 4

我的用win7旗舰版的操作系统，刚装好sql2005时还能正常使用，但是重启电脑后就无法连接 以下是数据库提示的内容

--

 

1、重启时服务已经启动？ 安装过程中没有配置服务为自启动？

2、到服务列表里看看SQL2005是否启动，如果没启动修改启动模式为自动启动，并选择系统帐户登录

---

More: blog.csdn.net/happyflystone

Answer 5

Hi,

"Not allow remote connection"的问题会由很多错误因素导致，一般通过排查各个潜在因素来解决，请参考以下文章：

http://msdn.microsoft.com/en-us/library/dd857537(VS.85).aspx (文章同样适用于 SQLServer2005 )

此外，请查看防火墙中是否有将相应端口设为例外。

Thanks.

---

Microsoft Online Community Support Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 6

did your SQL2005 start correctly on win7 after reboot OS? any error log on the SQL2005 server?