Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to change SA password and default port number in SQL Server database. The content of the article is of high quality, so Xiaobian shares it with you as a reference. I hope you have a certain understanding of relevant knowledge after reading this article.

SQL Server Database How to Change SA Passwords and Default Port Numbers

1. Change SA password

execsp_passwordnull,'000','sa'--Change sa password to 000

Second, change SQL SERVER default port

The SqlServer service uses two ports: TCP-1433 and UDP-1434. 1433 is used for SqlServer to provide external services, and 1434 is used to return to the requester which TCP/IP port SqlServer uses. You can change the default TCP port for SQL Server using Enterprise Manager for SQL Server. The method is as follows:

a. Open Enterprise Manager, select "Microsoft SQL Servers-SQL Server Group" in the left toolbar, open the properties dialog box of "SQL Instance"(the name of SQL Server to be modified in actual environment), click "Network Configuration (N)" button at the bottom of "General tab", and you can open the "SQL Server Network Usage Tools" dialog box. (Computer restart required).

b. There is TCP/IP protocol in the "Enabled Protocols" list. Enter the port number to be modified in the default port option in the attribute to modify it. There is also a hidden server, if selected, it means that the client can not see this server by enumerating servers, play a protective role, and does not affect the connection.

The SqlAgent service uses TCP-1625 and TCP-1640 ports to provide services.

3. SQL query analyzer, access 1433 through port 1601, connect to SqlServer

ADO connection string specifies port number

Provider=SQLOLEDB.1;Password=000;PersistSecurityInfo=True;UserID=sa;InitialCatalog=pubs;DataSource=192.168.1.106,3002//Specify port 3002

How to change SA password and default port number in SQL Server database is shared here. I hope the above content can be of some help to everyone and learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.