| Groups | Blog | Home |
sql server replication : Snapshot Creation
Distributor/Publisher and Subscriber:
Windows Server 2003 SP1 SQL Server 2000 SP4 Distributor/Publisher and Subscriber created through SQL Server wizardry. Asked for initial Snapshot to be created immediately. It wasn't. Snapshot Agent shows as "Never started". Right-clicking on the Snapshot Agent and selecting "Start agent" results in nothing--no snapshot, no error message, no Event Log entries. Nothing. I could really use some help here. I found one thread from March 2005 where a guy resorted to scripting what this replication is supposed to do. I'd prefer to set it up to run as it is supposed to run. Is this possible? Thread from 2005: http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 Thanks! Jim P.S. The replication manager is set to refresh every 10 minutes, and each time the below error output appears in the Application Log. Otherwise, I seem to have nothing at all going. SQL Server Scheduled Job 'Replication agents checkup' (0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on: 2006-07-21 16:20:00 - Message: The job failed. Unable to determine if the owner (UAB\Genome-SQLServer) of job Replication agents checkup has server access (reason: Could not obtain information about Windows NT group/user 'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)).
Can you enable logging to see if it reveals anything.
http://support.microsoft.com/kb/312292/en-us -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Jim" <please.reply@group> wrote in message news:OFlSl1QrGHA.5008@TK2MSFTNGP05.phx.gbl... > Distributor/Publisher and Subscriber: > Windows Server 2003 SP1 > SQL Server 2000 SP4 > > Distributor/Publisher and Subscriber created through SQL Server wizardry. > Asked for initial Snapshot to be created immediately. It wasn't. > > Snapshot Agent shows as "Never started". Right-clicking on the Snapshot > Agent and selecting "Start agent" results in nothing--no snapshot, no > error message, no Event Log entries. Nothing. > > I could really use some help here. I found one thread from March 2005 > where a guy resorted to scripting what this replication is supposed to do. > I'd prefer to set it up to run as it is supposed to run. Is this > possible? > > Thread from 2005: > http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 > > Thanks! > > Jim > > P.S. The replication manager is set to refresh every 10 minutes, and > each time the below error output appears in the Application Log. > Otherwise, I seem to have nothing at all going. > SQL Server Scheduled Job 'Replication agents checkup' > (0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on: > 2006-07-21 16:20:00 - Message: The job failed. Unable to determine if the > owner (UAB\Genome-SQLServer) of job Replication agents checkup has server > access (reason: Could not obtain information about Windows NT group/user > 'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)). > > > > > >
Hi again, Hilary! Thanks for the reply!
I have enabled logging, as you suggested at the level of "2". So all activity should go to the log. Then I have again attempted to start the Snapshot agent. No logs are created. The Microsoft AD account under which the Snapshot agent (and other replication-related agents) is (are) running had only "User" status. I noticed in the Security Event log that it was being denied access to directories and files in C:\WINNT\system32. So, I made it a "Power User", and that helped. Then I made it an "Administrator" and that helped more. But still no Snapshot agent log! :-( I have since moved the AD account around some more between User, Power User, and Administrator. Now no entries are appearing in the Security Event log as they were before. I have changed nothing else. This is weird! (and rather frustrating :-) Any more suggestions, anyone? Best regards, Jim [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:%23TNjnJRrGHA.2440@TK2MSFTNGP03.phx.gbl... > Can you enable logging to see if it reveals anything. > > http://support.microsoft.com/kb/312292/en-us > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Jim" <please.reply@group> wrote in message > news:OFlSl1QrGHA.5008@TK2MSFTNGP05.phx.gbl... >> Distributor/Publisher and Subscriber: >> Windows Server 2003 SP1 >> SQL Server 2000 SP4 >> >> Distributor/Publisher and Subscriber created through SQL Server wizardry. >> Asked for initial Snapshot to be created immediately. It wasn't. >> >> Snapshot Agent shows as "Never started". Right-clicking on the Snapshot >> Agent and selecting "Start agent" results in nothing--no snapshot, no >> error message, no Event Log entries. Nothing. >> >> I could really use some help here. I found one thread from March 2005 >> where a guy resorted to scripting what this replication is supposed to >> do. I'd prefer to set it up to run as it is supposed to run. Is this >> possible? >> >> Thread from 2005: >> http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 >> >> Thanks! >> >> Jim >> >> P.S. The replication manager is set to refresh every 10 minutes, and >> each time the below error output appears in the Application Log. >> Otherwise, I seem to have nothing at all going. >> SQL Server Scheduled Job 'Replication agents checkup' >> (0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on: >> 2006-07-21 16:20:00 - Message: The job failed. Unable to determine if the >> owner (UAB\Genome-SQLServer) of job Replication agents checkup has server >> access (reason: Could not obtain information about Windows NT group/user >> 'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)). >> >> >> >> >> >> > >
Make the job owner sa and start it up again.
-- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Jim" <please.reply@group> wrote in message news:uzV0dVzrGHA.3960@TK2MSFTNGP02.phx.gbl... > Hi again, Hilary! Thanks for the reply! > > I have enabled logging, as you suggested at the level of "2". So all > activity should go to the log. Then I have again attempted to start the > Snapshot agent. No logs are created. > > The Microsoft AD account under which the Snapshot agent (and other > replication-related agents) is (are) running had only "User" status. I > noticed in the Security Event log that it was being denied access to > directories and files in C:\WINNT\system32. So, I made it a "Power User", > and that helped. Then I made it an "Administrator" and that helped more. > But still no Snapshot agent log! :-( > > I have since moved the AD account around some more between User, Power > User, and Administrator. Now no entries are appearing in the Security > Event log as they were before. I have changed nothing else. This is > weird! (and rather frustrating :-) > > Any more suggestions, anyone? > > Best regards, > Jim > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:%23TNjnJRrGHA.2440@TK2MSFTNGP03.phx.gbl... >> Can you enable logging to see if it reveals anything. >> >> http://support.microsoft.com/kb/312292/en-us >> >> -- >> Hilary Cotter >> Director of Text Mining and Database Strategy >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >> >> This posting is my own and doesn't necessarily represent RelevantNoise's >> positions, strategies or opinions. >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "Jim" <please.reply@group> wrote in message >> news:OFlSl1QrGHA.5008@TK2MSFTNGP05.phx.gbl... >>> Distributor/Publisher and Subscriber: >>> Windows Server 2003 SP1 >>> SQL Server 2000 SP4 >>> >>> Distributor/Publisher and Subscriber created through SQL Server >>> wizardry. Asked for initial Snapshot to be created immediately. It >>> wasn't. >>> >>> Snapshot Agent shows as "Never started". Right-clicking on the Snapshot >>> Agent and selecting "Start agent" results in nothing--no snapshot, no >>> error message, no Event Log entries. Nothing. >>> >>> I could really use some help here. I found one thread from March 2005 >>> where a guy resorted to scripting what this replication is supposed to >>> do. I'd prefer to set it up to run as it is supposed to run. Is this >>> possible? >>> >>> Thread from 2005: >>> http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 >>> >>> Thanks! >>> >>> Jim >>> >>> P.S. The replication manager is set to refresh every 10 minutes, and >>> each time the below error output appears in the Application Log. >>> Otherwise, I seem to have nothing at all going. >>> SQL Server Scheduled Job 'Replication agents checkup' >>> (0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on: >>> 2006-07-21 16:20:00 - Message: The job failed. Unable to determine if >>> the owner (UAB\Genome-SQLServer) of job Replication agents checkup has >>> server access (reason: Could not obtain information about Windows NT >>> group/user 'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)). >>> >>> >>> >>> >>> >>> >> >> > >
Thank you, Hilary.
I have just tried as you suggested. In the Snapshot agent properties, general tab, set the Owner to "sa". I clicked "Apply" and "OK". Right-clicking on the agent and selecting "Start Agent" resulted in a "Failed" status and "...Check error details for more information..." But "Error Details" is grayed out. There is nothing helpful in the SQL Server log or Event Logs. I do see "Login failed for user 'sa'", but that is extremely common. There are red circles with white Xs in EM on Replication Monitor, Publishers, ...; same on Agents and Snapshot Agents. I'm glad to see some things happening. Don't currently know what to try next, though. :-) Jim [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:%232lBCA0rGHA.2464@TK2MSFTNGP03.phx.gbl... > Make the job owner sa and start it up again. > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Jim" <please.reply@group> wrote in message > news:uzV0dVzrGHA.3960@TK2MSFTNGP02.phx.gbl... >> Hi again, Hilary! Thanks for the reply! >> >> I have enabled logging, as you suggested at the level of "2". So all >> activity should go to the log. Then I have again attempted to start the >> Snapshot agent. No logs are created. >> >> The Microsoft AD account under which the Snapshot agent (and other >> replication-related agents) is (are) running had only "User" status. I >> noticed in the Security Event log that it was being denied access to >> directories and files in C:\WINNT\system32. So, I made it a "Power >> User", and that helped. Then I made it an "Administrator" and that >> helped more. But still no Snapshot agent log! :-( >> >> I have since moved the AD account around some more between User, Power >> User, and Administrator. Now no entries are appearing in the Security >> Event log as they were before. I have changed nothing else. This is >> weird! (and rather frustrating :-) >> >> Any more suggestions, anyone? >> >> Best regards, >> Jim >> >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:%23TNjnJRrGHA.2440@TK2MSFTNGP03.phx.gbl... >>> Can you enable logging to see if it reveals anything. >>> >>> http://support.microsoft.com/kb/312292/en-us >>> >>> -- >>> Hilary Cotter >>> Director of Text Mining and Database Strategy >>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >>> >>> This posting is my own and doesn't necessarily represent RelevantNoise's >>> positions, strategies or opinions. >>> >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> >>> >>> >>> "Jim" <please.reply@group> wrote in message >>> news:OFlSl1QrGHA.5008@TK2MSFTNGP05.phx.gbl... >>>> Distributor/Publisher and Subscriber: >>>> Windows Server 2003 SP1 >>>> SQL Server 2000 SP4 >>>> >>>> Distributor/Publisher and Subscriber created through SQL Server >>>> wizardry. Asked for initial Snapshot to be created immediately. It >>>> wasn't. >>>> >>>> Snapshot Agent shows as "Never started". Right-clicking on the >>>> Snapshot Agent and selecting "Start agent" results in nothing--no >>>> snapshot, no error message, no Event Log entries. Nothing. >>>> >>>> I could really use some help here. I found one thread from March 2005 >>>> where a guy resorted to scripting what this replication is supposed to >>>> do. I'd prefer to set it up to run as it is supposed to run. Is this >>>> possible? >>>> >>>> Thread from 2005: >>>> http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 >>>> >>>> Thanks! >>>> >>>> Jim >>>> >>>> P.S. The replication manager is set to refresh every 10 minutes, and >>>> each time the below error output appears in the Application Log. >>>> Otherwise, I seem to have nothing at all going. >>>> SQL Server Scheduled Job 'Replication agents checkup' >>>> (0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on: >>>> 2006-07-21 16:20:00 - Message: The job failed. Unable to determine if >>>> the owner (UAB\Genome-SQLServer) of job Replication agents checkup has >>>> server access (reason: Could not obtain information about Windows NT >>>> group/user 'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)). >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> >> >> > >
I should also note that no log was created from the addition of
-Output E:\MSSQL_ReplData\snapshot_agent_log.txt -Outputverboselevel 2 to Step 2--"Run Agent" of the Snapshot Agent Steps. So I wonder why the agent isn't being run. [quoted text, click to view] "Jim" <please.reply@group> wrote in message news:ec9w8P1rGHA.4844@TK2MSFTNGP05.phx.gbl... > Thank you, Hilary. > > I have just tried as you suggested. In the Snapshot agent properties, > general tab, set the Owner to "sa". I clicked "Apply" and "OK". > Right-clicking on the agent and selecting "Start Agent" resulted in a > "Failed" status and "...Check error details for more information..." But > "Error Details" is grayed out. There is nothing helpful in the SQL Server > log or Event Logs. I do see "Login failed for user 'sa'", but that is > extremely common. > > There are red circles with white Xs in EM on Replication Monitor, > Publishers, ...; same on Agents and Snapshot Agents. > > I'm glad to see some things happening. Don't currently know what to try > next, though. :-) > > Jim > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:%232lBCA0rGHA.2464@TK2MSFTNGP03.phx.gbl... >> Make the job owner sa and start it up again. >> >> -- >> Hilary Cotter >> Director of Text Mining and Database Strategy >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >> >> This posting is my own and doesn't necessarily represent RelevantNoise's >> positions, strategies or opinions. >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "Jim" <please.reply@group> wrote in message >> news:uzV0dVzrGHA.3960@TK2MSFTNGP02.phx.gbl... >>> Hi again, Hilary! Thanks for the reply! >>> >>> I have enabled logging, as you suggested at the level of "2". So all >>> activity should go to the log. Then I have again attempted to start the >>> Snapshot agent. No logs are created. >>> >>> The Microsoft AD account under which the Snapshot agent (and other >>> replication-related agents) is (are) running had only "User" status. I >>> noticed in the Security Event log that it was being denied access to >>> directories and files in C:\WINNT\system32. So, I made it a "Power >>> User", and that helped. Then I made it an "Administrator" and that >>> helped more. But still no Snapshot agent log! :-( >>> >>> I have since moved the AD account around some more between User, Power >>> User, and Administrator. Now no entries are appearing in the Security >>> Event log as they were before. I have changed nothing else. This is >>> weird! (and rather frustrating :-) >>> >>> Any more suggestions, anyone? >>> >>> Best regards, >>> Jim >>> >>> >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>> news:%23TNjnJRrGHA.2440@TK2MSFTNGP03.phx.gbl... >>>> Can you enable logging to see if it reveals anything. >>>> >>>> http://support.microsoft.com/kb/312292/en-us >>>> >>>> -- >>>> Hilary Cotter >>>> Director of Text Mining and Database Strategy >>>> RelevantNOISE.Com - Dedicated to mining blogs for business >>>> intelligence. >>>> >>>> This posting is my own and doesn't necessarily represent >>>> RelevantNoise's positions, strategies or opinions. >>>> >>>> Looking for a SQL Server replication book? >>>> http://www.nwsu.com/0974973602.html >>>> >>>> Looking for a FAQ on Indexing Services/SQL FTS >>>> http://www.indexserverfaq.com >>>> >>>> >>>> >>>> "Jim" <please.reply@group> wrote in message >>>> news:OFlSl1QrGHA.5008@TK2MSFTNGP05.phx.gbl... >>>>> Distributor/Publisher and Subscriber: >>>>> Windows Server 2003 SP1 >>>>> SQL Server 2000 SP4 >>>>> >>>>> Distributor/Publisher and Subscriber created through SQL Server >>>>> wizardry. Asked for initial Snapshot to be created immediately. It >>>>> wasn't. >>>>> >>>>> Snapshot Agent shows as "Never started". Right-clicking on the >>>>> Snapshot Agent and selecting "Start agent" results in nothing--no >>>>> snapshot, no error message, no Event Log entries. Nothing. >>>>> >>>>> I could really use some help here. I found one thread from March 2005 >>>>> where a guy resorted to scripting what this replication is supposed to >>>>> do. I'd prefer to set it up to run as it is supposed to run. Is this >>>>> possible? >>>>> >>>>> Thread from 2005: >>>>> http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 >>>>> >>>>> Thanks! >>>>> >>>>> Jim >>>>> >>>>> P.S. The replication manager is set to refresh every 10 minutes, and >>>>> each time the below error output appears in the Application Log. >>>>> Otherwise, I seem to have nothing at all going. >>>>> SQL Server Scheduled Job 'Replication agents checkup' >>>>> (0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on: >>>>> 2006-07-21 16:20:00 - Message: The job failed. Unable to determine if >>>>> the owner (UAB\Genome-SQLServer) of job Replication agents checkup has >>>>> server access (reason: Could not obtain information about Windows NT >>>>> group/user 'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)). >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Ok, we are getting somewhere (I think), can you replace the password on the
snapshot agent properties with the password for the publisher? -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Jim" <please.reply@group> wrote in message news:ec9w8P1rGHA.4844@TK2MSFTNGP05.phx.gbl... > Thank you, Hilary. > > I have just tried as you suggested. In the Snapshot agent properties, > general tab, set the Owner to "sa". I clicked "Apply" and "OK". > Right-clicking on the agent and selecting "Start Agent" resulted in a > "Failed" status and "...Check error details for more information..." But > "Error Details" is grayed out. There is nothing helpful in the SQL Server > log or Event Logs. I do see "Login failed for user 'sa'", but that is > extremely common. > > There are red circles with white Xs in EM on Replication Monitor, > Publishers, ...; same on Agents and Snapshot Agents. > > I'm glad to see some things happening. Don't currently know what to try > next, though. :-) > > Jim > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:%232lBCA0rGHA.2464@TK2MSFTNGP03.phx.gbl... >> Make the job owner sa and start it up again. >> >> -- >> Hilary Cotter >> Director of Text Mining and Database Strategy >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >> >> This posting is my own and doesn't necessarily represent RelevantNoise's >> positions, strategies or opinions. >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "Jim" <please.reply@group> wrote in message >> news:uzV0dVzrGHA.3960@TK2MSFTNGP02.phx.gbl... >>> Hi again, Hilary! Thanks for the reply! >>> >>> I have enabled logging, as you suggested at the level of "2". So all >>> activity should go to the log. Then I have again attempted to start the >>> Snapshot agent. No logs are created. >>> >>> The Microsoft AD account under which the Snapshot agent (and other >>> replication-related agents) is (are) running had only "User" status. I >>> noticed in the Security Event log that it was being denied access to >>> directories and files in C:\WINNT\system32. So, I made it a "Power >>> User", and that helped. Then I made it an "Administrator" and that >>> helped more. But still no Snapshot agent log! :-( >>> >>> I have since moved the AD account around some more between User, Power >>> User, and Administrator. Now no entries are appearing in the Security >>> Event log as they were before. I have changed nothing else. This is >>> weird! (and rather frustrating :-) >>> >>> Any more suggestions, anyone? >>> >>> Best regards, >>> Jim >>> >>> >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>> news:%23TNjnJRrGHA.2440@TK2MSFTNGP03.phx.gbl... >>>> Can you enable logging to see if it reveals anything. >>>> >>>> http://support.microsoft.com/kb/312292/en-us >>>> >>>> -- >>>> Hilary Cotter >>>> Director of Text Mining and Database Strategy >>>> RelevantNOISE.Com - Dedicated to mining blogs for business >>>> intelligence. >>>> >>>> This posting is my own and doesn't necessarily represent >>>> RelevantNoise's positions, strategies or opinions. >>>> >>>> Looking for a SQL Server replication book? >>>> http://www.nwsu.com/0974973602.html >>>> >>>> Looking for a FAQ on Indexing Services/SQL FTS >>>> http://www.indexserverfaq.com >>>> >>>> >>>> >>>> "Jim" <please.reply@group> wrote in message >>>> news:OFlSl1QrGHA.5008@TK2MSFTNGP05.phx.gbl... >>>>> Distributor/Publisher and Subscriber: >>>>> Windows Server 2003 SP1 >>>>> SQL Server 2000 SP4 >>>>> >>>>> Distributor/Publisher and Subscriber created through SQL Server >>>>> wizardry. Asked for initial Snapshot to be created immediately. It >>>>> wasn't. >>>>> >>>>> Snapshot Agent shows as "Never started". Right-clicking on the >>>>> Snapshot Agent and selecting "Start agent" results in nothing--no >>>>> snapshot, no error message, no Event Log entries. Nothing. >>>>> >>>>> I could really use some help here. I found one thread from March 2005 >>>>> where a guy resorted to scripting what this replication is supposed to >>>>> do. I'd prefer to set it up to run as it is supposed to run. Is this >>>>> possible? >>>>> >>>>> Thread from 2005: >>>>> http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 >>>>> >>>>> Thanks! >>>>> >>>>> Jim >>>>> >>>>> P.S. The replication manager is set to refresh every 10 minutes, and >>>>> each time the below error output appears in the Application Log. >>>>> Otherwise, I seem to have nothing at all going. >>>>> SQL Server Scheduled Job 'Replication agents checkup' >>>>> (0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on: >>>>> 2006-07-21 16:20:00 - Message: The job failed. Unable to determine if >>>>> the owner (UAB\Genome-SQLServer) of job Replication agents checkup has >>>>> server access (reason: Could not obtain information about Windows NT >>>>> group/user 'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)). >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Hilary,
I may not understand your suggestion. I don't see a password field in the snapshot agent properties. Are you suggesting that I change the owner of the Snapshot agent job from 'sa' to the account under which the distributor SQL Server runs? (I have just tried that and the snapshot agent fails--still with no "Error Details" available. So I've changed it back to 'sa'.) Jim [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:euVPKT5rGHA.4512@TK2MSFTNGP02.phx.gbl... > Ok, we are getting somewhere (I think), can you replace the password on > the snapshot agent properties with the password for the publisher? > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Jim" <please.reply@group> wrote in message > news:ec9w8P1rGHA.4844@TK2MSFTNGP05.phx.gbl... >> Thank you, Hilary. >> >> I have just tried as you suggested. In the Snapshot agent properties, >> general tab, set the Owner to "sa". I clicked "Apply" and "OK". >> Right-clicking on the agent and selecting "Start Agent" resulted in a >> "Failed" status and "...Check error details for more information..." But >> "Error Details" is grayed out. There is nothing helpful in the SQL >> Server log or Event Logs. I do see "Login failed for user 'sa'", but >> that is extremely common. >> >> There are red circles with white Xs in EM on Replication Monitor, >> Publishers, ...; same on Agents and Snapshot Agents. >> >> I'm glad to see some things happening. Don't currently know what to try >> next, though. :-) >> >> Jim >> >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:%232lBCA0rGHA.2464@TK2MSFTNGP03.phx.gbl... >>> Make the job owner sa and start it up again. >>> >>> -- >>> Hilary Cotter >>> Director of Text Mining and Database Strategy >>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >>> >>> This posting is my own and doesn't necessarily represent RelevantNoise's >>> positions, strategies or opinions. >>> >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> >>> >>> >>> "Jim" <please.reply@group> wrote in message >>> news:uzV0dVzrGHA.3960@TK2MSFTNGP02.phx.gbl... >>>> Hi again, Hilary! Thanks for the reply! >>>> >>>> I have enabled logging, as you suggested at the level of "2". So all >>>> activity should go to the log. Then I have again attempted to start >>>> the Snapshot agent. No logs are created. >>>> >>>> The Microsoft AD account under which the Snapshot agent (and other >>>> replication-related agents) is (are) running had only "User" status. >>>> I noticed in the Security Event log that it was being denied access to >>>> directories and files in C:\WINNT\system32. So, I made it a "Power >>>> User", and that helped. Then I made it an "Administrator" and that >>>> helped more. But still no Snapshot agent log! :-( >>>> >>>> I have since moved the AD account around some more between User, Power >>>> User, and Administrator. Now no entries are appearing in the Security >>>> Event log as they were before. I have changed nothing else. This is >>>> weird! (and rather frustrating :-) >>>> >>>> Any more suggestions, anyone? >>>> >>>> Best regards, >>>> Jim >>>> >>>> >>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>> news:%23TNjnJRrGHA.2440@TK2MSFTNGP03.phx.gbl... >>>>> Can you enable logging to see if it reveals anything. >>>>> >>>>> http://support.microsoft.com/kb/312292/en-us >>>>> >>>>> -- >>>>> Hilary Cotter >>>>> Director of Text Mining and Database Strategy >>>>> RelevantNOISE.Com - Dedicated to mining blogs for business >>>>> intelligence. >>>>> >>>>> This posting is my own and doesn't necessarily represent >>>>> RelevantNoise's positions, strategies or opinions. >>>>> >>>>> Looking for a SQL Server replication book? >>>>> http://www.nwsu.com/0974973602.html >>>>> >>>>> Looking for a FAQ on Indexing Services/SQL FTS >>>>> http://www.indexserverfaq.com >>>>> >>>>> >>>>> >>>>> "Jim" <please.reply@group> wrote in message >>>>> news:OFlSl1QrGHA.5008@TK2MSFTNGP05.phx.gbl... >>>>>> Distributor/Publisher and Subscriber: >>>>>> Windows Server 2003 SP1 >>>>>> SQL Server 2000 SP4 >>>>>> >>>>>> Distributor/Publisher and Subscriber created through SQL Server >>>>>> wizardry. Asked for initial Snapshot to be created immediately. It >>>>>> wasn't. >>>>>> >>>>>> Snapshot Agent shows as "Never started". Right-clicking on the >>>>>> Snapshot Agent and selecting "Start agent" results in nothing--no >>>>>> snapshot, no error message, no Event Log entries. Nothing. >>>>>> >>>>>> I could really use some help here. I found one thread from March >>>>>> 2005 where a guy resorted to scripting what this replication is >>>>>> supposed to do. I'd prefer to set it up to run as it is supposed to >>>>>> run. Is this possible? >>>>>> >>>>>> Thread from 2005: >>>>>> http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 >>>>>> >>>>>> Thanks! >>>>>> >>>>>> Jim >>>>>> >>>>>> P.S. The replication manager is set to refresh every 10 minutes, >>>>>> and each time the below error output appears in the Application Log. >>>>>> Otherwise, I seem to have nothing at all going. >>>>>> SQL Server Scheduled Job 'Replication agents checkup' >>>>>> (0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on: >>>>>> 2006-07-21 16:20:00 - Message: The job failed. Unable to determine if >>>>>> the owner (UAB\Genome-SQLServer) of job Replication agents checkup >>>>>> has server access (reason: Could not obtain information about Windows >>>>>> NT group/user 'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)). >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
One interesting note...
This does create a snapshot, when run at the command line, logged onto the Distributor/Publisher with my AD account (Windows administrator and SQL server administrator) : snapshot -Publisher [<publisher_server_name>] -PublisherDB [<publisher_db>] -Distributor [<distributor_server_name>] -Publication [<publication_name>] -DistributorSecurityMode 1 -Output E:\MSSQL_ReplData\snapshot_agent_log.txt -Outputverboselevel 2 The log is created too! But making my AD account the owner of the Snapshot Agent job, results in the previously described *non-running* of the job. Jim [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:euVPKT5rGHA.4512@TK2MSFTNGP02.phx.gbl... > Ok, we are getting somewhere (I think), can you replace the password on > the snapshot agent properties with the password for the publisher? > > -- > Hilary Cotter > Director of Text Mining and Database Strategy > RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. > > This posting is my own and doesn't necessarily represent RelevantNoise's > positions, strategies or opinions. > > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > > > "Jim" <please.reply@group> wrote in message > news:ec9w8P1rGHA.4844@TK2MSFTNGP05.phx.gbl... >> Thank you, Hilary. >> >> I have just tried as you suggested. In the Snapshot agent properties, >> general tab, set the Owner to "sa". I clicked "Apply" and "OK". >> Right-clicking on the agent and selecting "Start Agent" resulted in a >> "Failed" status and "...Check error details for more information..." But >> "Error Details" is grayed out. There is nothing helpful in the SQL >> Server log or Event Logs. I do see "Login failed for user 'sa'", but >> that is extremely common. >> >> There are red circles with white Xs in EM on Replication Monitor, >> Publishers, ...; same on Agents and Snapshot Agents. >> >> I'm glad to see some things happening. Don't currently know what to try >> next, though. :-) >> >> Jim >> >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:%232lBCA0rGHA.2464@TK2MSFTNGP03.phx.gbl... >>> Make the job owner sa and start it up again. >>> >>> -- >>> Hilary Cotter >>> Director of Text Mining and Database Strategy >>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >>> >>> This posting is my own and doesn't necessarily represent RelevantNoise's >>> positions, strategies or opinions. >>> >>> Looking for a SQL Server replication book? >>> http://www.nwsu.com/0974973602.html >>> >>> Looking for a FAQ on Indexing Services/SQL FTS >>> http://www.indexserverfaq.com >>> >>> >>> >>> "Jim" <please.reply@group> wrote in message >>> news:uzV0dVzrGHA.3960@TK2MSFTNGP02.phx.gbl... >>>> Hi again, Hilary! Thanks for the reply! >>>> >>>> I have enabled logging, as you suggested at the level of "2". So all >>>> activity should go to the log. Then I have again attempted to start >>>> the Snapshot agent. No logs are created. >>>> >>>> The Microsoft AD account under which the Snapshot agent (and other >>>> replication-related agents) is (are) running had only "User" status. >>>> I noticed in the Security Event log that it was being denied access to >>>> directories and files in C:\WINNT\system32. So, I made it a "Power >>>> User", and that helped. Then I made it an "Administrator" and that >>>> helped more. But still no Snapshot agent log! :-( >>>> >>>> I have since moved the AD account around some more between User, Power >>>> User, and Administrator. Now no entries are appearing in the Security >>>> Event log as they were before. I have changed nothing else. This is >>>> weird! (and rather frustrating :-) >>>> >>>> Any more suggestions, anyone? >>>> >>>> Best regards, >>>> Jim >>>> >>>> >>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>> news:%23TNjnJRrGHA.2440@TK2MSFTNGP03.phx.gbl... >>>>> Can you enable logging to see if it reveals anything. >>>>> >>>>> http://support.microsoft.com/kb/312292/en-us >>>>> >>>>> -- >>>>> Hilary Cotter >>>>> Director of Text Mining and Database Strategy >>>>> RelevantNOISE.Com - Dedicated to mining blogs for business >>>>> intelligence. >>>>> >>>>> This posting is my own and doesn't necessarily represent >>>>> RelevantNoise's positions, strategies or opinions. >>>>> >>>>> Looking for a SQL Server replication book? >>>>> http://www.nwsu.com/0974973602.html >>>>> >>>>> Looking for a FAQ on Indexing Services/SQL FTS >>>>> http://www.indexserverfaq.com >>>>> >>>>> >>>>> >>>>> "Jim" <please.reply@group> wrote in message >>>>> news:OFlSl1QrGHA.5008@TK2MSFTNGP05.phx.gbl... >>>>>> Distributor/Publisher and Subscriber: >>>>>> Windows Server 2003 SP1 >>>>>> SQL Server 2000 SP4 >>>>>> >>>>>> Distributor/Publisher and Subscriber created through SQL Server >>>>>> wizardry. Asked for initial Snapshot to be created immediately. It >>>>>> wasn't. >>>>>> >>>>>> Snapshot Agent shows as "Never started". Right-clicking on the >>>>>> Snapshot Agent and selecting "Start agent" results in nothing--no >>>>>> snapshot, no error message, no Event Log entries. Nothing. >>>>>> >>>>>> I could really use some help here. I found one thread from March >>>>>> 2005 where a guy resorted to scripting what this replication is >>>>>> supposed to do. I'd prefer to set it up to run as it is supposed to >>>>>> run. Is this possible? >>>>>> >>>>>> Thread from 2005: >>>>>> http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 >>>>>> >>>>>> Thanks! >>>>>> >>>>>> Jim >>>>>> >>>>>> P.S. The replication manager is set to refresh every 10 minutes, >>>>>> and each time the below error output appears in the Application Log. >>>>>> Otherwise, I seem to have nothing at all going. >>>>>> SQL Server Scheduled Job 'Replication agents checkup' >>>>>> (0x44AB1206E3D37C428BD85CE9BBF50E59) - Status: Failed - Invoked on: >>>>>> 2006-07-21 16:20:00 - Message: The job failed. Unable to determine if >>>>>> the owner (UAB\Genome-SQLServer) of job Replication agents checkup >>>>>> has server access (reason: Could not obtain information about Windows >>>>>> NT group/user 'UAB\Genome-SQLServer'. [SQLSTATE 42000] (Error 8198)). >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Jim, I've run into this problem many times. My way of fixing it is having
the job owner being sa and then right clicking on it and starting it. BTW - ignore my suggestion about the password - that is incorrect. -- Hilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Jim" <please.reply@group> wrote in message
news:%23bYx88$rGHA.2052@TK2MSFTNGP05.phx.gbl... > One interesting note... > > This does create a snapshot, when run at the command line, logged onto the > Distributor/Publisher with my AD account (Windows administrator and SQL > server administrator) : > > snapshot -Publisher [<publisher_server_name>] -PublisherDB > [<publisher_db>] -Distributor [<distributor_server_name>] -Publication > [<publication_name>] -DistributorSecurityMode 1 -Output > E:\MSSQL_ReplData\snapshot_agent_log.txt -Outputverboselevel 2 > > The log is created too! > > But making my AD account the owner of the Snapshot Agent job, results in > the previously described *non-running* of the job. > > Jim > > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:euVPKT5rGHA.4512@TK2MSFTNGP02.phx.gbl... >> Ok, we are getting somewhere (I think), can you replace the password on >> the snapshot agent properties with the password for the publisher? >> >> -- >> Hilary Cotter >> Director of Text Mining and Database Strategy >> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. >> >> This posting is my own and doesn't necessarily represent RelevantNoise's >> positions, strategies or opinions. >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> >> >> "Jim" <please.reply@group> wrote in message >> news:ec9w8P1rGHA.4844@TK2MSFTNGP05.phx.gbl... >>> Thank you, Hilary. >>> >>> I have just tried as you suggested. In the Snapshot agent properties, >>> general tab, set the Owner to "sa". I clicked "Apply" and "OK". >>> Right-clicking on the agent and selecting "Start Agent" resulted in a >>> "Failed" status and "...Check error details for more information..." >>> But "Error Details" is grayed out. There is nothing helpful in the SQL >>> Server log or Event Logs. I do see "Login failed for user 'sa'", but >>> that is extremely common. >>> >>> There are red circles with white Xs in EM on Replication Monitor, >>> Publishers, ...; same on Agents and Snapshot Agents. >>> >>> I'm glad to see some things happening. Don't currently know what to try >>> next, though. :-) >>> >>> Jim >>> >>> >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>> news:%232lBCA0rGHA.2464@TK2MSFTNGP03.phx.gbl... >>>> Make the job owner sa and start it up again. >>>> >>>> -- >>>> Hilary Cotter >>>> Director of Text Mining and Database Strategy >>>> RelevantNOISE.Com - Dedicated to mining blogs for business >>>> intelligence. >>>> >>>> This posting is my own and doesn't necessarily represent >>>> RelevantNoise's positions, strategies or opinions. >>>> >>>> Looking for a SQL Server replication book? >>>> http://www.nwsu.com/0974973602.html >>>> >>>> Looking for a FAQ on Indexing Services/SQL FTS >>>> http://www.indexserverfaq.com >>>> >>>> >>>> >>>> "Jim" <please.reply@group> wrote in message >>>> news:uzV0dVzrGHA.3960@TK2MSFTNGP02.phx.gbl... >>>>> Hi again, Hilary! Thanks for the reply! >>>>> >>>>> I have enabled logging, as you suggested at the level of "2". So all >>>>> activity should go to the log. Then I have again attempted to start >>>>> the Snapshot agent. No logs are created. >>>>> >>>>> The Microsoft AD account under which the Snapshot agent (and other >>>>> replication-related agents) is (are) running had only "User" status. >>>>> I noticed in the Security Event log that it was being denied access to >>>>> directories and files in C:\WINNT\system32. So, I made it a "Power >>>>> User", and that helped. Then I made it an "Administrator" and that >>>>> helped more. But still no Snapshot agent log! :-( >>>>> >>>>> I have since moved the AD account around some more between User, Power >>>>> User, and Administrator. Now no entries are appearing in the Security >>>>> Event log as they were before. I have changed nothing else. This is >>>>> weird! (and rather frustrating :-) >>>>> >>>>> Any more suggestions, anyone? >>>>> >>>>> Best regards, >>>>> Jim >>>>> >>>>> >>>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>>> news:%23TNjnJRrGHA.2440@TK2MSFTNGP03.phx.gbl... >>>>>> Can you enable logging to see if it reveals anything. >>>>>> >>>>>> http://support.microsoft.com/kb/312292/en-us >>>>>> >>>>>> -- >>>>>> Hilary Cotter >>>>>> Director of Text Mining and Database Strategy >>>>>> RelevantNOISE.Com - Dedicated to mining blogs for business >>>>>> intelligence. >>>>>> >>>>>> This posting is my own and doesn't necessarily represent >>>>>> RelevantNoise's positions, strategies or opinions. >>>>>> >>>>>> Looking for a SQL Server replication book? >>>>>> http://www.nwsu.com/0974973602.html >>>>>> >>>>>> Looking for a FAQ on Indexing Services/SQL FTS >>>>>> http://www.indexserverfaq.com >>>>>> >>>>>> >>>>>> >>>>>> "Jim" <please.reply@group> wrote in message >>>>>> news:OFlSl1QrGHA.5008@TK2MSFTNGP05.phx.gbl... >>>>>>> Distributor/Publisher and Subscriber: >>>>>>> Windows Server 2003 SP1 >>>>>>> SQL Server 2000 SP4 >>>>>>> >>>>>>> Distributor/Publisher and Subscriber created through SQL Server >>>>>>> wizardry. Asked for initial Snapshot to be created immediately. It >>>>>>> wasn't. >>>>>>> >>>>>>> Snapshot Agent shows as "Never started". Right-clicking on the >>>>>>> Snapshot Agent and selecting "Start agent" results in nothing--no >>>>>>> snapshot, no error message, no Event Log entries. Nothing. >>>>>>> >>>>>>> I could really use some help here. I found one thread from March >>>>>>> 2005 where a guy resorted to scripting what this replication is >>>>>>> supposed to do. I'd prefer to set it up to run as it is supposed to >>>>>>> run. Is this possible? >>>>>>> >>>>>>> Thread from 2005: >>>>>>> http://groups.google.com/group/microsoft.public.sqlserver.replication/browse_thread/thread/553cb851010ce48/b0e47aceeea46ee4?lnk=st&q=&rnum=2#b0e47aceeea46ee4 >>>>>>> >>>>>>> Thanks! >>>>>>> >>>>>>> Jim >>>>>>> >>>>>>> P.S. The replication manager is set to refresh every 10 minutes, >>>>>>> and each time the below error output appears in the Application Log.
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |