This article will assist you to create MS SQL database through SQL Server Management Studio.
- Open Run box by pressing Windows key + R.
- In Run box type SSMS and hit enter. This will open connect to server window.
- Enter following details in connect to server window.
- Server type == Database Engine
- Server name == SQL-Server-IP-address,1533
- Authentication == SQL Server Authentication
- Login == sa
- Password == password of 'sa' user.
- You are connected to MS SQL Server. Now, under Object Explorer, right-click on Databases and click on New Database.
- In New Database window, enter a database name.
- If you want to create database with default values, click OK, otherwise refer to following steps.
- If you want to change the default value of the primary data and transaction log files, in the Database files , click the appropriate field and enter your desired value.
- If you want to change the collation of database, select Options page in left hand side pane and select a collation of your choice from the list.
- Similarly, you can change the recovery model and compatibility mode of your choice from Options page.
- You can add new filegroup under Filegroups page. From here, click Add and enter the values for the filegroup.
- Click OK to create the database.
