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
The computer ports are as follows:
0 Port: Invalid port, typically used to analyze operating system
1 Port: Transmission Control Protocol port Service multi-Switch Selector
2 Port: Management utility
3 Port: Compression process
5 Port: Remote
How to solve the connection problem in SQL Server 2000
Applicable
Important: This article contains information about modifying the registry. Before modifying the registry, you must back up the registry and know how to restore the Registry in case of
server| Resolution | How the problem resolves connection problems in SQL Server 2000 apply to important notes: This article contains information about modifying the registry. Be sure to back up the registry before you modify the registry, and be
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
Client applications can connect to Microsoft SQL Server by using TCP/IP, Named pipes, VIA, or the shared memory protocol. You can implement these protocols by using the client network libraries that are contained in the SQL Server Native clients DLL.
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.