I am not able to connect to Azure sql database using ssma The error in the error logs is as follows

Dominic Joseph 1 Reputation point
2022-04-02T21:54:30.057+00:00

[Error: Generic] [12832/22] [2022-04-03 03:02:42]: Failed to collect metabase data.
[Error: Generic] [12832/22] [2022-04-03 03:02:42]: Exception: The current project mode does not support connection to SQL Server. To connect to a SQL Server instance, create a SQL Server project.
site: Microsoft.SSMA.Framework.SqlServer.Base.Connection.SsmaSqlConnection ConnectToSqlServer(Microsoft.SSMA.Framework.SqlServer.Collector.SqlQueryProvider.SqlServerQueryProviderManager, System.String, System.Security.SecureString, System.Data.IDbConnection, Microsoft.SSMA.Framework.Generic.Collectors.ICollectionContext, Boolean)
source: Microsoft.SSMA.Framework.SqlServer.Generic
at Microsoft.SSMA.Framework.SqlServer.Collector.SqlServerObjectCollector.ConnectToSqlServer(SqlServerQueryProviderManager queryManager, String connectionParameters, SecureString password, IDbConnection implicitConnection, ICollectionContext context, Boolean includeDatabase)
at Microsoft.SSMA.Framework.SqlServer.Collector.SqlServerObjectCollector.CollectData(String connectionParameters, SecureString password, XMetabase existingMetabase, ICollectionContext context, IDbConnection implicitConnection, XNode filter)
at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
[Error: Gui] [12832/22] [2022-04-03 03:02:51]: LowLevelAdapter.ReadTarget : Read Target error: Microsoft.SSMA.Framework.Generic.Collectors.UnsupportedVersionException: The current project mode does not support connection to SQL Server. To connect to a SQL Server instance, create a SQL Server project.
at Microsoft.SSMA.Framework.SqlServer.Collector.SqlServerObjectCollector.ConnectToSqlServer(SqlServerQueryProviderManager queryManager, String connectionParameters, SecureString password, IDbConnection implicitConnection, ICollectionContext context, Boolean includeDatabase)
at Microsoft.SSMA.Framework.SqlServer.Collector.SqlServerObjectCollector.CollectData(String connectionParameters, SecureString password, XMetabase existingMetabase, ICollectionContext context, IDbConnection implicitConnection, XNode filter)
at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.TargetMetabaseWorkspaceItem.Connect(String connectionParameters, SecureString password)
at Microsoft.SSMA.GUI.Product.AccessToMsSql.LowLevel.Commands.AppConnectToTargetMsSql.ConnectToTargetStart(Object guiContext)
[Error: Gui] [12832/22] [2022-04-03 03:02:51]: Exception: The current project mode does not support connection to SQL Server. To connect to a SQL Server instance, create a SQL Server project.
site: Microsoft.SSMA.Framework.SqlServer.Base.Connection.SsmaSqlConnection ConnectToSqlServer(Microsoft.SSMA.Framework.SqlServer.Collector.SqlQueryProvider.SqlServerQueryProviderManager, System.String, System.Security.SecureString, System.Data.IDbConnection, Microsoft.SSMA.Framework.Generic.Collectors.ICollectionContext, Boolean)
source: Microsoft.SSMA.Framework.SqlServer.Generic
at Microsoft.SSMA.Framework.SqlServer.Collector.SqlServerObjectCollector.ConnectToSqlServer(SqlServerQueryProviderManager queryManager, String connectionParameters, SecureString password, IDbConnection implicitConnection, ICollectionContext context, Boolean includeDatabase)
at Microsoft.SSMA.Framework.SqlServer.Collector.SqlServerObjectCollector.CollectData(String connectionParameters, SecureString password, XMetabase existingMetabase, ICollectionContext context, IDbConnection implicitConnection, XNode filter)
at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)
at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.TargetMetabaseWorkspaceItem.Connect(String connectionParameters, SecureString password)
at Microsoft.SSMA.GUI.Product.AccessToMsSql.LowLevel.Commands.AppConnectToTargetMsSql.ConnectToTargetStart(Object guiContext)
[Error: Generic] [12832/5] [2022-04-03 03:06:22]: Failed to collect metabase data.
[Error: Generic] [12832/5] [2022-04-03 03:06:22]: Exception: The current project mode does not support connection to SQL Server. To connect to a SQL Server instance, create a SQL Server project.
site: Microsoft.SSMA.Framework.SqlServer.Base.Connection.SsmaSqlConnection ConnectToSqlServer(Microsoft.SSMA.Framework.SqlServer.Collector.SqlQueryProvider.SqlServerQueryProviderManager, System.String, System.Security.SecureString, System.Data.IDbConnection, Microsoft.SSMA.Framework.Generic.Collectors.ICollectionContext, Boolean)
source: Microsoft.SSMA.Framework.SqlServer.Generic
at Microsoft.SSMA.Framework.SqlServer.Collector.SqlServerObjectCollector.ConnectToSqlServer(SqlServerQueryProviderManager queryManager, String connectionParameters, SecureString password, IDbConnection implicitConnection, ICollectionContext context, Boolean includeDatabase)
at Microsoft.SSMA.Framework.SqlServer.Collector.SqlServerObjectCollector.CollectData(String connectionParameters, SecureString password, XMetabase existingMetabase, ICollectionContext context, IDbConnection implicitConnection, XNode filter)
at Microsoft.SSMA.Framework.Generic.Collectors.Default.DefaultObjectCollector.CollectData(String connectionParameters, SecureString password, ICollectionContext context)
at Microsoft.SSMA.Framework.Generic.SSMAWorkspace.MetabaseSsmaWorkspaceItem.Connect(String connectionParameters, SecureString password)

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
503 questions
{count} votes