question

ShubhiJain-1835 avatar image
0 Votes"
ShubhiJain-1835 asked ShubhiJain-5090 commented

Migration From on-premises to Azure SQL Managed Instance using LRS

https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/log-replay-service-migrate
using this above link I have done the migration in autocomplete mode and the database has been created in Azure SQL Managed Instance successfully, but while querying it in SSMS I am facing Error 4060; Login failed.
I don't know why I am getting this error.
Please Help .

azure-sql-databaseazure-sql-virtual-machines
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

OuryBa-MSFT avatar image
0 Votes"
OuryBa-MSFT answered ShubhiJain-5090 commented

Hello @ShubhiJain-1835, Welcome to Microsoft Q&A and Thank you for posting this question.


What type of authentication are you using SQL authentication or AAD.?

Migration may not be fully completed . Could you please try the workaround below

  1. Try to disconnect from the server

  2. Close SSMS and try to connect again

Please let us know if that works!!

Thanks
Oury Ba

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ShubhiJain-1835,

Did you had the chance to try the above workaround. Please let us know if any help is needed

Thanks

Regards

Oury Ba

0 Votes 0 ·

Hello @OuryBa-MSFT ,

Migration was fully complete and I guess the issue was with SQL Server agent. I am not sure about it. So I am working on it.


Thanks for your help
Regards
Shubhi Jain

0 Votes 0 ·