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

This article mainly explains "how to modify the MSSQL port", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "how to modify the MSSQL port" bar!

Start-Program-Microsoft SQL Server-- Server Network Utility

-- enabled protocols-- Delete other protocols-- keep only the TCP/IP-- attribute-- default port

-- TCP/IP-- attribute-- default port-- enter 123

Restart the SQL service, then connect to SQL, and connect normally.

-- 2. View the authentication mode of SQL

Enterprise Manager-right SQL instance-Properties-Security-Authentication-shows that "only" is currently selected

-3. Modify the authentication mode of SQL

Enterprise Manager-right SQL instance-Properties-Security-Authentication-selected "Sql Server and Windows"-OK-prompt to restart SQL-- confirmation

Connect again and find that the connection can not be reached.

-- 4. Modify the configuration of the client

Start-Program-Microsoft SQL Server-- client Network Utility

-- alias-- add

-- Select "tcp/ip" for network library-- enter SQL server name for server alias

-- connection parameters-- enter the SQL server ip address in the server name

If you modify the port of SQL, deselect "dynamically determine Port" and enter the corresponding port number: 123

Connect again, successful

Thank you for your reading, the above is the content of "how to modify the MSSQL port", after the study of this article, I believe you have a deeper understanding of how to modify the MSSQL port, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.