Appendix 21. Basic process for troubleshooting

Source: Internet
Author: User

Appendix 21. Basic process for troubleshooting


1.1 Connection process for clients

The client application requests a connection to the remote SQL Server server, first through the firewall and then through SQL Server authentication before the connection can be established.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/CA/wKioL1WIu4iA_66dAADlmTt9PLw578.jpg "title=" Connection process. png "alt=" wkiol1wiu4ia_66daadlmtt9plw578.jpg "/>


1.2 Collecting fault Information

When a client connection fails, there is usually an error message. Through these error messages, you can roughly determine which part of the fault occurred.

For example, the error message in the following example indicates that the client application could not connect to the port of the specified remote SQL Server instance.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6E/C9/wKioL1WIsi7xObGwAAEJDGYos6k539.jpg "title=" Verify the instance server. png "alt=" wkiol1wisi7xobgwaaejdgyos6k539.jpg "/>


As another example, the error message in the following examples represents the information of logon account errors.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6E/CD/wKiom1WIsOuQe5__AACbwKbyuro961.jpg "title=" Account logon failed. png "alt=" wkiom1wisouqe5__aacbwkbyuro961.jpg "/>


Some applications may intercept and encapsulate error messages, in which case it is recommended that you first attempt to connect to the server using other client tools and get as detailed an error message as possible.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6E/CD/wKiom1WIsAzRCriZAAC2gEkPZeI685.jpg "title=" Unable to connect. png "alt=" wkiom1wisazrcrizaac2gekpzei685.jpg "/>



1.3 Basic process of troubleshooting

First, you need to confirm that the SQL Server service is started. The simplest way to do this is to try to connect to the SQL Server engine by using a client-side tool (such as SSMS) locally on the SQL Server server. It is important to note that if this server has multiple instances installed, you need to confirm that the instance name that you are trying to connect to locally is consistent with the instance name used by the client.

Second, the SQL Server instance must allow the remote client to connect. If the instance has a remote connection disabled, or if the maximum number of connections is exceeded, the client connection is unsuccessful.

If the SQL Server server can connect locally and the remote client cannot connect, you need to confirm the network traffic between the server and the client. This includes DNS resolution, firewalls, network communication protocols and many other factors.

You will then also need to confirm that the client driver is installed and that the client application is matched.

Finally, verify that the user account is valid and that the password is correct.



This article from "SQLServer2014 series" blog, declined reprint!

Appendix 21. Basic process for troubleshooting

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.