Skip to content
  • There are no suggestions because the search field is empty.

Discover a Microsoft SQL Server database

Please first read how to use the Discovery Application.

Discover a Microsoft SQL Server database

To discover a Microsoft SQL Server database with the Discovery Application, please choose the following source system type:

Then, fill in the following information:

The value examples below correspond to the source example explained in the Microsoft SQL Server target environment.

  • Name: discovery name
    • Example: ADW2019_Sales
  • Server: the host and the port (optional) to connect to the Microsoft SQL Server database
    • Example: localhost,1460

If you want to discover data from a Microsoft SQL Server database on Azure, put here the name of the Azure server, for example bgsqlserver.database.windows.net

  • Database: database name 
    • Example: AdventureWorks2019
  • Schema: schema name
    • Example: Sales
  • Authentication Type: 
     
    • Example: SQL Server Authentication
  • User: only when you select authentication type = SQL Server authentication 
    • Example: as
  • Password: only when you select authentication type = SQL Server authentication 
    • Example: Admin2022!

You need to enable the TCP/IP protocol to discover your SQL Server database. 

f you want to connect to another SQL Server instance than the default one (which is by default accessible on port 1433 as shown in the example below), you need to:

  • Open the SQL Server Manager for the version of this other instance. For this, execute the following command:
    • sqlservermanager15.msc for SQL Server 2019
    • sqlservermanager14.msc for SQL Server 2017
  • Under SQL Server Network Configuration > Protocols for + instance name, double-click on TCP/IP and open the IP Addresses tab
  • At the end of the list, assign a port other than the default one (1433) for IPAll in TCP Dynamic Ports:
  • Under SQL Server Services, right-click the service SQL SERVER (instance name) and choose Restart

The host_port value in the YAML configuration file should look similar to this:

host_port: 127.0.0.1:1451 #Adapt the post value

 

You can download an example of a discovery file here to start modeling, even if you don't have any access to this source system type.