Skip to main content

SQL Server is unavailable

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.
Last updated on