Hi Guys,

The Umbraco Installation wizard is showing when for some reason my database is unavailable. Do you know if I'm missing any settings?

It should throw an error and not launch the wizard.

It's happening to me both on our servers and also on Azure;

Error: "Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open server 'XXXX' requested by the login. Client with IP address 'XXXX' is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run spsetfirewallrule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect.\r\n at Microsoft.Data.ProviderBase.DbConnectionPool.CheckPoolBlockingPeriod(Exception e)\r\n at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)\r\n at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)\r\n at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions)\r\n at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)\r\n at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)\r\n at Microsoft.Data.SqlClient.SqlConnection.Open()\r\n at NPoco.Database.OpenSharedConnectionImp(Boolean isInternal)\r\n at NPoco.Database.OpenSharedConnectionInternal()\r\n at NPoco.Database.BeginTransaction(IsolationLevel isolationLevel)\r\n at Umbraco.Cms.Infrastructure.Scoping.Scope.getDatabase()\r\n at Umbraco.Cms.Infrastructure.Scoping.Scope.getDatabase()\r\n at Umbraco.Cms.Infrastructure.Persistence.Repositories.Implement.RepositoryBase.getDatabase()\r\n at Umbraco.Cms.Infrastructure.Persistence.Repositories.Implement.AuditRepository.CleanLogs(Int32 maximumAgeOfLogsInMinutes)\r\n at Umbraco.Cms.Core.Services.Implement.AuditService.CleanLogs(Int32 maximumAgeOfLogsInMinutes)\r\n at Umbraco.Cms.Infrastructure.HostedServices.LogScrubber.PerformExecuteAsync(Object state)\r\n at Umbraco.Cms.Infrastructure.HostedServices.RecurringHostedServiceBase.ExecuteAsync(Object state)\r\nClientConnectionId:c3507b3c-2fe0-4644-a0f0-4d8337806d0a\r\nError Number:40615,State:1,Class:14\r\nClientConnectionId before routing:2833653d-73fe-481b-b4b2-68dbde742576\r\nRouting Destination:fea238d2f789.tr721.southafricanorth1-a.worker.database.windows.net,11062"