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.

NextDay

Hello everybody?

Another issue has cropped up in my Oracle to SQL Svr migration. Can anybody suggest the equivalent code for the Oracle NEXT_DAY function?

Here is a sample of how Oracle NEXT_DAY function works...

SELECT NEXT_DAY(sysdate, 'Sunday') from dual ;

Result:

NEXT_DAY
---
12-DEC-04

where sysdate is Oracle for GetDate() of SQL Svr. Forget about "from dual". So, what NEXT_DAY is doing is that it is returning the next coming date on which a Sunday will fall, if sysdate = 07 Dec 2004.

Any help will be highly appreciated. ThxYou'll have to write this youself, as there is no immediate equivalent.
You can pretty easily create a user-defined function that exactly mimics oracle NEXT_DAY()

You would have to use the SQL function datename(weekday, date)
and the SQL function dateadd(day, 1, date).
Loop round a max of seven (six?) times using dateadd to add a day to your date, and then using datename to get the day description which you could then compare with your input parameter. return the appropraite date when a match is found.

HTH, but I ain't coding it for you :-)

Bill|||Here is a non-looping algorithm:

declare @.TargetDay int
set @.TargetDay = 1 --Sunday
select dateadd(d, (@.TargetDay + 7-datepart(dw, getdate())) % 7, getdate())

TargetDay must be supplied as an integer, according to the settings of your @.@.DATEFIRST property. Normally, Sunday = 1, Monday = 2, etc.

Also, this returns 0 if the today is the TargetDay. Not sure exactly what you wanted in that case...|||Thx a lot lindman and bill..