Mike Eghtebas
asked on
Existing instance of 2008 SQL Server no longer is coonecting
I wonder if it has something to do with recently SQL Server 2012 installation?
FYI, SQL Server 2012 requires a login for a user as admin (to replace sa login). But, prior installation, 2008, possibly sill on SA default login and this maybe causing the problem.
I need guidance, if above point is valid, how to go about to fix this problem.
The error message is included below:
========================== =========
Cannot connect to USER-PC\SQL2K8ME.
========================== =========
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: 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%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476
-------------------------- ----
Error Number: 10061
Severity: 20
State: 0
-------------------------- ----
Program Location:
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsP arser.Conn ect(Server Info serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)
at System.Data.SqlClient.SqlI nternalCon nectionTds .AttemptOn eLogin(Ser verInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
at System.Data.SqlClient.SqlI nternalCon nectionTds .LoginNoFa ilover(Ser verInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at System.Data.SqlClient.SqlI nternalCon nectionTds .OpenLogin Enlist(Tim eoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlI nternalCon nectionTds ..ctor(DbC onnectionP oolIdentit y identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
at System.Data.SqlClient.SqlC onnectionF actory.Cre ateConnect ion(DbConn ectionOpti ons options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.D bConnectio nFactory.C reateNonPo oledConnec tion(DbCon nection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.D bConnectio nFactory.T ryGetConne ction(DbCo nnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.D bConnectio nInternal. TryOpenCon nectionInt ernal(DbCo nnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.D bConnectio nClosed.Tr yOpenConne ction(DbCo nnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlC onnection. TryOpenInn er(TaskCom pletionSou rce`1 retry)
at System.Data.SqlClient.SqlC onnection. TryOpen(Ta skCompleti onSource`1 retry)
at System.Data.SqlClient.SqlC onnection. Open()
at Microsoft.SqlServer.Manage ment.SqlSt udio.Explo rer.Object ExplorerSe rvice.Vali dateConnec tion(UICon nectionInf o ci, IServerType server)
at Microsoft.SqlServer.Manage ment.UI.Co nnectionDl g.Connecto r.Connecti onThreadUs er()
========================== =========
No connection could be made because the target machine actively refused it
FYI, SQL Server 2012 requires a login for a user as admin (to replace sa login). But, prior installation, 2008, possibly sill on SA default login and this maybe causing the problem.
I need guidance, if above point is valid, how to go about to fix this problem.
The error message is included below:
==========================
Cannot connect to USER-PC\SQL2K8ME.
==========================
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: 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%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476
--------------------------
Error Number: 10061
Severity: 20
State: 0
--------------------------
Program Location:
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.SqlC
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
==========================
No connection could be made because the target machine actively refused it
ASKER
I think in my last installation I chose wrong setting dealing with that. My thought was, well no one else beside me is going to use this computer why do I want outside access.
But now it seems, the setting was not referring to out of the computer (access outside the computer) rather it was outside the SQL Server engine (I guess).
Knowing this, what specific steps I need to take to revisit (to locate) that setting and revise it?
I have screen shot of all of the settings saved. Perhaps after reading the above link and going over my screenshots I could figure out what to do. Or, someone could also give me some hint to resolve this issue.
Mike
But now it seems, the setting was not referring to out of the computer (access outside the computer) rather it was outside the SQL Server engine (I guess).
Knowing this, what specific steps I need to take to revisit (to locate) that setting and revise it?
I have screen shot of all of the settings saved. Perhaps after reading the above link and going over my screenshots I could figure out what to do. Or, someone could also give me some hint to resolve this issue.
Mike
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
this is usually either the setting that the instance itself is configured to refuse remote connections, OR some firewall (on either the server OR in the network) that block the full port or just part of the ip ranges that try to connect.
you may want to read up this article:
https://www.experts-exchange.com/Database/MS-SQL-Server/A_1881-Connect-to-your-SQL-Server.html
a simple test is to use telnet ip:port from the same machine, and if that gives no errors (usually a blank screen), the connection shall work. if you get an error, it's NOT sql server refusing, but some firewall.