FIX: "The user does not have permissions or the object ID is not valid" error when you publish a member in MDS

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use) SQL Server 2014 Express - duplicate (do not use) SQL Server 2014 Express - duplicate (do not use) SQL Server 2014 Web - duplicate (do not use) SQL Server 2014 Web - duplicate (do not use) More...Less

Symptoms

Assume that you use the Microsoft SQL Server 2014 MDS Add-in for Excel to connect to a Master Data Services repository. When you publish a member for which the code field contains non-breaking spaces, you receive the following error message:

The user does not have permissions or the object ID is not valid.

Note This issue doesn't occur when you add or edit members in the MDS Explorer.

Resolution

Cumulative update information

The issue was first fixed in the following cumulative update of SQL Server 2014:

Cumulative Update 5 for SQL Server 2014 SP1

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server 2014: