No mapping between account names and security IDs was done

Hi
I haven't done much with AS2005. Today I was trying to migrate an AS2000 cube to As2005 using Migration Wizard.

Existing AS2000 cube is on Windows 2000 Server (SP4). Destination server has Windows 2003 Server with June CTP.

Migration Wizard goes through the validating databases. During metadata migration I get the following error "The following system error occurred: No mapping between account names and security IDs was done."

I am running the OLAP Service on Win 2000 and 2003 Server under LocalSystem (might not be the best option).

Has anyone come across this before or know how to resolve it?

Thanks

SuthaAs Chris W suggested, I made a copy of the AS2K cube and removed the roles from the cube and then ran the migration wizard. The meta data migration was successful.

Thanks Chris

Sutha|||

Hi Folks,

i've had the same message in SSAS 2005 whilst trying to add a domain local group to the "Server Role".

e.g. Right click the server, select "Properties" and then select "Security".

Is it possible to add a windows group here or is it just restricted to users? The wording is "The server role is used to grant server-wide security privilages to a user".

If this is restricted to just user accounts, then how could i add a windows group (a group of users that are administrators) to a similar role?

Cheers,

Kyle.

|||

Hi,

PLEASE NOTE: My post above is now out of date! I tried adding the groups again and it worked fine.

In my place it can take up to 15 minutes for replication to occur on the domain so it looks like the account i created wasn't immediately visible!

Watch out for this one if you use domain replication on you domain servers!

Cheers,

Kyle.

No mapping between account names and security IDs was done

I can design a report fine in the Report Designer. I can build it fine. I can preview it fine. But, when I try to deploy it I get the error: No mapping between account names and security IDs was done

Any help will be appreciated.

Glenn,

Did you get past this error? I'm having the same issue now with my SQL Server Reporting Services / Report

No mapping between account names and security IDs was done

I can design a report fine in the Report Designer. I can build it fine. I can preview it fine. But, when I try to deploy it I get the error: No mapping between account names and security IDs was done

Any help will be appreciated.

Glenn,

Did you get past this error? I'm having the same issue now with my SQL Server Reporting Services / Report

No mapping between account name and security ID

Hi,

I created a user account on my active directory service. I then tried
to assign a service located on my SQL server to be executed by this
account. However, when I try to configure my SQL server service, I
get the following error message:

WMI Provider Error
"No mapping between account name and security ID was done"

Do you know what I am doing wrong?

thanksOn Jul 2, 8:57 pm, Zero <talltr...@.yahoo.comwrote:

Quote:

Originally Posted by

Hi,
>
I created a user account on my active directory service. I then tried
to assign a service located on my SQL server to be executed by this
account. However, when I try to configure my SQL server service, I
get the following error message:
>
WMI Provider Error
"No mapping between account name and security ID was done"
>
Do you know what I am doing wrong?
>
thanks

Hi,

Try giving the "WMI control" full permission and also the DCOM
settings as full permission.
then restart the WMI service.

No checkboxes on the Server Roles page for Logins

Hi,

There are no checkboxes when I view the Server Roles page under Security --> Login properties.

The page does work.If I highlight a role and click OK, the role is granted.

I have uninstalled and re-installed SQL Server 2005 Developer Edition, but there was no change.

Any help would be appreciated. Thank you.

Hi,

this does work for me. Are you sure that you are connected with a user which has the appropiate permissions to set the values ? Make sure that you are running the lastest service pack on your box, there have been some improvement (also in the UI) which might have caused the problem in the passed (don′t know about all the bugs being reported) The curretn version I am running on is 9.00.2047 (which is SP1 + posthotfixes)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Thank you for replying. We do not have approval to load the service pack and hot fixes, so I am running 9.0.1399.

This is a problem on the workstations where the standard edition was installed for testing purposes and then removed. Then the developer edition was installed. Workstations that did not initially have the standard edition installed do not have the problem. This could be totally coincidental, but worth noting.

I can work with it as it is for now and will try re-installing it again when I can apply the service pack and hot fixes.

Thank you.