How do I create a SQL database using SQL Server Management Studio

How do I create a SQL database using SQL Server Management Studio

How do I create a SQL database using SQL Server Management Studio?

Modified on: Thurs, 19 Mar, 2026 at 11:04 AM

Overview

SQL Server Management Studio (SSMS) is an integrated environment used to manage SQL infrastructure, including SQL Server, Azure SQL Database, and SQL Data Warehouse.
For LinkFixer Advanced, SSMS can be used to create and configure the required database.

Step 1: Download and Install SSMS

1. Download SQL Server Management Studio from the official Microsoft website.
2. Run the installer and complete the installation process.

Step 2: Launch SSMS

  1. Open SQL Server Management Studio.
  2. Connect to your SQL Server instance using your credentials.

Step 3: Create a New Database

1. In Object Explorer, right-click on Databases.
2. Select New Database.

Step 4: Configure the Database

Enter a name for your database and configure the following recommended settings:
  1. SQL Database initial size: 1 GB or more
  2. SQL Log initial size: 500 MB or more
  3. Database Autogrowth: 250 MB or more
  4. Log Autogrowth: 250 MB or more
Click OK to create the database.

Step 5: Connect LinkFixer Advanced to SQL Server

1. Open LinkFixer Advanced.
2. Navigate to:
      Main Menu (☰) → Settings → Database → Change Settings
3. Update the following:
      Change the database type from SQLite to SQL Server
      Enter your Server Name
      Choose Windows Authentication (if you have appropriate access)
      Select your newly created database from the dropdown
      Click Test Connection to verify connectivity
4. Click OK to save your settings.

  1. Optimizing LinkFixer Advanced performance
  2. SQL Server requirements for LinkFixer Advanced

If you encounter connection issues, verify your server name, permissions, and network accessibility before retrying.