August 6, 2007 at 1:22 pm
Recently I have been tasked with building a new development server so we could retire one of our old boxes.
I had to move some of the SQLServer databases from the old server to the new one. I also had to move some dts packages as well.
I managed to get the databases restored, used the transfer logins dts package to get the logins, and ran the sp_change_users_login procedure to supposedly synch up the users with the logins...
Anyway, we can run the dts packages but when we schedule them as a job we get errors.
The errors we are getting seem to be pertaining to the domain and logins. They vary depending on who owns the job when it is ran and whether it is ran as a scheduled job or invoked by a particular user.
Here is one example:
The job failed. Unable to determine if the owner (AD\asrodrig) of job Provider Directory - CT CMD- Medicaid - Production2 has server access (reason: Could not obtain information about Windows NT group/user 'AD\asrodrig'. [SQLSTATE 42000] (Error 8198)).
Im thinking I missed a step somewhere as far as transferring the logins and users from old server to the new one.
August 6, 2007 at 2:30 pm
Maybe this will help.
August 6, 2007 at 2:37 pm
Nope that didnt help.
August 6, 2007 at 3:05 pm
Maybe this wil be more helpful or at least get you pointed in the right direction.
August 7, 2007 at 1:53 pm
Nope that didnt help either.
August 7, 2007 at 3:06 pm
Is your new server in the same domain as the older server? Have you tried droppind and recreating the user: AD\asrodrig? Try running EXEC xp_Logininfo 'AD\asrodrig' and see what you get.
August 7, 2007 at 5:55 pm
Well, I got the job to run.
I set the sqlserver service as local system and the sqlserver agent as an AD user and the job ran.
Still dont know why but its working... thanks for your replies.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply