User's Manual

5.5
SQL Connectivity Test
3PAR Recovery Manager 3.0.2 for Microsoft SQL Server User’s Guide
3PAR Confidential
If the connection can be made, you can safely ignore the rest of this chapter.
However, if the connection cannot be made you must fix your SQL configuration environment.
5.3.1 Troubleshooting SQL Connectivity
The system administrator must log onto the SQL production server and check the following:
■ From the SQL production server, launch the SQL Server Management Studio to make sure
the connection can be made locally.
■ From the Management Studio, right-click on SQL server > Properties > Connections.
Make sure the box for Allow remote connections to this server is checked.
■ Make sure the SQL service for that instance is in the started status.
■ For named instances, make sure the SQL Server Browser service is in the started status.
■ Double check the settings under Properties > Security.
■ Double check the settings under Properties > Permissions.
Once you have fixed your configuration, log back onto the backup server and run the SQL
connectivity test again.
NOTE: Your backup server must pass this SQL connectivity test in order to use
Recovery Manager for SQL.