Change sqlserver server name to local IP address for Logon

When installing sqlserver2008 and 2012, select the default instance. The server name is the name of the computer, especially when logging on to the local database. You need to enter the user name on the computer and add SQLEXPRESS, for example: zhangsanSQLEXPRESS is not the IP address of its local machine: 192.168.1.xx, and other computers in the internal network cannot access it.

When installing sqlserver2008 and 2012, select the default instance. The server name is the name of the computer, especially when logging on to the local database. You need to enter the user name on the computer and add SQLEXPRESS, for example: zhangsan \ SQLEXPRESS is not the ip address of the Local Machine: 192.168.1.xx, other computers in the internal network cannot access it.

When installing sqlserver2008 and 2012, select the default instance,ServerNameThat is, the computer'sName, EspeciallyLoginLocalYou need to enter the computer userNameAdd SQLEXPRESS

For example, zhangsan \ SQLEXPRESS is not the ip address of the local machine.Address: 192.168.1.xx cannot be accessed by any computer on the internal network.

The question is, how to modify it?ServerNameInsteadLocalIP address or user name \ SQLEXPRESSLoginSqlserver?

Solution:

1. Start program = Microsoft SQL Server 2012 = Configuration tool = SQL Server Configuration Manager = SQLEXPRESS protocol = TCP/IP, for example:

2. Click "yes" for the protocol option changed by TCP/IP, and then click "option IP"Address, Change all the "TCP ports" inside to 1433, IP2AddressChange to yourselfLocalThe dynamic TCP port is changed to null.

If you still don't know how to change it, you can click "TCP/IP" of "MSSQLSERVER protocol", all of which have been changed to port 1433. For more information, see change it to the same.

3. Restart the sqlserver service, for example:

4. Enable sqlserver and directly use the IP address.AddressYou canLogin.

Note: sqlserver needs to be set to allow remote connection to thisServer. Most of them are allowed, so I am afraid that some settings will not be allowed for the sake of security.