SQL Server name changed to local IP address login

Original: SQL Server name changed to local IP address login

When installing sqlserver2008, 2012 and so on is the default instance, the server name is the name of the computer, especially to log on to the local database, you need to enter the computer user name plus SQLExpress

For example: Zhangsan\sqlexpress instead of its own native IP address: 192.168.1.xx Internal network Other computers also cannot access.

The problem is, how to modify the server name, change to the local IP or user name \sqlexpress login SQL Server?

Workaround:

1. Start program = "Microsoft SQL Server 2012 =" Configuration Tool = "SQL Server Configuration Manager =" SQLExpress protocol = "TCP/IP:

2. Click on the TCP/IP Change Protocol option for enabled to Yes, then continue clicking on the option IP address, and change all of the "TCP ports" inside to the 1433,IP2 address to your own local ip,tcp dynamic port to empty.

If you still do not know how to change, you can click on the "MSSQLSERVER protocol" of the "TCP/IP", where the side has been changed to 1433 port, the direct reference to change the same.

3. Restart SQL Server services, such as:

4. Turn on SQL Server to log in directly with the IP address.

Note: SQL Server needs to be set to allow remote connections to this server. Most are allowed, just in case some settings are not allowed, for the sake of safety.

If the external network remote connection, but also pay attention to the firewall, or can not connect, as long as the 1433 port into the firewall "inbound rules".

SQL Server name changed to local IP address login