Now, change the EMERGENCY mode to ONLINE mode by using the below command: DATABASE database14 SET ONLINE Refresh the database server. Now, you can connect to the database. If the DBCC CHECKDB command ...

Figure 2. Successful Azure PowerShell Connection Output. Although this next step might have been set for other reasons, you must have a server firewall rule setup to allow incoming SQL connections ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.

"After installing this update, apps that use ODBC connections through Microsoft ODBC SQL Server Driver (sqlsrv32.dll) to access databases might not connect," Microsoft said.