question

MinaKIM-8581 avatar image
0 Votes"
MinaKIM-8581 asked ElsieLu-MSFT answered

Sharepoint Designer 2013 permission error and ECT error

Hello,
I use sharepont online and sharepoint designer2013 to create
external content type.
I have some errors about sharepoint designer 2013.

  1. "You do not have permission to open this web site in sharepoint Designer" pop up
    https://my-tenant.sharepoint.com/sites/<mysites>;/ ->this popup occured.
    But, https://my-tenant.sharepoint.com ->it's ok.

2.
So.. I used this URL(https://my-tenant.sharepoint.com)
and I entered 'External Content Types'..
<The Business Data Connectivity Metadata store is currently unavailable> popup occured..
106916-image.png

How can I fix these errors?


office-sharepoint-online
image.png (28.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered

Hi @MinaKIM-8581 , welcome to Q&A forum!

For your questions:

Q1:
Please follow the steps below and let us know the result.
1. Make sure you're using the same work and school account to sign in to SharePoint Designer 2013 and the SharePoint Online site. If not, go to SharePoint Designer, click File >Account > Switch Account to sign in with the correct account.
2. Make sure custom script is enabled in the affected site. You can enable custom script for the site using PowerShell command.

a. Download and install the SharePoint Online Management Shell from this article.
b. Launch SharePoint Online Management Shell (search and right click the "SharePoint Online Management Shell" and choose "Run as Administrator"), connect to SharePoint Online via the following commands using your Office 365 global admin account, turn Custom Script on in the affected site:

 Connect-SPOService -Url https://contoso-admin.sharepoint.com
    
 (replace contoso with your tenant domain)
    
 Set-SPOsite https://contoso.sharepoint.com -DenyAddAndCustomizePages 0

For your reference:
Turn scripting capabilities on or off
3. Make sure SharePoint designer is enabled in the site collection:
Site settings > SharePoint designer settings under Site Collection Administration > tick Enable SharePoint designer.

Reference:
You do not have permission to open this Web site in in SharePoint Designer
================================
Q2:
For more infomation about External Content Type in SharePoint Online, please refer to:
External Content Type in SharePoint Online
Create External Content Type in SP Online without SP Designer


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.