Skip to content

connect-to-sql-server-db2tosql.md

Latest commit

 

History

History
61 lines (39 loc) · 2.9 KB

connect-to-sql-server-db2tosql.md

File metadata and controls

61 lines (39 loc) · 2.9 KB
title Connect to SQL Server Dialog (Db2ToSQL)
description Use the Connect to SQL Server dialog box to connect to the instance of SQL Server that you want to migrate to, for SSMA for Db2.
author nilabjaball
ms.author niball
ms.reviewer randolphwest
ms.date 09/24/2024
ms.service sql
ms.subservice ssma
ms.topic concept-article
ms.collection
sql-migration-content
f1_keywords
ssma.db2.connectmssqlform.f1

Connect to SQL Server dialog (Db2ToSQL)

Use the Connect to SQL Server dialog box to connect to the instance of [!INCLUDE ssNoVersion] that you want to migrate to. To access the Connect to SQL Server dialog box, navigate to File > Connect to SQL Server.

Options

Server name

Enter or select the instance of SQL Server instance you're connecting to. By default, the instance that you connected to most recently is displayed.

  • If you connect to the default instance on the local computer, you can enter either localhost or a dot (.).

  • If you connect to the default instance on another computer, enter the name of the computer.

  • If you connect to a named instance on another computer, enter the computer name, a backslash, and the instance name, such as <MyServer>\<MyInstance>.

Server port

If your instance of [!INCLUDE ssNoVersion] isn't configured to accept connections on the default port (1433), enter the port number. Otherwise, leave this value blank.

Database

Specify the database to migrate objects and data to. This option isn't available when reconnecting to [!INCLUDE ssNoVersion].

Authentication

Select the authentication method that is used to connect to [!INCLUDE ssNoVersion]. To use your current Windows account, select Windows Authentication. To specify a [!INCLUDE ssNoVersion] login and password, select [!INCLUDE ssNoVersion] Authentication.

User name

If you use [!INCLUDE ssNoVersion] Authentication, enter the login for that instance of [!INCLUDE ssNoVersion]. If you use Windows Authentication, this option isn't available.

Password

If you use [!INCLUDE ssNoVersion] Authentication, enter the password for the login on that instance of [!INCLUDE ssNoVersion]. If you use Windows Authentication, this option isn't available.

Encrypt connection

If you want to securely connect to SQL Server, make use of Encrypt connection by checking the Encrypt connection checkbox.

Trust Server Certificate

If you want to use this option, select the Trust Server Certificate checkbox.

Note

To enable Trust Server Certificate, Encrypt must be set to True.