"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:%23qYcOWw7EHA.3756@TK2MSFTNGP14.phx.gbl...
> Totally stumped. How I got here ...
>
> I've had a database set up for merge replication. Initially it had 2
> publications, but I just scripted them out and deleted them when I ran
> into this issue, so there are currently no publications on the database.
>
> I had some scandisk errors that had affected SQL Server 2k Dev. Ed.,
> including a failure to initialize the snap-in for Enterprise Manager, so I
> reinstalled SQL2k and then reapplied SP3. All went normal except at the
> very end, I received the error message that sp_vupgrade_replication.sql
> failed. The Enterprise Manager now works, all tools, etc. ... except of
> course, replication.
>
> So I re-ran SP3 as sa instead of using Windows authentication. Same
> result.
>
> I ran sp_vupgrade_replication.sql from QA and I get error messages there
> also.
>
> I've read all the posts I can find on sp_vupgrade_replication and none
> seem to help resolve this issue, so any advice would be greatly
> appreciated.
>

"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:OhDbEcw7EHA.3376@TK2MSFTNGP12.phx.gbl...
> When I try to run sp_vupgrade_replication.sql from the QA, I get two
> errors:
>
> Server: Msg 14113, Level 16, State 1, Procedure sp_vupgrade_replication,
> Line 126
> Could not execute '" "F:\Program Files\Microsoft SQL
> Server\80\Tools\binn\osql" -Usa -P -S"EARL-XPPRO" -l30 -t120 -b -ddistribution
> -i"F:\Program Files\Microsoft SQL
> Server\MSSQL\install\instdist.sql" -o"F:\Program Files\Microsoft SQL
> Server\MSSQL\install\instdist.out" "'. Check 'instdist.out' in the install
> directory.
>
> and ....
>
> Server: Msg 170, Level 15, State 1, Line 1
> Line 1: Incorrect syntax near '('.
>
> In instdist.out, I get a one-line message: "Login failed for user 'sa'."
>
>
>
>
>
>
>
>
>
>
> "Earl" <brikshoe@newsgroups.nospam> wrote in message
> news:%23qYcOWw7EHA.3756@TK2MSFTNGP14.phx.gbl...
>> Totally stumped. How I got here ...
>>
>> I've had a database set up for merge replication. Initially it had 2
>> publications, but I just scripted them out and deleted them when I ran
>> into this issue, so there are currently no publications on the database.
>>
>> I had some scandisk errors that had affected SQL Server 2k Dev. Ed.,
>> including a failure to initialize the snap-in for Enterprise Manager, so
>> I reinstalled SQL2k and then reapplied SP3. All went normal except at the
>> very end, I received the error message that sp_vupgrade_replication.sql
>> failed. The Enterprise Manager now works, all tools, etc. ... except of
>> course, replication.
>>
>> So I re-ran SP3 as sa instead of using Windows authentication. Same
>> result.
>>
>> I ran sp_vupgrade_replication.sql from QA and I get error messages there
>> also.
>>
>> I've read all the posts I can find on sp_vupgrade_replication and none
>> seem to help resolve this issue, so any advice would be greatly
>> appreciated.
>>
>
>

"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:ulKzsiw7EHA.3820@TK2MSFTNGP11.phx.gbl...
> Eliminated the first error message by changing the sa password to nothing.
>
> Still receiving the "Incorrect syntax ... " error message however.
>
>
> "Earl" <brikshoe@newsgroups.nospam> wrote in message
> news:OhDbEcw7EHA.3376@TK2MSFTNGP12.phx.gbl...
>> When I try to run sp_vupgrade_replication.sql from the QA, I get two
>> errors:
>>
>> Server: Msg 14113, Level 16, State 1, Procedure sp_vupgrade_replication,
>> Line 126
>> Could not execute '" "F:\Program Files\Microsoft SQL
>> Server\80\Tools\binn\osql" -Usa -P -S"EARL-XPPRO" -l30 -t120 -b -ddistribution
>> -i"F:\Program Files\Microsoft SQL
>> Server\MSSQL\install\instdist.sql" -o"F:\Program Files\Microsoft SQL
>> Server\MSSQL\install\instdist.out" "'. Check 'instdist.out' in the
>> install directory.
>>
>> and ....
>>
>> Server: Msg 170, Level 15, State 1, Line 1
>> Line 1: Incorrect syntax near '('.
>>
>> In instdist.out, I get a one-line message: "Login failed for user 'sa'."
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> "Earl" <brikshoe@newsgroups.nospam> wrote in message
>> news:%23qYcOWw7EHA.3756@TK2MSFTNGP14.phx.gbl...
>>> Totally stumped. How I got here ...
>>>
>>> I've had a database set up for merge replication. Initially it had 2
>>> publications, but I just scripted them out and deleted them when I ran
>>> into this issue, so there are currently no publications on the database.
>>>
>>> I had some scandisk errors that had affected SQL Server 2k Dev. Ed.,
>>> including a failure to initialize the snap-in for Enterprise Manager, so
>>> I reinstalled SQL2k and then reapplied SP3. All went normal except at
>>> the very end, I received the error message that
>>> sp_vupgrade_replication.sql failed. The Enterprise Manager now works,
>>> all tools, etc. ... except of course, replication.
>>>
>>> So I re-ran SP3 as sa instead of using Windows authentication. Same
>>> result.
>>>
>>> I ran sp_vupgrade_replication.sql from QA and I get error messages there
>>> also.
>>>
>>> I've read all the posts I can find on sp_vupgrade_replication and none
>>> seem to help resolve this issue, so any advice would be greatly
>>> appreciated.
>>>
>>
>>
>
>