July 24, 2011 at 8:59 am
I get the following error:
Executed as user: [DOMAIN]\Administrator. (unknown security error). The step failed.
When running any of the repl jobs (SQL 2008 STD).
So far i have tried:
1. Switched the SQL agent to local system account then back to my domain account.
2. Added my domain account to the local account policy groups recommended my MS.
3. Added my domain account to the local administrator group
4. Tried running the step as sql agent.
I did have a problem with the agent the first time i set it to my domain account. I could not do it form the SQL config console (got some WMI errors). I had to do it for Windows services console.
I also have 2005 installed on the same server.
I reinstalled SQL 2 weeks ago bec I had R2 installed as well. and my SSIS was not working as it should. So the next step would be to reinstall windows and SQL which i don't really want do as this is my main production server. Any help please.
July 24, 2011 at 11:14 am
I take it your DOMAIN\Administrator account has permissions to both SQL Server and the file system where the replication snapshot files are kept?
Just asking because some places block network and windows admins from their SQL Server instances.
I got caught withe security errors while I was trying to implement least privileged permissions for replication and it was to do with the permissions on certain folders used by SQL Server.
July 24, 2011 at 11:50 pm
Checked all the file sec on all the SQL files i could think of and still get the same error..
here is log from running the logreader for CMD.
--
C:\Users\Administrator.MYDOMAIN>"C:\Program Files\Microsoft SQL Server\1000\COM\lo
gread.exe" -Publisher [SERVER1] -PublisherDB [test1] -Distributor [SERVER1] -Distrib
utorSecurityMode 1 -Continuous -OutputVerboseLevel [2]
2011-07-25 05:47:07.693 Microsoft SQL Server Log Reader Agent 10.50.1600.1
2011-07-25 05:47:07.693 Copyright (c) 2008 Microsoft Corporation
2011-07-25 05:47:07.694
2011-07-25 05:47:07.694 The timestamps prepended to the output lines are express
ed in terms of UTC time.
2011-07-25 05:47:07.694 User-specified agent parameter values:
-Publisher SERVER1
-PublisherDB test1
-Distributor SERVER1
-DistributorSecurityMode 1
-Continuous
-OutputVerboseLevel 2
2011-07-25 05:47:07.731 Status: 0, code: 22014, text: 'OLE error. Function 'CoC
reateInstance()' failed with return code 2147942526.'.
2011-07-25 05:47:07.732 OLE error. Function 'CoCreateInstance()' failed with re
turn code 2147942526.
2011-07-25 05:47:07.732 Status: 0, code: 22007, text: 'The process could not cre
ate 'IReplDist Interface'.'.
2011-07-25 05:47:07.732 Disconnecting from OLE DB Publisher 'SERVER1'
C:\Users\Administrator.MYDOMAIN>
--
Hmmm i'm worried about the version of the log reader.. i did have 2008 and 2008 R2 running side by side... but have since uninstalled R2 could this cause this kind of problem. because i can't create main. plans either. after googling that i found it due to running diff ver of SQL..
July 25, 2011 at 12:32 am
:w00t: OMG I was right!! i copied over missing files from the COM folder from my other 2008 server and placed it into the 100 folder on my server (which was almost empty) thanks to my prevouis install of R2 (only my 1000 folder had the exe files in that is R2 right?) . I got a dll error on the first run then copied again replacing all the files. And BAM agents all start.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply