Skip to main content

Creating a Local SQL Database

Prerequisites​

To use VIM Enterprise with a local SQL Server database, you will need to install the following software:

A separate database is required for each VIM Enterprise project. It's a good idea to name each database based on the corresponding VIM Enterprise project.

Each VIM Enterprise project will require the corresponding SQL database connection string, which includes the database name.

NOTE: If you are using a local SQL database and intend to have peers update Power BI reports, then they will also require access to the database.

If you want to create an Azure SQL database, see Creating an Azure SQL database.

Installing the SQL Server Software​

Download the software using the links provided above.

  • To install SQL Server 2022 Express, double-click on SQL2022-SSEI-Expr.exe. When prompted, choose the Basic installation.
  • To install Microsoft SQL Server Management Studio, double-click on SSMS-Setup-ENU.exe.

Connecting to the SQL Server​

  1. Click the Windows Start menu, go to Microsoft SQL Server Tools 20, and click SQL Server Management Studio 20.
  2. In the Connect to Server dialog, click the Server type drop-down menu and choose Database Engine.
    Connect to Server
  3. Click the Server name drop-down menu and choose the locally running SQL Server (<computer_name>\SQLEXPRESS).
  4. Click the Authentication drop-down list and choose Windows authentication.
  5. Click the Encryption drop-down menu, choose Mandatory, and enable the Trust server certificate option.
  6. Click Connect.

Creating a SQL Server Database​

  1. In the Object Explorer, right-click on Databases and choose New database.
    Object Explorer
  2. In the New Database dialog, type a Database name and click OK.
    New Database The new database will be listed in the Object Explorer under the Databases list.
    New Database list

When you create a VIM Enterprise project, you will need the database connection string to your local SQL database. Copy the database string below, but replace __db_name__ with the name of the database you will be using in your VIM Enterprise project.

Data Source=localhost\SQLEXPRESS;Initial Catalog=__db_name__;Integrated Security=SSPI;TrustServerCertificate=True;

A separate database is required for each VIM Enterprise project. To create additional SQL Server databases, you only need to repeat the steps in this section.