Hi,
I wan't to migrate from Oracle to an Azure SQL database with the SQL Server Migration Assistant for Oracle.
I've created a database in Azure and can connect to this database with the Management Studio and the Azure Data Studio. Now I wan't to connect to this database with the Migration Assistant but after the click on connect I receive the message:
"You do not have permission to use the specified default database."
'[myazuredatabase].[dbo]' will be used for the default schema mapping.
And in the tree I can see that I'm connected to the Azure SQL server and I can see the master database and schemas but for [myazuredatabase] I see nothing only a warning 'Current user has no access to the database'.
The use I use is the one which is created in azure during database setup. I also tried the following steps without success: https://azure.microsoft.com/en-us/blog/adding-users-to-your-sql-azure-database/
Has anyone an idea to solve this issue?
Thanks