You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/integration-services/lift-shift/ssis-azure-connect-to-catalog-database.md
+6Lines changed: 6 additions & 0 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -50,15 +50,21 @@ Before you start, make sure you have version 17.2 or later of SQL Server Managem
50
50
|**Login**| The server admin account | This is the account that you specified when you created the server. |
51
51
|**Password**| The password for your server admin account | This is the password that you specified when you created the server. |
52
52
53
+
54
+
53
55
3.**Connect to the SSISDB database**. Select **Options** to expand the **Connect to Server** dialog box. In the expanded **Connect to Server** dialog box, select the **Connection Properties** tab. In the **Connect to database** field, select or enter `SSISDB`.
54
56
55
57
> [!IMPORTANT]
56
58
> If you don't select `SSISDB` when you connect, you may not see the SSIS Catalog in Object Explorer.
57
59
60
+
61
+
58
62
4. Then select **Connect**.
59
63
60
64
5. In Object Explorer, expand **Integration Services Catalogs** and then expand **SSISDB** to view the objects in the SSIS Catalog database.
61
65
66
+
67
+
62
68
## Next steps
63
69
- Deploy a package. For more info, see [Deploy an SSIS project with SQL Server Management Studio (SSMS)](../ssis-quickstart-deploy-ssms.md).
64
70
- Run a package. For more info, see [Run an SSIS package with SQL Server Management Studio (SSMS)](../ssis-quickstart-run-ssms.md).
Copy file name to clipboardExpand all lines: docs/integration-services/lift-shift/ssis-azure-deploy-run-monitor-tutorial.md
+11-1Lines changed: 11 additions & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -26,7 +26,11 @@ Also make sure that you have set up the SSISDB database and provisioned the Azur
26
26
27
27
## Connect to the SSISDB database
28
28
29
-
Use SQL Server Management Studio to connect to the SSIS Catalog on your Azure SQL Database server. For more info, see [Connect to the SSISDB Catalog database on Azure](ssis-azure-connect-to-catalog-database.md).
29
+
Use SQL Server Management Studio to connect to the SSIS Catalog on your Azure SQL Database server. For more info and screenshots, see [Connect to the SSISDB Catalog database on Azure](ssis-azure-connect-to-catalog-database.md).
30
+
31
+
Here are the two most important things to remember. These steps are described in the following procedure.
32
+
- Enter the fully-qualified name of the Azure SQL Database server in the format **mysqldbserver.database.windows.net**.
33
+
- Select `SSISDB` as the database for the connection.
30
34
31
35
> [!IMPORTANT]
32
36
> An Azure SQL Database server listens on port 1433. If you are attempting to connect to an Azure SQL Database server from within a corporate firewall, this port must be open in the corporate firewall for you to connect successfully.
@@ -51,13 +55,19 @@ Use SQL Server Management Studio to connect to the SSIS Catalog on your Azure SQ
51
55
52
56
## Deploy a project with the Deployment Wizard
53
57
58
+
To learn more about deploying packages and about the Deployment Wizard, see [Deploy Integration Services (SSIS) Projects and Packages](../packages/deploy-integration-services-ssis-projects-and-packages.md) and [Integration Services Deployment Wizard](../packages/deploy-integration-services-ssis-projects-and-packages.md#integration-services-deployment-wizard).
59
+
54
60
### Start the Integration Services Deployment Wizard
55
61
1. In Object Explorer in SSMS, with the **Integration Services Catalogs** node and the **SSISDB** node expanded, expand a project folder.
56
62
57
63
2. Select the **Projects** node.
58
64
59
65
3. Right-click on the **Projects** node and select **Deploy project**. The Integration Services Deployment Wizard opens. You can deploy a project from an SSIS Catalog database or from the file system.
60
66
67
+
0 commit comments