You must specify the connection string to your SQL Server, including the server's name that SQL Server is running on and the name of the instance, the database, and the relevant user account.
For example:
- Server=MyServer\BCDEMO;Database=BC170;User Id=MySQLAccount;Password=MyPassword;
-
Server=MyServer\SQLEXPRESS;Database=BC170;User Id=MySQLAccount;Password=MyPassword;
For more information, see the SQL Server blog.
-
The following examples illustrate a couple of connection strings with different formats:
-
Server={Server Name\Instance Name};Initial Catalog={Database Name};User Id={SQL Authenticated UserName};Password={SQL Authenticated Password};
-
Server={Server Name\Instance Name};Database={Database Name};User Id={SQL Server Authenticated UserName};Password={SQL Server Authenticated Password};
-
See more examples: https://www.connectionstrings.com/sql-server/
The SQL connection string is passed to Azure Data Factory (ADF). It is encrypted and delivered to your Self-Hosted Integration Runtime and used to communicate with your SQL Server instance during the data migration process.