You are here: Application Interface > File menu > Open Database

Open database

You can open an existing SQL Server Express LocalDB or SQL Server database. Concept Link IconSee Also

Step 1 : Database type Selection.

Option Description
Microsoft SQL localdb database Select this radio button to open an existing SQL Server Express LocalDB database.
Microsoft SQL Server database Select this radio button to open an existing SQL Server database.

Step 2 : SQL Server Express LocalDB database

Select the LocalDB database to open and click OK.

Option Description
Database type Microsoft SQL localdb
File name Full path to the .mdf file. The default value of this field is the path to the last opened database
Description Description of the database (optional)

Step 2 : SQL Server database.

SQL Server database connection information

Option Description
Database type Microsoft SQL Server database
Server name Name of the SQL server\instance

Note: if using SQL Express, enter localhost\SQLEXPRESS.
Database name Name of the SQL database

Note: the drop-down list contains all detected compatible databases found on the selected SQL server.
Authentication You can either authenticate using Windows authentication, or SQL Server authentication.

Note: if you do not which method to use, ask your database administrator.

  • Windows authentication: The current account and password are used to connect to the SQL server.
  • SQL Server authentication: You must specify a login and a password to connect to the SQL server.
Description Description of the database (optional).
Enable MultiSubnetFailover Select this check box if you use AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances in SQL Server.
of