Hi,
Analysis Services 2005 and SQL Server 2005
Using AMO I'm trying to add a local user to an Analysis Services database Role that I created but I keep getting the error "No mapping between account names and security IDs was done". I can add the user to the Role with no problem using SQL Server Management studio, but if I try to add the user using AMO I get that error.
The local user that I'm trying to add belongs to both the local User and Administrator groups. I've added a logon for this local user to the corresponding SQL Server database that the Analysis Services database datasource points to, but still no luck.
Am I missing something? I've been doing this for the last three months with network users without a problem so this is completely frustrating me. Especially the fact that I can add them using the SQL Server Management Studio GUI.
Here's the basic code that I'm doing. Pretty straightforward.
private bool AddUserToAnalysisServicesRole(Role role)
{
string user = @."pdxvincentm02\testuser";
RoleMember rm = new RoleMember(user);
role.Members.Add(new RoleMember(user)); // e.g. redmond\johndoe
role.Update(); // << KABOOM!!! No mapping between ......
Help. Thanks
I have not had a chance to try this in C# yet, but I did a quick test in powershell using the following pattern and it worked.
role.Members.add("pdxvincentm02\testuser")
role.Update()
It's possible that the role.Members.Add() function has another overload that works a bit differently. But another though also occurred to me. Where is this code being executed from? Is it possibly running under an account that does not have permission to verify the account? (eg. is it running from an ASP.NET app running as local system?)
No comments:
Post a Comment