Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Unanswered: Any one who knows this error about SQL 65 upgrade? it's urgent, thanks.

    Hi All,

    I am doing the upgrade from SQL6.5 to SQL2K, the server version is:
    SQL 6.5 English SP5 on WinNT Enterprise 4.0 English SP6,
    new server is SQL 2K standard English SP1 on WinNT Enterprise 4.0 English SP6.

    When I use SQL upgrade wizard to perform a two server upgrade, all steps seems ok, when move to the step of "Export & Import Via Name Pipe" I got a error. Pls see the below error. Pls let me know the reason and how to resolve it.



    log file: Export and Import via Named Pipe - 007test.err

    ############# Log file content ############
    Export.exe on the remote machine was hung...

    Export Exit Code: 259 - export.exe -CodePage 1252 -DeviceType Pipe -AllTables yes -MasterPath D:\MSSQL\DATA\MASTER.DAT -DatabaseName test -DevicePath \\.\pipe\~cnvpipe0

    Import Exit Code: -1 - ~cnvpipe0

    Msg 4854, Level 21, State 1, Server NTAPPLIX02, Procedure , Line 1

    [Microsoft][ODBC SQL Server Driver][SQL Server]****

    Time:12-03-2003 17:05:04.433

    Error return from function CreateFile

    in file CnvPipe.cpp

    Line=142

    rc=1326

    Msg=Logon failure: unknown user name or bad password.


    ****
    ######################################

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Create/use a domain account for both sql server's service startup account. Make sure to add this domain account to the local admin group. Lastly, login using this domain account to run the upgrade.

  3. #3
    Join Date
    Oct 2003
    Posts
    6
    Originally posted by rnealejr
    Create/use a domain account for both sql server's service startup account. Make sure to add this domain account to the local admin group. Lastly, login using this domain account to run the upgrade.
    Hi,

    Thanks, because the SQL65 server does not join any domain just a stand alone server, and i can not join this SQL server to any existing domain, but the SQL2K server is in a NT domain. Any solution for this situation ? One more problem, is the name pipe only connection method when perform a two server SQL upgrade?

    Many thanks,

    Zhanlan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •