Original: SQL Server connectivity Issue-TCP/IPOriginating From: http://blogs.msdn.com/b/apgcdsd/archive/2012/02/24/ms-sql-server-tcp-ip.aspxBasic principles of how TCP/IP works here's not a waste of saliva. Now this network age, who does not know
Original address: http://www.moon-soft.com/download/info/2826.htm
Port: 0Service: ReservedDescription: Typically used to analyze the operating system. This method works because in some systems "0" is an invalid end, you will have different results
Address: http://blog.csdn.net/zjcxc/archive/2005/07/06/415711.aspx Author: zhujian1. How to understand SQL Server instances
In the project implementation process, many users need to develop a new SQL Server-based system. After the system is accepted,
How to change the SA password and default port number of the SQL Server database qq752923276 csdn blog I want to comment () font size: T | T
This article describes how to change the SA password, change the default port, and set the port number
Problem:
Telnet fig 1433Tip: the connection to the host cannot be opened. port 1433 indicates that the connection failed.
Solution:
Log on to the remote SQL ServerCheck whether the IP address of the ping server can be pinged.
This is to see
1. If you are using win2003, you must install the SQL patch sp3a.
Check whether your SQL has been patched. If not, install a patch. You can run the patch in the query Analyzer:Select @ versionIf the version is earlier than 8.00.760, it indicates
TCP/UDP Common port number
7 Echo (PING)9 DiscardDaytimer19 Word Fuzhou Builder20/TCP FTP Data21/TCP FTP Control File Transfer Protocol22/TCP SSH Secure Login, File transfer (SCP), and port redirection23/tcp Telnet Unsafe Text transfer25/tcp SMTP
It is necessary to note that the SQL Server failover cluster (SQL Server Failover Cluster) We build is an availability cluster, not a load-balanced cluster, which is designed to ensure continuity and availability of services, not to improve service
SQL2005 failed to start SQL Server Request or service failed to respond in time
Disable the VIA protocol to solve the problem. "VIA protocol" Deactivation method: start-> Program-> Microsoft SQL Server 2005-> Configuration tool-> SQL Server
Because server A cannot see the witness server W or the original mirror partner server B, you must enter the disconnected state and make the database unavailable.
Server B and Server w can compose quorum. Server B cannot see server A, so Server B
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.