Error Connecting to Database Engine

I have been successfully using SQL Server 2005 developer

edition for a couple of months now.However,

when I started Microsoft SQL Server Management Studio this morning I could not

connect to the “Database Engine” (I’m using Windows Authentication). I can still connect with the “Integration

Services” and “Analysis Services” on the same server. The server running on my local machine, so

there shouldn’t be any problems with the network.I am also able to connect with it through

ODBC, it just seems to be the Server Management Studio which can’t connect, and it only has

problems with the “Database Engine.” Any

help would be appreciated.

David

The detailed error message says:

An error has occurred while establishing a connection to the

server.When connecting to SQL Server

2005, this failure may be caused by the fact that under the default settings SQL

Server does not allow remote connections. (provider: TCP Provider, error: 0 -

No connection could be made because the target machine actively refused it.)

(.Net SqlClient Data Provider)

For help, click:

http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476

Error Number: 10061

Severity: 20

State: 0

Program Location:

at

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,

Boolean breakConnection)

at

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject

stateObj)

at

System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,

Boolean& failoverDemandDone, String host, String failoverPartner, String

protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean

encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection

owningObject, Boolean aliasLookup)

at

System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection

owningObject, SqlConnectionString connectionOptions, String newPassword,

Boolean redirectedUserInstance)

at

System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity

identity, SqlConnectionString connectionOptions, Object providerInfo, String

newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at

System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions

options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection

owningConnection)

at

System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection

owningConnection, DbConnectionPoolGroup poolGroup)

at

System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection

owningConnection)

at

System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection

outerConnection, DbConnectionFactory connectionFactory)

at

System.Data.SqlClient.SqlConnection.Open()

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo

ci, IServerType server)

at

Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

I'm not sure exactly which setting fixed it, however after reinstalling and adjusting some settings it now is working again.|||I had the same problem. What I did is open the SQL Server Management Studio and view registered servers. Then I right clicked on my server and went to SQL Server Configuration Manager. I then checked the protocols on my server and they were all disabled!! I reenabled them then restarted the SQL Server service. Now I am all good.|||I, too, have this problem. Unfortunately, after enabling the protocols I am still not able to connect! Does anyone have any other ideas?|||

I am having the same problem. I installed SQL Server last week and used it fine until yesterday. Yesterday, I changed the properties on my ASPNET user and tried to restart SQL. The restart failed and I was unable to ever make a connection again. I rebooted my machine a couple of times, I changed the Protocols to "Enabled", etc. yet nothing worked.

I had to uninstall SQL and then re-install it to get it working. That is until this morning. I tried to login this morning and I received the error again. Is this a daily routine now, uninstall and re-install SQL to start my day off?

Does anyone know what is causing this and even better what it takes to fix it?

Thanks,

DP

|||

This happened to me after updating common language runtime and/or installing SQL Server 2005 SP1 and/or configuring some ODBC connections. Here's how I corrected:

Navigate to Start-->Admin Tools-->Computer Mgt-->Sevices&Apps-->SQL Server Config Mgr-->SQL Server 2005 Network Config

Expand & select Protocols for MSSQL Server and verify the following settings:

Shared Memory Enabled (found Enabled)

Named Pipes Enabled (found Disabled)

TCP/IP Enabled (found Disabled)

VIA Disabled (doesn't seem to matter)

To change settings, double-click or right-click each of the above. Then use SQL Server Manager (the server PC icon in your system tray with either the green arrow or red dot) to Stop (if Started) and/or to then Start (if Stopped) the SQL Sever for the changed settings to take effect.