OLAP Administrators issue

Hi,

I moved my AS 2000 olap database to new hardware also new OS WS 2003 32 bit to 64 bit.

I added domain/loging ID of sql server/job server to "OLAP Administrators" user group

which runs the DTS package to process cubes. This was fine in my old server OS WS 2003 32 bit.

But in new server WS 2003 64 bit cube process failed because job server was not able to connect to AS server.

I had to add job server's domain\login ID to "Administrators" user group in new server and then I was able to process the cube.

I don't want to give administrator access to job server to my olap server is this some thing I can do or missing?

Thank you - Ashok

Here is some information for you from http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Take a look at the Administrator Security section there.

In general, DSO that client application like Analysis Manager, or DTS task based upon tries couple of things.

One, it remotely accesses registry on server machine and reads RemoteRepositoryConnectionString http://support.microsoft.com/kb/330244

Then it uses it to open AS2000 repository.

Try and see at what point DSO running under user account with fewer privileges fails to acces information it needs.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Off Thread: SQL Server Users Groups

Hope I'm not going to annoy anyone here too much but I'm looking for a place to post a job opening and was hoping that someone out there might know of a good site or two.

The job will be in the north Denver area.

Thanks! (And apologies if this is completely inappropriate behavior.)The job will be for a SQL Server programmer w/ some DBA skills.|||did you try monsters, hot jobs, dice?

I don't..

Mr. Moderator: You JonathanB, wake up.

Can she post it here?

I guess you can go here and post:

http://www.sswug.com/forum/ShowForum.aspx?ForumID=21|||Originally posted by Fly Girl
The job will be for a SQL Server programmer w/ some DBA skills.

One would hope so...|||Post it in the Chit Chat or Marketplace forums.

Odd scheduled job behavior

I've scheduled a job to run on a certain schedule, but the Last Run Status date comes back very oddly, a couple years out of synch, the other jobs scheduled report back just fine.
Anyone seen this behavior?
Edward R Hunter, Data Application Designer
comScore Networks, Inc....haven't seen that one, but you could always check the sysjobhistory table in msdb (if you have the rights) to see what the rundate column has stored.

What version of SQL Server are you on?