The URL is not available, does not reference a SharePoint site, or you do not have permission to connect

Advertisement
I am trying to connect SharePoint URL in dashboard designer,it prompt's a message

"The URL is not available, does not reference a SharePoint site, or you do not have permission to connect"

To know the more information about this
Checked the Event logs ->Event Viewer ->Windows Logs->Application logs

I am getting Error message

SQL database login for 'SharePoint_Config' on instance 'DBServerName' failed. Additional error information from SQL Server is included below.
Login failed for user 'domain\userName'.

This account dont have permissions on the SQL database.
Run this below script in SharePoint 2013 Management Shell

$w = Get-SPWebApplication ("Web Application Name")
$w.GrantAccessToProcessIdentity("domain\userName")

This command will do the following

Creates a domain\userName as a new user for the DB associated with the web application Name.
Assigns db_owner role to domain\userName
It will creates a new schema for domain\user Name


Advertisements
SHARE

Lakshmi Tulasi Jasti

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

1 comments: