Cannot connect to SQL server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Cannot connect to SQL server

Author

Topic

schan8593
Starting Member

13 Posts

Posted - 2012-07-25 : 18:37:41

Hi, whenever I try to connect to MS SQL server, I always get an error saying that:

A connection was successfully established with the server but then an error occurred during the pre-login handshake. (provider: SSL Provider, error:0 - The certificate chain was issued by an authority that is not trusted)(Microsoft SQL Server).

I noticed this occurs when disable my IP/TCP connection. However, when I enable my IP/TCP connection, I get another error which hinders me from starting the service Microsoft SQL Server (MSSQLSERVER). When I try to start the service, I get an error saying:

The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details.

Could anyone please help? What's the correct setting for IP/TCP connections? Thanks.

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-07-25 : 19:05:37

Enable SQL Authentications and then try to login.

--------------------------
http://connectsql.blogspot.com/

schan8593
Starting Member

13 Posts

Posted - 2012-07-25 : 19:46:09

No luck. Any other tips?

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2012-07-26 : 05:30:32

What does it say in the windows event log when you try to start the service? Which account is the service running under? Always use sql server configuration manager when starting/stopping/changing sql server services...if you set it to run under a domain account or something from the windows services MMC it will not set proper permissions and it will not work.

- Lumbago
My blog-> http://thefirstsql.com

schan8593
Starting Member

13 Posts

Posted - 2012-07-26 : 12:24:00

I'm running it under administrator. When I try to start/stop the service, it says: "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." Any help?

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2012-07-26 : 16:02:23

Well, you can start by answering my questions properly (also stated in the error message itself); what does it say in the event log? And how did you set the service to run with the administrator account (which btw is a horrible idea)? Did you use the Windows Services console or the SQL Config Manager?

- Lumbago
My blog-> http://thefirstsql.com

schan8593
Starting Member

13 Posts

Posted - 2012-07-26 : 18:39:57

Sorry. Well now, I've got it to work so that the MSSQLSERVER service starts. However, I get an error saying:

Cannot connect to WIN-VPJ7WRQHKD3
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Microsoft SQL Server). Here are the message details:

===================================

Cannot connect to WIN-VPJ7WRQHKD3.

===================================

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-2146893019&LinkId=20476

------------------------------
Server Name: WIN-VPJ7WRQHKD3
Error Number: -2146893019
Severity: 20
State: 0

------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

I check the force encryption box and it said no. I also disabled my TCP/IP property in SQL Configuration Manager. Sorry if I'm being confusing.

schan8593
Starting Member

13 Posts

Posted - 2012-07-27 : 13:40:28

Nevermind, I've fixed it. I have one question--is there an easier way to find some text / item in a column aside from doing (for example):

SELECT *
FROM VSS1
WHERE FolderName LIKE '%Switch%'

Is there a function in MS SQL that simply lets you do some sort of find, like hitting control + f like you do in MS Excel?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources