Learn how to install and configure SQL Server Management Studio, download a SQL Server, and connect them on a Windows 11/10/Server computer..

6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.

Now, enter your SQL Server's name and choose the authentication type that you want to use. If necessary, enter the credentials to be used for SQL Server authentication.

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups.