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.

Nightly Maintenance Backup Plan fails -- no trace of why

We have been running a backup plan (created using the sql 2005 Maintenance wizard) for some time. It failed last night but all databases seemed to be backed up.

I looked at the ERRORLOG in <mssql2005>\mssql.1\log as well as

"Servname DB Backup Plan_20070118184358.txt"

but found no errors. Where else can I look to see what went wrong?

TIA,

barkingdog

You can also check the logs of the Sql Server Agent job corresponding to the maintenance plan.

Thanks,

Kuntal

|||

>>> check the logs of the Sql Server Agent job

Where are these located? (Are you referring to SQLAgent.OUT? It had nothing of interest.)

Barkingdog

|||

In Sql 2005, for every maintenance plan an Sql Agent job is created by the same name. You can view its logs as Sql Server Agent -> Jobs -> select the job & right click to View History.

Hope that helps

Kuntal

|||

What was the error under the scheduled job for this maintenance plan?

Also try to run thsi manually from SSMS to see the execution, also ensure the SQLAgent account has required privileges to run this job. ALso check what changes have been since last time when this job was running succesfsully.

Newbie: Index Tuning Wizard

Hi,
I am set (by the sa) as a dbo, "full everything" for my Database.
However when I start the Index Tuning Wizard it complains that I need to be
in the sysadmin group
Also, what is the difference between all these Indexing Wizards? I want for
the server to suggest to me the indexes , for better performance. (Profiler,
etc.- which the other wizards seem not to have. They operate on a table
level.)
TIA
-steve
steve
To run Profiler you have to be a member of sysadmin server role
Usually , we run Profiler , save the data to the file and then examine the
file on Index Tuning Wizard
But there are many options
"steve" <steve@.here.com> wrote in message
news:Idrie.96895$th3.1203245@.wagner.videotron.net. ..
> Hi,
> I am set (by the sa) as a dbo, "full everything" for my Database.
> However when I start the Index Tuning Wizard it complains that I need to
be
> in the sysadmin group
> Also, what is the difference between all these Indexing Wizards? I want
for
> the server to suggest to me the indexes , for better performance.
(Profiler,
> etc.- which the other wizards seem not to have. They operate on a table
> level.)
> TIA
> -steve
>
|||Ok, but this doesn't make much sense!
Does it mean I have to be a sysadmin to use a Wizard to Index my *own* DB
?.
As i said i am a newbie, Is there a way for the administrator to give me the
required permissions, and what are they, without him feeling threatened that
i have acess to other DB's in the server?
I am very perplexed, it doesnt make sense for Microsoft not to allow a dbo
to run a Profiler,Wizard in his own database.
I also think i read somewhere that dbo is enough, but obviously doesn't
apply in my case.
Thanx again!
"Uri Dimant" <urid@.iscar.co.il> a crit dans le message de news:
ec$Ho22WFHA.3864@.TK2MSFTNGP10.phx.gbl...
> steve
> To run Profiler you have to be a member of sysadmin server role
> Usually , we run Profiler , save the data to the file and then examine the
> file on Index Tuning Wizard
> But there are many options
>
>
> "steve" <steve@.here.com> wrote in message
> news:Idrie.96895$th3.1203245@.wagner.videotron.net. ..
> be
> for
> (Profiler,
>

Newbie: Index Tuning Wizard

Hi,
I am set (by the sa) as a dbo, "full everything" for my Database.
However when I start the Index Tuning Wizard it complains that I need to be
in the sysadmin group
Also, what is the difference between all these Indexing Wizards? I want for
the server to suggest to me the indexes , for better performance. (Profiler,
etc.- which the other wizards seem not to have. They operate on a table
level.)
TIA
-stevesteve
To run Profiler you have to be a member of sysadmin server role
Usually , we run Profiler , save the data to the file and then examine the
file on Index Tuning Wizard
But there are many options
"steve" <steve@.here.com> wrote in message
news:Idrie.96895$th3.1203245@.wagner.videotron.net...
> Hi,
> I am set (by the sa) as a dbo, "full everything" for my Database.
> However when I start the Index Tuning Wizard it complains that I need to
be
> in the sysadmin group
> Also, what is the difference between all these Indexing Wizards? I want
for
> the server to suggest to me the indexes , for better performance.
(Profiler,
> etc.- which the other wizards seem not to have. They operate on a table
> level.)
> TIA
> -steve
>|||Ok, but this doesn't make much sense!
Does it mean I have to be a sysadmin to use a Wizard to Index my *own* DB
'.
As i said i am a newbie, Is there a way for the administrator to give me the
required permissions, and what are they, without him feeling threatened that
i have acess to other DB's in the server?
I am very perplexed, it doesnt make sense for Microsoft not to allow a dbo
to run a Profiler,Wizard in his own database.
I also think i read somewhere that dbo is enough, but obviously doesn't
apply in my case.
Thanx again!
"Uri Dimant" <urid@.iscar.co.il> a crit dans le message de news:
ec$Ho22WFHA.3864@.TK2MSFTNGP10.phx.gbl...
> steve
> To run Profiler you have to be a member of sysadmin server role
> Usually , we run Profiler , save the data to the file and then examine the
> file on Index Tuning Wizard
> But there are many options
>
>
> "steve" <steve@.here.com> wrote in message
> news:Idrie.96895$th3.1203245@.wagner.videotron.net...
> be
> for
> (Profiler,
>

Newbie: Index Tuning Wizard

Hi,
I am set (by the sa) as a dbo, "full everything" for my Database.
However when I start the Index Tuning Wizard it complains that I need to be
in the sysadmin group
Also, what is the difference between all these Indexing Wizards? I want for
the server to suggest to me the indexes , for better performance. (Profiler,
etc.- which the other wizards seem not to have. They operate on a table
level.)
TIA
-stevesteve
To run Profiler you have to be a member of sysadmin server role
Usually , we run Profiler , save the data to the file and then examine the
file on Index Tuning Wizard
But there are many options
"steve" <steve@.here.com> wrote in message
news:Idrie.96895$th3.1203245@.wagner.videotron.net...
> Hi,
> I am set (by the sa) as a dbo, "full everything" for my Database.
> However when I start the Index Tuning Wizard it complains that I need to
be
> in the sysadmin group
> Also, what is the difference between all these Indexing Wizards? I want
for
> the server to suggest to me the indexes , for better performance.
(Profiler,
> etc.- which the other wizards seem not to have. They operate on a table
> level.)
> TIA
> -steve
>|||Ok, but this doesn't make much sense!
Does it mean I have to be a sysadmin to use a Wizard to Index my *own* DB
'.
As i said i am a newbie, Is there a way for the administrator to give me the
required permissions, and what are they, without him feeling threatened that
i have acess to other DB's in the server?
I am very perplexed, it doesnt make sense for Microsoft not to allow a dbo
to run a Profiler,Wizard in his own database.
I also think i read somewhere that dbo is enough, but obviously doesn't
apply in my case.
Thanx again!
"Uri Dimant" <urid@.iscar.co.il> a écrit dans le message de news:
ec$Ho22WFHA.3864@.TK2MSFTNGP10.phx.gbl...
> steve
> To run Profiler you have to be a member of sysadmin server role
> Usually , we run Profiler , save the data to the file and then examine the
> file on Index Tuning Wizard
> But there are many options
>
>
> "steve" <steve@.here.com> wrote in message
> news:Idrie.96895$th3.1203245@.wagner.videotron.net...
>> Hi,
>> I am set (by the sa) as a dbo, "full everything" for my Database.
>> However when I start the Index Tuning Wizard it complains that I need to
> be
>> in the sysadmin group
>> Also, what is the difference between all these Indexing Wizards? I want
> for
>> the server to suggest to me the indexes , for better performance.
> (Profiler,
>> etc.- which the other wizards seem not to have. They operate on a table
>> level.)
>> TIA
>> -steve
>>
>