一般服务器为了安全有可能需要更改下sql的端口,下面是方法。
在SQL Server 配置管理器中,展开SQL Server 2005的网络配置,然后点击服务器实例如:MSSQLSERVER 的协议。--------------------------------------------------------------------------------
In SQL Server Configuration Manager, expand SQL Server 2005 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 2005 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.