Previous Topic: Install SQL Server 2008 R2 Standard ClientNext Topic: How to Create an SQL Alias

SQL Configuration › Install SQL Server 2008 R2 Standard Client › Verify SQL Connectivity

Verify SQL Connectivity

Follow these steps:

  1. Open Microsoft SQL Server Management Studio.
  2. Enter the hostname of the SQL Server machine in the Server Name.
  3. Change Authentication to SQL Server Authentication.
  4. Enter the credentials for the SQL Administrator account (sa).
  5. Click Connect.

Note: If the remote connection cannot be made, the following modification must be done to the SQL Server machines Windows Firewall.