Want to know connect to sql server with port number? we have a huge selection of connect to sql server with port number information on alibabacloud.com
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: 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
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,
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
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
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
SQL ServerInstall the first instance, the default instance port is 1433,If there are multiple instances in a library,The port starting from the second instance is a dynamic port, which, if required, is manually specified as a static port, as
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
Steps:
Check whether the IP address of the ping server can be pinged.
This is to see whether the physical connection to the remote SQL Server 2000 Server exists. If not, check the network and check the configuration. Make sure that the IP address of
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.