This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 91%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 65%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Hello,
Make sure you select "Azure SQL Database" as your target when you create a new project in SSMA. Also, check that default database for the user is set correctly.
Finally, it would be helpful to collect debug logs from SSMA. Navigate to Tools -> Global settings -> Logging and switch all to debug. Path to the log file will be displayed in the same dialog.
Regards,
Alex.
Hi Alex,
thank you very much you helped me a lot! I was blind I have choosen the wrong target I had Azure SQL Managed Database instead of Azure SQL Database. With this change the migration worked like charme.
Have a nice weekend
Jens
Please add the SQL login you are using to connect to the Azure SQL database to the dbmanager role as shown below T-SQL code:
CREATE LOGIN login1 WITH password='<ProvidePassword>';
EXEC sp_addrolemember 'dbmanager', 'login1';
Hi Alberto,
thanks with the roles everything is fine.
Best regards
Jens