|
|
You're in the
sql server replication
group:Merge Replication - sp_addscriptexec
sql server replication:
The error occurs when trying to apply a script to the subscriber. The script was posted using sp_addscriptexec. The schema script '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' could not be propagated to the subscriber. (Source: Merge Replication Provider (Agent); Error number: -2147201001) --------------------------------------------------------------------------------------------------------------- Failed to launch 'osql' (Source: SubscriberName\InstanceName (Agent); Error number: 20130) --------------------------------------------------------------------------------------------------------------- The system cannot find the path specified. (Source: (OS); Error number: 3) --------------------------------------------------------------------------------------------------------------- The following have been done to troubleshoot 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has no problem seeing the sql file 2) Made sure the SQLAgent was running under the correct user account. I'm running MSDE 2000 SP3. Any help would be appreciated. Thanks
sounds like osql is not present on these subscribers. What version of SQL
Server is running there? Can you run osql from the command prompt on these subscribers? -- RelevantNoise.com - dedicated to mining blogs for business intelligence. 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] "Softworks" <subscriber@soft-works.com> wrote in message news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >I have (3) subscribers out of a total of 185 that are failing on syncing. > > The error occurs when trying to apply a script to the subscriber. The > script was posted using sp_addscriptexec. > > > The schema script > '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' could not > be propagated to the subscriber. > (Source: Merge Replication Provider (Agent); Error number: -2147201001) > --------------------------------------------------------------------------------------------------------------- > Failed to launch 'osql' > (Source: SubscriberName\InstanceName (Agent); Error number: 20130) > --------------------------------------------------------------------------------------------------------------- > The system cannot find the path specified. > (Source: (OS); Error number: 3) > --------------------------------------------------------------------------------------------------------------- > > > The following have been done to troubleshoot > 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has no > problem seeing the sql file > 2) Made sure the SQLAgent was running under the correct user account. > > I'm running MSDE 2000 SP3. > > Any help would be appreciated. > Thanks > > >
MSDE 2000 SP3 is running on the subscribers. I'm able to run osql from the
command prompt with no problem. [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:Og5n$j3AIHA.4732@TK2MSFTNGP04.phx.gbl... > sounds like osql is not present on these subscribers. What version of SQL > Server is running there? > > Can you run osql from the command prompt on these subscribers? > > -- > RelevantNoise.com - dedicated to mining blogs for business intelligence. > > 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 > "Softworks" <subscriber@soft-works.com> wrote in message > news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >>I have (3) subscribers out of a total of 185 that are failing on syncing. >> >> The error occurs when trying to apply a script to the subscriber. The >> script was posted using sp_addscriptexec. >> >> >> The schema script >> '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' could >> not be propagated to the subscriber. >> (Source: Merge Replication Provider (Agent); Error number: -2147201001) >> --------------------------------------------------------------------------------------------------------------- >> Failed to launch 'osql' >> (Source: SubscriberName\InstanceName (Agent); Error number: 20130) >> --------------------------------------------------------------------------------------------------------------- >> The system cannot find the path specified. >> (Source: (OS); Error number: 3) >> --------------------------------------------------------------------------------------------------------------- >> >> >> The following have been done to troubleshoot >> 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has no >> problem seeing the sql file >> 2) Made sure the SQLAgent was running under the correct user account. >> >> I'm running MSDE 2000 SP3. >> >> Any help would be appreciated. >> Thanks >> >> >> > >
are these pull subscribers using ftp?
-- RelevantNoise.com - dedicated to mining blogs for business intelligence. 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] "Softworks" <subscriber@soft-works.com> wrote in message news:%237V1lC5AIHA.4612@TK2MSFTNGP03.phx.gbl... > MSDE 2000 SP3 is running on the subscribers. I'm able to run osql from > the command prompt with no problem. > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:Og5n$j3AIHA.4732@TK2MSFTNGP04.phx.gbl... >> sounds like osql is not present on these subscribers. What version of SQL >> Server is running there? >> >> Can you run osql from the command prompt on these subscribers? >> >> -- >> RelevantNoise.com - dedicated to mining blogs for business intelligence. >> >> 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 >> "Softworks" <subscriber@soft-works.com> wrote in message >> news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >>>I have (3) subscribers out of a total of 185 that are failing on syncing. >>> >>> The error occurs when trying to apply a script to the subscriber. The >>> script was posted using sp_addscriptexec. >>> >>> >>> The schema script >>> '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' could >>> not be propagated to the subscriber. >>> (Source: Merge Replication Provider (Agent); Error number: -2147201001) >>> --------------------------------------------------------------------------------------------------------------- >>> Failed to launch 'osql' >>> (Source: SubscriberName\InstanceName (Agent); Error number: 20130) >>> --------------------------------------------------------------------------------------------------------------- >>> The system cannot find the path specified. >>> (Source: (OS); Error number: 3) >>> --------------------------------------------------------------------------------------------------------------- >>> >>> >>> The following have been done to troubleshoot >>> 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has no >>> problem seeing the sql file >>> 2) Made sure the SQLAgent was running under the correct user account. >>> >>> I'm running MSDE 2000 SP3. >>> >>> Any help would be appreciated. >>> Thanks >>> >>> >>> >> >> > >
These are pulls over VPN using UNCs.
[quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:erk2nU8AIHA.5160@TK2MSFTNGP05.phx.gbl... > are these pull subscribers using ftp? > > -- > RelevantNoise.com - dedicated to mining blogs for business intelligence. > > 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 > "Softworks" <subscriber@soft-works.com> wrote in message > news:%237V1lC5AIHA.4612@TK2MSFTNGP03.phx.gbl... >> MSDE 2000 SP3 is running on the subscribers. I'm able to run osql from >> the command prompt with no problem. >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:Og5n$j3AIHA.4732@TK2MSFTNGP04.phx.gbl... >>> sounds like osql is not present on these subscribers. What version of >>> SQL Server is running there? >>> >>> Can you run osql from the command prompt on these subscribers? >>> >>> -- >>> RelevantNoise.com - dedicated to mining blogs for business intelligence. >>> >>> 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 >>> "Softworks" <subscriber@soft-works.com> wrote in message >>> news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >>>>I have (3) subscribers out of a total of 185 that are failing on >>>>syncing. >>>> >>>> The error occurs when trying to apply a script to the subscriber. The >>>> script was posted using sp_addscriptexec. >>>> >>>> >>>> The schema script >>>> '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' could >>>> not be propagated to the subscriber. >>>> (Source: Merge Replication Provider (Agent); Error number: -2147201001) >>>> --------------------------------------------------------------------------------------------------------------- >>>> Failed to launch 'osql' >>>> (Source: SubscriberName\InstanceName (Agent); Error number: 20130) >>>> --------------------------------------------------------------------------------------------------------------- >>>> The system cannot find the path specified. >>>> (Source: (OS); Error number: 3) >>>> --------------------------------------------------------------------------------------------------------------- >>>> >>>> >>>> The following have been done to troubleshoot >>>> 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has no >>>> problem seeing the sql file >>>> 2) Made sure the SQLAgent was running under the correct user account. >>>> >>>> I'm running MSDE 2000 SP3. >>>> >>>> Any help would be appreciated. >>>> Thanks >>>> >>>> >>>> >>> >>> >> >> > >
Can you try this on the problem subscriber(s)
master.dbo.xp_cmdshell 'dir \\myserver\sharename\20070927191933967\customer_firstlast.sql' The cmd shell should run under the SQL Server agent account on the subscriber(s). I want to verify it can read this file. -- RelevantNoise.com - dedicated to mining blogs for business intelligence. 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] "Softworks" <subscriber@soft-works.com> wrote in message news:OPeosL9AIHA.4656@TK2MSFTNGP04.phx.gbl... > These are pulls over VPN using UNCs. > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:erk2nU8AIHA.5160@TK2MSFTNGP05.phx.gbl... >> are these pull subscribers using ftp? >> >> -- >> RelevantNoise.com - dedicated to mining blogs for business intelligence. >> >> 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 >> "Softworks" <subscriber@soft-works.com> wrote in message >> news:%237V1lC5AIHA.4612@TK2MSFTNGP03.phx.gbl... >>> MSDE 2000 SP3 is running on the subscribers. I'm able to run osql from >>> the command prompt with no problem. >>> >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>> news:Og5n$j3AIHA.4732@TK2MSFTNGP04.phx.gbl... >>>> sounds like osql is not present on these subscribers. What version of >>>> SQL Server is running there? >>>> >>>> Can you run osql from the command prompt on these subscribers? >>>> >>>> -- >>>> RelevantNoise.com - dedicated to mining blogs for business >>>> intelligence. >>>> >>>> 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 >>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>> news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >>>>>I have (3) subscribers out of a total of 185 that are failing on >>>>>syncing. >>>>> >>>>> The error occurs when trying to apply a script to the subscriber. The >>>>> script was posted using sp_addscriptexec. >>>>> >>>>> >>>>> The schema script >>>>> '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' could >>>>> not be propagated to the subscriber. >>>>> (Source: Merge Replication Provider (Agent); Error >>>>> number: -2147201001) >>>>> --------------------------------------------------------------------------------------------------------------- >>>>> Failed to launch 'osql' >>>>> (Source: SubscriberName\InstanceName (Agent); Error number: 20130) >>>>> --------------------------------------------------------------------------------------------------------------- >>>>> The system cannot find the path specified. >>>>> (Source: (OS); Error number: 3) >>>>> --------------------------------------------------------------------------------------------------------------- >>>>> >>>>> >>>>> The following have been done to troubleshoot >>>>> 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has no >>>>> problem seeing the sql file >>>>> 2) Made sure the SQLAgent was running under the correct user account. >>>>> >>>>> I'm running MSDE 2000 SP3. >>>>> >>>>> Any help would be appreciated. >>>>> Thanks >>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
It appears that osql attempts to connect using the account of the user
running osql not the account running the sql agent service. That is if I don't provide the -U switch. [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:ux96HZCBIHA.3716@TK2MSFTNGP03.phx.gbl... > Can you try this on the problem subscriber(s) > > master.dbo.xp_cmdshell 'dir > \\myserver\sharename\20070927191933967\customer_firstlast.sql' > > The cmd shell should run under the SQL Server agent account on the > subscriber(s). I want to verify it can read this file. > > -- > RelevantNoise.com - dedicated to mining blogs for business intelligence. > > 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 > "Softworks" <subscriber@soft-works.com> wrote in message > news:OPeosL9AIHA.4656@TK2MSFTNGP04.phx.gbl... >> These are pulls over VPN using UNCs. >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:erk2nU8AIHA.5160@TK2MSFTNGP05.phx.gbl... >>> are these pull subscribers using ftp? >>> >>> -- >>> RelevantNoise.com - dedicated to mining blogs for business intelligence. >>> >>> 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 >>> "Softworks" <subscriber@soft-works.com> wrote in message >>> news:%237V1lC5AIHA.4612@TK2MSFTNGP03.phx.gbl... >>>> MSDE 2000 SP3 is running on the subscribers. I'm able to run osql >>>> from the command prompt with no problem. >>>> >>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>> news:Og5n$j3AIHA.4732@TK2MSFTNGP04.phx.gbl... >>>>> sounds like osql is not present on these subscribers. What version of >>>>> SQL Server is running there? >>>>> >>>>> Can you run osql from the command prompt on these subscribers? >>>>> >>>>> -- >>>>> RelevantNoise.com - dedicated to mining blogs for business >>>>> intelligence. >>>>> >>>>> 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 >>>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>>> news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >>>>>>I have (3) subscribers out of a total of 185 that are failing on >>>>>>syncing. >>>>>> >>>>>> The error occurs when trying to apply a script to the subscriber. >>>>>> The script was posted using sp_addscriptexec. >>>>>> >>>>>> >>>>>> The schema script >>>>>> '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' >>>>>> could not be propagated to the subscriber. >>>>>> (Source: Merge Replication Provider (Agent); Error >>>>>> number: -2147201001) >>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>> Failed to launch 'osql' >>>>>> (Source: SubscriberName\InstanceName (Agent); Error number: 20130) >>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>> The system cannot find the path specified. >>>>>> (Source: (OS); Error number: 3) >>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>> >>>>>> >>>>>> The following have been done to troubleshoot >>>>>> 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has >>>>>> no problem seeing the sql file >>>>>> 2) Made sure the SQLAgent was running under the correct user account. >>>>>> >>>>>> I'm running MSDE 2000 SP3. >>>>>> >>>>>> Any help would be appreciated. >>>>>> Thanks >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Yes, that is correct, but replication should use the SQL Server Agent
account to make the connection. Can it? Does that last query I gave you work? -- RelevantNoise.com - dedicated to mining blogs for business intelligence. 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] "Softworks" <subscriber@soft-works.com> wrote in message news:OVOyFpDBIHA.4568@TK2MSFTNGP02.phx.gbl... > It appears that osql attempts to connect using the account of the user > running osql not the account running the sql agent service. That is if I > don't provide the -U switch. > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:ux96HZCBIHA.3716@TK2MSFTNGP03.phx.gbl... >> Can you try this on the problem subscriber(s) >> >> master.dbo.xp_cmdshell 'dir >> \\myserver\sharename\20070927191933967\customer_firstlast.sql' >> >> The cmd shell should run under the SQL Server agent account on the >> subscriber(s). I want to verify it can read this file. >> >> -- >> RelevantNoise.com - dedicated to mining blogs for business intelligence. >> >> 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 >> "Softworks" <subscriber@soft-works.com> wrote in message >> news:OPeosL9AIHA.4656@TK2MSFTNGP04.phx.gbl... >>> These are pulls over VPN using UNCs. >>> >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>> news:erk2nU8AIHA.5160@TK2MSFTNGP05.phx.gbl... >>>> are these pull subscribers using ftp? >>>> >>>> -- >>>> RelevantNoise.com - dedicated to mining blogs for business >>>> intelligence. >>>> >>>> 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 >>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>> news:%237V1lC5AIHA.4612@TK2MSFTNGP03.phx.gbl... >>>>> MSDE 2000 SP3 is running on the subscribers. I'm able to run osql >>>>> from the command prompt with no problem. >>>>> >>>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>>> news:Og5n$j3AIHA.4732@TK2MSFTNGP04.phx.gbl... >>>>>> sounds like osql is not present on these subscribers. What version of >>>>>> SQL Server is running there? >>>>>> >>>>>> Can you run osql from the command prompt on these subscribers? >>>>>> >>>>>> -- >>>>>> RelevantNoise.com - dedicated to mining blogs for business >>>>>> intelligence. >>>>>> >>>>>> 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 >>>>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>>>> news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >>>>>>>I have (3) subscribers out of a total of 185 that are failing on >>>>>>>syncing. >>>>>>> >>>>>>> The error occurs when trying to apply a script to the subscriber. >>>>>>> The script was posted using sp_addscriptexec. >>>>>>> >>>>>>> >>>>>>> The schema script >>>>>>> '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' >>>>>>> could not be propagated to the subscriber. >>>>>>> (Source: Merge Replication Provider (Agent); Error >>>>>>> number: -2147201001) >>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>> Failed to launch 'osql' >>>>>>> (Source: SubscriberName\InstanceName (Agent); Error number: 20130) >>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>> The system cannot find the path specified. >>>>>>> (Source: (OS); Error number: 3) >>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>> >>>>>>> >>>>>>> The following have been done to troubleshoot >>>>>>> 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has >>>>>>> no problem seeing the sql file >>>>>>> 2) Made sure the SQLAgent was running under the correct user >>>>>>> account. >>>>>>> >>>>>>> I'm running MSDE 2000 SP3. >>>>>>> >>>>>>> Any help would be appreciated. >>>>>>> Thanks >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Yes, the DIR query you gave me works.
[quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:O5g0c2DBIHA.4752@TK2MSFTNGP04.phx.gbl... > Yes, that is correct, but replication should use the SQL Server Agent > account to make the connection. Can it? Does that last query I gave you > work? > > -- > RelevantNoise.com - dedicated to mining blogs for business intelligence. > > 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 > "Softworks" <subscriber@soft-works.com> wrote in message > news:OVOyFpDBIHA.4568@TK2MSFTNGP02.phx.gbl... >> It appears that osql attempts to connect using the account of the user >> running osql not the account running the sql agent service. That is if >> I don't provide the -U switch. >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:ux96HZCBIHA.3716@TK2MSFTNGP03.phx.gbl... >>> Can you try this on the problem subscriber(s) >>> >>> master.dbo.xp_cmdshell 'dir >>> \\myserver\sharename\20070927191933967\customer_firstlast.sql' >>> >>> The cmd shell should run under the SQL Server agent account on the >>> subscriber(s). I want to verify it can read this file. >>> >>> -- >>> RelevantNoise.com - dedicated to mining blogs for business intelligence. >>> >>> 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 >>> "Softworks" <subscriber@soft-works.com> wrote in message >>> news:OPeosL9AIHA.4656@TK2MSFTNGP04.phx.gbl... >>>> These are pulls over VPN using UNCs. >>>> >>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>> news:erk2nU8AIHA.5160@TK2MSFTNGP05.phx.gbl... >>>>> are these pull subscribers using ftp? >>>>> >>>>> -- >>>>> RelevantNoise.com - dedicated to mining blogs for business >>>>> intelligence. >>>>> >>>>> 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 >>>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>>> news:%237V1lC5AIHA.4612@TK2MSFTNGP03.phx.gbl... >>>>>> MSDE 2000 SP3 is running on the subscribers. I'm able to run osql >>>>>> from the command prompt with no problem. >>>>>> >>>>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>>>> news:Og5n$j3AIHA.4732@TK2MSFTNGP04.phx.gbl... >>>>>>> sounds like osql is not present on these subscribers. What version >>>>>>> of SQL Server is running there? >>>>>>> >>>>>>> Can you run osql from the command prompt on these subscribers? >>>>>>> >>>>>>> -- >>>>>>> RelevantNoise.com - dedicated to mining blogs for business >>>>>>> intelligence. >>>>>>> >>>>>>> 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 >>>>>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>>>>> news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >>>>>>>>I have (3) subscribers out of a total of 185 that are failing on >>>>>>>>syncing. >>>>>>>> >>>>>>>> The error occurs when trying to apply a script to the subscriber. >>>>>>>> The script was posted using sp_addscriptexec. >>>>>>>> >>>>>>>> >>>>>>>> The schema script >>>>>>>> '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' >>>>>>>> could not be propagated to the subscriber. >>>>>>>> (Source: Merge Replication Provider (Agent); Error >>>>>>>> number: -2147201001) >>>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>>> Failed to launch 'osql' >>>>>>>> (Source: SubscriberName\InstanceName (Agent); Error number: 20130) >>>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>>> The system cannot find the path specified. >>>>>>>> (Source: (OS); Error number: 3) >>>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>>> >>>>>>>> >>>>>>>> The following have been done to troubleshoot >>>>>>>> 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has >>>>>>>> no problem seeing the sql file >>>>>>>> 2) Made sure the SQLAgent was running under the correct user >>>>>>>> account. >>>>>>>> >>>>>>>> I'm running MSDE 2000 SP3. >>>>>>>> >>>>>>>> Any help would be appreciated. >>>>>>>> Thanks >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
I finally resolved the issue and don't understand how this could happen.
With the verbose flag on I found that it was looking for osql.exe in a folder that does not exist. The osql command is: "C:\Program Files\Microsoft SQL Server\80\Too\Binn\osql.exe" My other subscriber had the same issue where it was looking for osql.exe in SQL Server\80\Tool\Binn\osql.exe In the past four years I've been running osql from the command line on these subscribers with no problem. For some reason Replication is looking in these bizarre folders for osql.exe. Have you ever come across this in your working with replication? [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:O5g0c2DBIHA.4752@TK2MSFTNGP04.phx.gbl... > Yes, that is correct, but replication should use the SQL Server Agent > account to make the connection. Can it? Does that last query I gave you > work? > > -- > RelevantNoise.com - dedicated to mining blogs for business intelligence. > > 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 > "Softworks" <subscriber@soft-works.com> wrote in message > news:OVOyFpDBIHA.4568@TK2MSFTNGP02.phx.gbl... >> It appears that osql attempts to connect using the account of the user >> running osql not the account running the sql agent service. That is if >> I don't provide the -U switch. >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:ux96HZCBIHA.3716@TK2MSFTNGP03.phx.gbl... >>> Can you try this on the problem subscriber(s) >>> >>> master.dbo.xp_cmdshell 'dir >>> \\myserver\sharename\20070927191933967\customer_firstlast.sql' >>> >>> The cmd shell should run under the SQL Server agent account on the >>> subscriber(s). I want to verify it can read this file. >>> >>> -- >>> RelevantNoise.com - dedicated to mining blogs for business intelligence. >>> >>> 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 >>> "Softworks" <subscriber@soft-works.com> wrote in message >>> news:OPeosL9AIHA.4656@TK2MSFTNGP04.phx.gbl... >>>> These are pulls over VPN using UNCs. >>>> >>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>> news:erk2nU8AIHA.5160@TK2MSFTNGP05.phx.gbl... >>>>> are these pull subscribers using ftp? >>>>> >>>>> -- >>>>> RelevantNoise.com - dedicated to mining blogs for business >>>>> intelligence. >>>>> >>>>> 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 >>>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>>> news:%237V1lC5AIHA.4612@TK2MSFTNGP03.phx.gbl... >>>>>> MSDE 2000 SP3 is running on the subscribers. I'm able to run osql >>>>>> from the command prompt with no problem. >>>>>> >>>>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>>>> news:Og5n$j3AIHA.4732@TK2MSFTNGP04.phx.gbl... >>>>>>> sounds like osql is not present on these subscribers. What version >>>>>>> of SQL Server is running there? >>>>>>> >>>>>>> Can you run osql from the command prompt on these subscribers? >>>>>>> >>>>>>> -- >>>>>>> RelevantNoise.com - dedicated to mining blogs for business >>>>>>> intelligence. >>>>>>> >>>>>>> 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 >>>>>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>>>>> news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >>>>>>>>I have (3) subscribers out of a total of 185 that are failing on >>>>>>>>syncing. >>>>>>>> >>>>>>>> The error occurs when trying to apply a script to the subscriber. >>>>>>>> The script was posted using sp_addscriptexec. >>>>>>>> >>>>>>>> >>>>>>>> The schema script >>>>>>>> '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' >>>>>>>> could not be propagated to the subscriber. >>>>>>>> (Source: Merge Replication Provider (Agent); Error >>>>>>>> number: -2147201001) >>>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>>> Failed to launch 'osql' >>>>>>>> (Source: SubscriberName\InstanceName (Agent); Error number: 20130) >>>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>>> The system cannot find the path specified. >>>>>>>> (Source: (OS); Error number: 3) >>>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>>> >>>>>>>> >>>>>>>> The following have been done to troubleshoot >>>>>>>> 1) Net use \\myserver\sharename\20070927191933967 -- subscriber has >>>>>>>> no problem seeing the sql file >>>>>>>> 2) Made sure the SQLAgent was running under the correct user >>>>>>>> account. >>>>>>>> >>>>>>>> I'm running MSDE 2000 SP3. >>>>>>>> >>>>>>>> Any help would be appreciated. >>>>>>>> Thanks >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
nope.
-- RelevantNoise.com - dedicated to mining blogs for business intelligence. 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] "Softworks" <subscriber@soft-works.com> wrote in message news:ueCDIyVBIHA.2004@TK2MSFTNGP06.phx.gbl... >I finally resolved the issue and don't understand how this could happen. > > With the verbose flag on I found that it was looking for osql.exe in a > folder that does not exist. > The osql command is: "C:\Program Files\Microsoft SQL > Server\80\Too\Binn\osql.exe" > > My other subscriber had the same issue where it was looking for osql.exe > in SQL Server\80\Tool\Binn\osql.exe > > In the past four years I've been running osql from the command line on > these subscribers with no problem. For some reason Replication is > looking in these bizarre folders for osql.exe. > > Have you ever come across this in your working with replication? > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:O5g0c2DBIHA.4752@TK2MSFTNGP04.phx.gbl... >> Yes, that is correct, but replication should use the SQL Server Agent >> account to make the connection. Can it? Does that last query I gave you >> work? >> >> -- >> RelevantNoise.com - dedicated to mining blogs for business intelligence. >> >> 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 >> "Softworks" <subscriber@soft-works.com> wrote in message >> news:OVOyFpDBIHA.4568@TK2MSFTNGP02.phx.gbl... >>> It appears that osql attempts to connect using the account of the user >>> running osql not the account running the sql agent service. That is if >>> I don't provide the -U switch. >>> >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>> news:ux96HZCBIHA.3716@TK2MSFTNGP03.phx.gbl... >>>> Can you try this on the problem subscriber(s) >>>> >>>> master.dbo.xp_cmdshell 'dir >>>> \\myserver\sharename\20070927191933967\customer_firstlast.sql' >>>> >>>> The cmd shell should run under the SQL Server agent account on the >>>> subscriber(s). I want to verify it can read this file. >>>> >>>> -- >>>> RelevantNoise.com - dedicated to mining blogs for business >>>> intelligence. >>>> >>>> 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 >>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>> news:OPeosL9AIHA.4656@TK2MSFTNGP04.phx.gbl... >>>>> These are pulls over VPN using UNCs. >>>>> >>>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>>> news:erk2nU8AIHA.5160@TK2MSFTNGP05.phx.gbl... >>>>>> are these pull subscribers using ftp? >>>>>> >>>>>> -- >>>>>> RelevantNoise.com - dedicated to mining blogs for business >>>>>> intelligence. >>>>>> >>>>>> 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 >>>>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>>>> news:%237V1lC5AIHA.4612@TK2MSFTNGP03.phx.gbl... >>>>>>> MSDE 2000 SP3 is running on the subscribers. I'm able to run osql >>>>>>> from the command prompt with no problem. >>>>>>> >>>>>>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>>>>>> news:Og5n$j3AIHA.4732@TK2MSFTNGP04.phx.gbl... >>>>>>>> sounds like osql is not present on these subscribers. What version >>>>>>>> of SQL Server is running there? >>>>>>>> >>>>>>>> Can you run osql from the command prompt on these subscribers? >>>>>>>> >>>>>>>> -- >>>>>>>> RelevantNoise.com - dedicated to mining blogs for business >>>>>>>> intelligence. >>>>>>>> >>>>>>>> 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 >>>>>>>> "Softworks" <subscriber@soft-works.com> wrote in message >>>>>>>> news:%235xSFkwAIHA.1208@TK2MSFTNGP03.phx.gbl... >>>>>>>>>I have (3) subscribers out of a total of 185 that are failing on >>>>>>>>>syncing. >>>>>>>>> >>>>>>>>> The error occurs when trying to apply a script to the subscriber. >>>>>>>>> The script was posted using sp_addscriptexec. >>>>>>>>> >>>>>>>>> >>>>>>>>> The schema script >>>>>>>>> '0\\myserver\sharename\20070927191933967\customer_firstlast.sql' >>>>>>>>> could not be propagated to the subscriber. >>>>>>>>> (Source: Merge Replication Provider (Agent); Error >>>>>>>>> number: -2147201001) >>>>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>>>> Failed to launch 'osql' >>>>>>>>> (Source: SubscriberName\InstanceName (Agent); Error number: 20130) >>>>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>>>> The system cannot find the path specified. >>>>>>>>> (Source: (OS); Error number: 3) >>>>>>>>> --------------------------------------------------------------------------------------------------------------- >>>>>>>>> >>>>>>>>> >>>>>>>>> The following have been done to troubleshoot >>>>>>>>> 1) Net use \\myserver\sharename\20070927191933967 -- subscriber >>>>>>>>> has no problem seeing the sql file >>>>>>>>> 2) Made sure the SQLAgent was running under the correct user >>>>>>>>> account. >>>>>>>>> >>>>>>>>> I'm running MSDE 2000 SP3. >>>>>>>>> >>>>>>>>> Any help would be appreciated. >>>>>>>>> Thanks >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
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 |