sql server端口的更改方法

数据库 SQL Server
sql server的默认端口应该如何修改呢?下面就将为您讲解sql server默认端口的更改方法,希望能够帮您解决sql server端口的一些问题。

sql server端口如果出现问题,会直接影响sql server的登录,下面就教您sql server端口的更改方法,供您参考,让您不再为sql server端口问题而头疼。

今天遇到一个问题,sql server无法登陆,到Services里看,服务没有起来。但是在启动Service时遇到问题说无法启动。去Administrative Tools->Event Viewer中查看了一下,发现如下错误(该错误在SQL Server日志中也可以查看到,目录在C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log):

Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.

TDSSNIClient initialization failed with error 0x2740, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Only one usage of each socket address (protocol/network address/port) is normally permitted.

知道可以用netstat -ano命令查看系统sql server端口的使用情况。检查后没有发现1433端口在使用。

所以直接改了SQL Server的TCP/IP端口。更改办法如下:

In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click on the server instance you want to configure.
In the right pane, double-click TCP/IP.
In the TCP/IP Properties dialog box, click the IP Addresses tab.
In the TCP Port box of the IPAll section, type an available port number. For this tutorial, we will use 1500.
Click OK to close the dialog box, and click OK to the warning that the service must be restarted.
In the left pane, click SQL Server Services.
In the right pane, right-click the instance of SQL Server, and then click Restart. When the Database Engine restarts, it will listen on port 1500.
更改后终于可以访问了。
 

 

 

【编辑推荐】

sql server日志文件过大的解决办法

sql server外键建立的写法

教您sql server外键的设置和删除

sqlserver分页存储过程实例

SQL SERVER分区视图

责任编辑:段燃 来源: 互联网
相关推荐

2010-11-10 09:44:31

SQL Server端

2010-09-08 14:22:19

sql server端口配置

2010-11-10 09:55:50

2010-07-20 14:07:31

更改TELNET端口

2010-09-25 10:48:59

SQL字段类型长度

2010-07-05 17:55:26

SQL Server更

2011-07-25 18:41:47

SQL Server数默认端口

2010-10-19 14:11:20

SQL SERVER恢

2010-10-21 12:03:35

SQL Server视

2010-06-17 16:59:51

SQL Server身

2010-11-10 15:23:55

SQL SERVER

2010-11-12 10:23:05

SQL Server变

2010-06-28 11:40:44

SQL Server

2010-11-09 17:02:43

SQL Server死

2011-04-02 17:08:44

SQL Server死锁

2010-09-14 15:34:29

sql server死

2010-07-20 14:50:05

telnet端口

2010-12-17 09:11:41

SQL Server

2012-04-13 13:26:30

SQL Server

2010-07-21 10:41:55

SQL Server
点赞
收藏

51CTO技术栈公众号