You can't create new tables in an Access web app

Symptoms

When you create a new table and then try to save it in a Microsoft Access app, you receive the following error message:

An error has occurred

This issue occurs if the app is hosted in an on-premises SharePoint environment. Additionally, the ULS logs contain the following entries at the respective logging levels:

Exception:

ApplicationDesignService.CreateAccessObjectImpl: Failed due to exception: {System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable.

VerboseEx:
SqlCommand StackTrace-Managed:
at Microsoft.Office.Server.Data.SqlSession.OnPreExecuteCommand(SqlCommand command)
at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)
at Microsoft.Office.Access.Services.Database.RetryableSqlCommand.ExecuteNonQuery()
at Microsoft.Office.Access.Services.Database.SqlClientExtensions.ExecuteNonQueryLogged(SecureSqlCommand command, SqlCommandScope scope)
at Microsoft.Office.Access.Services.Design.Table.<>c__DisplayClass4.<Create>b__1()
at Microsoft.Office.Access.Services.SqlRetryUtil.ExecuteTransactionalSession(TransactionalSession session, ISqlConnectionFactory sqlConnection)
at Microsoft.Office.Access.Services.Design.Table.Create()
at Microsoft.Office.Access.Services.DataServer.WebService.AccessServiceSoap.CreateAccessObjectImpl(String name, String description, AccessObjectType objectType, XmlNode body, ServiceError& createError) ...


Cause

This issue occurs because the Guest user account has been disabled for the msdb system database on the SQL Server computer that's being used as Access service's Application Database Server (ADS).

Resolution

To resolve this issue, follow these steps:
  1. Open SQL Server Management Studio (SSMS).
  2. Connect to the SQL Server instance that's being used as the Access service's Application Database Server (ADS).
  3. Create a new query.
  4. Copy the following two lines of text and paste them into the query:

    USE msdb
    GRANT CONNECT TO GUEST
     
  5. Run the query.
Властивості

Ідентифікатор статті: 3175862 – останній перегляд: 6 лип. 2016 р. – виправлення: 1

Зворотний зв’язок