| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | f1_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
Connect to SQL Server (OracleToSQL) |
Connect to SQL Server (OracleToSQL) |
cpichuka |
cpichuka |
01/19/2017 |
sql |
ssma |
conceptual |
|
|
Use the Connect to SQL Server dialog box to connect to the instance of [!INCLUDEssNoVersion] that you want to migrate to. To access the Connect to SQL Server dialog box, on the File menu, click Connect to SQL Server.
Server name
Enter or select the instance of SQL Server to connect to. By default, the instance that you connected to most recently is displayed.
-
If you're connecting to the default instance on the local computer, you can enter either localhost or a dot (.).
-
If you're connecting to the default instance on another computer, enter the name of the computer.
-
If you're connecting 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion].
Authentication
Select the authentication method that is used to connect to [!INCLUDEssNoVersion]. To use your current Windows account, select Windows Authentication. To specify a [!INCLUDEssNoVersion] login and password, select [!INCLUDEssNoVersion] Authentication.
User name
If you're using [!INCLUDEssNoVersion] Authentication, enter the login for that instance of [!INCLUDEssNoVersion]. If you're using Windows Authentication, this option isn't available.
Password
If you're using [!INCLUDEssNoVersion] Authentication, enter the password for the login on that instance of [!INCLUDEssNoVersion]. If you're using 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.