Cannot open server 'ocha-ftsops-prod' requested by the login. Client with IP address '40.70.129.126' is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule 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. at 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.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at CAPprojects.OPS.ProjectRevision.DataLayer.ProjectDetailDAL.GetAppealRevisionStartDate(Int32 AppealId) in D:\TFS\CAP\OPS-AsposeReports\CapProjects\DAL\ProjectDetailDAL.vb:line 64 at CAPprojects.OPS.ProjectRevision.BusinessLayer.ProjectDetailBAL.GetAppealRevisionStartDate(Int32 AppealId) in D:\TFS\CAP\OPS-AsposeReports\CapProjects\BLL\ProjectDetailBAL.vb:line 189 at CAPprojects.OPS.ProjectRevision.HelperClasses.ProjectDetailHelper.GetCommandType(Int32 projectid, Int32 appealid) in D:\TFS\CAP\OPS-AsposeReports\CapProjects\HelperClasses\ProjectDetailHelper.vb:line 44 at CAPprojects.PublicReports.LoadProjectReport(Int32 ProjectId, Int32 AppealId) in D:\TFS\CAP\OPS-AsposeReports\CapProjects\Reports\PublicReports.aspx.vb:line 51 at CAPprojects.PublicReports.Page_Load(Object sender, EventArgs e) in D:\TFS\CAP\OPS-AsposeReports\CapProjects\Reports\PublicReports.aspx.vb:line 24