Azure SQL Database Creation - connect from Visual Studio and SQL Server Part 3

Описание: Azure SQL Database Creation - connect from Visual Studio and SQL Server management studio - Part 3

Part 1- Explains what are the various options available on Azure for Database. Also compares between Azure SQL vs Managed instance vs SQL VM
Part -2 Azure SQL database creation
Part 3- Connect to Azure SQL from SQL Server , Connect to Azure SQL from Visual Studio

Error solve -
Cannot open database requested by the login. The login failed.
Login failed for user (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdNa...
------------------------------
Server Name: databaseservername.database.windows.net
Error Number: 4060
Severity: 11
State: 2
Line Number: 65536

System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
------------------------------

My aim is to simplify the various technical architectures, technical terminology and cloud terms for beginners. Also to help the developers to transform to architects.

Please feel free to e-mail me @ [email protected] for any of my presentations.