<b>sql server端口的更改办法</b>[MSSQL防范]
本文“<b>sql server端口的更改办法</b>[MSSQL防范]”是由七道奇为您精心收集,来源于网络转载,文章版权归文章作者所有,本站不对其观点以及内容做任何评价,请读者自行判断,以下是其具体内容:
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.
更改后终于可以拜候了.
以上是“<b>sql server端口的更改办法</b>[MSSQL防范]”的内容,如果你对以上该文章内容感兴趣,你可以看看七道奇为您推荐以下文章:
本文地址: | 与您的QQ/BBS好友分享! |