⑴ 如何可确认sql Server 1433端口是否开启
用cmd,进入命令行模式
telnet: 127.0.0.1 1433
或者 netstat -ant
检测当前侦听的端口。
或者，进sql的管理界面，查网络端口配置，tcp哪里设置端口，此外namepipe必须enable
或者，进控制面板找到管理工具，进去，用odbc，连一下sql的1433口，
或者，用端口扫描工具扫描本机所有端口……
⑵ mysql怎么查看端口号,和服务名
如果在cmd命令窗口中使用netstat查看各个程序占用端口
如果进入mysql 使用show variables like 'port';
使用？或help查看帮助
mysql> show variables like 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.00 sec)
mysql> ?
For information about MySQL procts and services, visit:
http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:
http://dev.mysql.com/
To buy MySQL Enterprise support, training, or other procts, visit:
https://shop.mysql.com/
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
notee (\t) Don't write into outfile.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute an SQL script file. Takes a file name as an argument.
status (\s) Get status information from the server.
tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
use (\u) Use another database. Takes database name as argument.
charset (\C) Switch to another charset. Might be needed for processing binlog
with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.
For server side help, type 'help contents'
mysql>
⑶ 如何查看 sql server 2005 端口号
默认的端口号是1433.
打开sql2005的SQL
Server
Configuration
Manager
-->展开网络配置
-->点击MYSQLSERVER协议
-->双击TCP/IP
-->选择IP地址就能看到端口号了。
⑷ 如何查看自己数据库的端口号
可以通过tnsnames.ora文件读取数据库的信息。
可以看到类似如下的内容：abc =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.219.5)(PORT = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)))
HOST= 就是主机地址（如果是写的主机名，可以查看/etc/hosts文件中查看主机名对应的IP地址）
POST= 就是数据库开放的端口