Preparations before deploying SQL Server on the new Server

Source: Internet
Author: User

Preparations before deploying SQL Server on the new Server

When you need to deploy a new server, you may encounter many mistakes if you have no deployment experience, and make the maintenance work more difficult in the future, here I will share some of my server deployment experience with you.

1. After logging on to the server, format the physical disk in 64 K format as the allocation unit.

Because sqlserver data is stored by PAGE, one page is 8 k, and the eight pages are exactly a zone, that is, 64 k, everyone knows this (I admit that I have never tested the actual effect and whether it is useful ).

2. Modify the server name.

It is best to change the machine name to a machine name to know which business is located, which machine room is located, and which machine is located. Try not to use the default one, which will be good for ssms queries or interactions between various servers in the future.

I remember that the machine name was to be restarted (this has not been done for a long time, but I cannot remember--). When you have installed the sqlserver service, you can modify the machine name, by default, the database still uses the previous machine name and has to execute command modification. Therefore, it is best to change it when you take over the server, saving trouble for the future.

3. Modify the server password.

It is best to open two remote Windows A and B at the same time, use window A to change the password, then click Save to close the connection, and then open A new remote desktop and enter the new account password to try again, right. (Keep window B because you still have the opportunity to change the password in window B if the password in window A is incorrect ).

4. Check the default OS language in the control panel.

This will affect the default sorting rules for SQL Server installation.

5. ipconfig: Check whether you have allocated the Intranet and Internet ip addresses you want, and whether the ip addresses are configured incorrectly.

6. If you do not want to use the default port of sqlserver, add rules to the firewall in advance.


The above are some of my server deployment experiences, which are of low level and limited technology. I will share them with you. If you have any errors or need to add them, please refer to them.

This article permanently updates the link address:

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.