I have a database created in SSMS, which uses Windows Authetication
, the problem is that I want to upload it to Azure but this error appears:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------ ADDITIONAL INFORMATION:
The connection is broken and recovery is not possible. The client driver attempted to recover the connection one or more times and all attempts failed. Increase the value of ConnectRetryCount to increase the number of recovery attempts. (Microsoft SQL Server, Error: 0)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
Cannot open database "SIKOR" requested by the login. The login failed. Login failed for user 'IKOR'. (Microsoft SQL Server, Error: 4060)
- I already added the IP to the firewall
- I already verified that I have the password and username correct and the server created in Azure is correct, in fact I can connect to SSMS, using the same credentials.
Why can't I continue? Is it authentication?
Azure SQL Database only uses SQL Authentication and Azure Active Directory-based authentications. To upload it to Azure I recommend the Data Migration Assistant tool , which is the easiest way to upload a database to Azure SQL Database.