SQL Server is unavailable

This article explains how to handle the issue with SharePoint farm load not working properly because the SQL server was not available.

Problem

While loading a SharePoint farm the following error message was displayed in the event log:

SQL Server ‘Server Name’ is unavailable. Please check your permissions.

Solution

The user running SPDocKit Snapshot Wizard or SPDocKit PowerShell needs to be granted rights to connect to the server for which this exception appears.

Here is how to do it:

1. Create a new login for each of these accounts on the SQL server for which this exception appears.

2. Select User Mapping tab and grant them the db_datareader and public rights on the master database.