Results 1 to 15 of 15
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: SQL2K Setup Error

    When I try to install the sql server 2000 Personal Edition in my XP pro, the installation crashes.

    Error detail:
    AppName: _ins5576._mp AppVer: 5.53.168.0
    ModName: sqlsui.dll
    ModVer: 2000.80.194.0 Offset: 000280fd

    I've been doing a few things trying to fix the problem, but I still receiving the same error. For example, I've replaced the sqlsui.dll with the file contained in SP2; I've changed my local settings using control panel; I've enabled TCP/IP pipes using cliconfg.exe....

    Can anyone help me

    Thank you

  2. #2
    Join Date
    Oct 2003
    Posts
    4

    Re: SQL2K Setup Error

    hi,

    i'm getting the exact error while installing the sql server 2000. have you happened to resolve the problem besides switching to win2K?

    serina.

    Originally posted by felmuno
    When I try to install the sql server 2000 Personal Edition in my XP pro, the installation crashes.

    Error detail:
    AppName: _ins5576._mp AppVer: 5.53.168.0
    ModName: sqlsui.dll
    ModVer: 2000.80.194.0 Offset: 000280fd

    I've been doing a few things trying to fix the problem, but I still receiving the same error. For example, I've replaced the sqlsui.dll with the file contained in SP2; I've changed my local settings using control panel; I've enabled TCP/IP pipes using cliconfg.exe....

    Can anyone help me

    Thank you

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    SP2 ( or 3A ) may be the go.

    http://support.microsoft.com/default...b;en-us;308866

    Cheers

    SG

  4. #4
    Join Date
    Oct 2003
    Posts
    4

    Red face SQL2K installation on XP Prof

    I'm still unalbe to install the SQL Server 2000 installed on XP Prof SP1 (Eng locale) with the sqlsui.dll that comes with SP3. The installation just halted without giving any error message after asking for SA passowrd authentication. Attached please find the sqlstp.log with the error I'm getting.
    FYI, I've also installed MDAC 2.8 on my PC.

    sqlstp.log (using sqlsui.dll in SP3):

    13:20:44 Local-Domain = 3855
    13:20:44 AutoStart = 15
    13:20:44 Result = 1
    13:20:44 End Action DlgServices
    13:20:44 begin ShowDialogsUpdateMask
    13:20:44 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
    13:20:44 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
    13:20:44 Dialog 0x400000 returned: 1
    13:20:44 End Action ShowDialogsHlpr
    13:20:44 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
    13:20:44 Begin Action ShowDialogsHlpr: 0x800000
    13:20:44 Begin Action: DlgSQLSecurity
    13:20:47 ShowDlgSQLSecurity returned: 1
    13:20:47 LoginMode = 2,szPwd
    13:20:47 End Action DlgSQLSecurity
    13:20:47 begin ShowDialogsUpdateMask
    13:20:47 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
    13:20:47 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
    13:20:47 Dialog 0x800000 returned: 1
    13:20:47 End Action ShowDialogsHlpr
    13:20:47 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
    13:20:47 Begin Action ShowDialogsHlpr: 0x1000000
    13:20:47 Begin Action: DlgCollation
    13:20:47 ShowDlgCollation returned: -1
    13:20:47 ShowDlgCollation: GetLastError returned: 50042
    13:20:47 End Action DlgCollation
    13:20:47 End Action ShowDialogs
    13:20:47 Action CleanUpInstall:
    13:20:47 StatsGenerate returned: 2
    13:20:47 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
    13:20:47 StatsGenerate -1,serina_lee)
    13:20:47 Installation Failed.

    sqlstp.log (using original sqlsui.dll in SQL2K CD media)
    13:14:52 Local-Domain = 3855
    13:14:52 AutoStart = 15
    13:14:52 Result = 1
    13:14:52 End Action DlgServices
    13:14:52 begin ShowDialogsUpdateMask
    13:14:52 nFullMask = 0xbdc0037, nCurrent = 0x400000, nDirection = 1
    13:14:52 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
    13:14:52 Dialog 0x400000 returned: 1
    13:14:52 End Action ShowDialogsHlpr
    13:14:52 ShowDialogsGetDialog returned: nCurrent=0x800000,index=23
    13:14:52 Begin Action ShowDialogsHlpr: 0x800000
    13:14:52 Begin Action: DlgSQLSecurity
    13:14:57 ShowDlgSQLSecurity returned: 1
    13:14:57 LoginMode = 2,szPwd
    13:14:57 End Action DlgSQLSecurity
    13:14:57 begin ShowDialogsUpdateMask
    13:14:57 nFullMask = 0xbdc0037, nCurrent = 0x800000, nDirection = 1
    13:14:57 Updated Dialog Mask: 0xbdc0037, Disable Back = 0x1
    13:14:57 Dialog 0x800000 returned: 1
    13:14:57 End Action ShowDialogsHlpr
    13:14:57 ShowDialogsGetDialog returned: nCurrent=0x1000000,index=24
    13:14:57 Begin Action ShowDialogsHlpr: 0x1000000
    13:14:57 Begin Action: DlgCollation

  5. #5
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    OK. Yuck.
    How much disk space do you have by the way?
    You need 150 MB minimum really......

    Normally SQL installs easily enough. I suspect you may need to do the following:
    (1) Remove TOTALLY ( from recycle bin as well ) the
    \Microsoft SQL Server or \MSSQL directory ( usually its under C:\Program Files dir ).
    (2) Once this is done. Try the re-install.

    If this doesnt work, you may need to delete keys from the Registry as the Reg holds config info.

    Post back if probs.

    Cheers,

    SG.

  6. #6
    Join Date
    Oct 2003
    Posts
    4

    SQL2K installation on XP Prof

    hey sg, thx for your recommendation. you are right that the sql server installation should be easy in most cases but i found a similar issues who had problems with the installation on XP. some even swapped the OS to win2k.

    i do have 14G free space in my harddrive and i've already removed all the sql server keys from the registry.

    so does that mean i have to use win2k instead of xp for the sql server installation?

    SL

  7. #7
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    Check this out...

    http://dbforums.com/arch/66/2002/10/520541

    Cheers

    SG

  8. #8
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253
    In my experience, I have only been able to install the client tools (EM, QA, Profiler, etc.) on Windows XP (Pro or Home), even with the most recent Service Packs.
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  9. #9
    Join Date
    Sep 2003
    Posts
    522
    i am running default and 2 named instances on this xp workstation and a default instance of 7.0 and a named instance of 2k on my laptop at home (also xp). but earlier you mentioned that you also had msde running or previously installed?

  10. #10
    Join Date
    Oct 2003
    Posts
    4

    SQL2K installation on XP Prof

    Well, I'm using the latest MSDE which is v.2.8.
    So you have SQL2K successfully installed on XP Workstation. Workstation should be the same as the professional version. Did you encounter any errors during the installation process?

    sl.

  11. #11
    Join Date
    Sep 2003
    Posts
    522
    the only problem i had was when i attempted to install msde sp3 on my laptop which ruined my original install. once i realized that a standard sp3 for a sql server is what i need to use for my personal addition, - i blew away msde, 7.0, and the corrupted install of the personal edition, deleted registry keys, reinstalled 7.0 and the personal edition, re-applied sp4 for 7.0 and sp3 for 2k, - and i have no complaints since.

  12. #12
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253
    Oops - forgot to qualify my last remarks...I was trying to install Enterprise Edition of SQL 2K onto XP Professional. Have never tried to install Personal Edition...

    Sorry for the confusion.
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  13. #13
    Join Date
    Sep 2003
    Posts
    522
    i don't think EE will work on a workstation.

  14. #14
    Join Date
    Feb 2004
    Posts
    1

    Re: SQL2K Setup Error

    Originally posted by felmuno
    When I try to install the sql server 2000 Personal Edition in my XP pro, the installation crashes.

    Error detail:
    AppName: _ins5576._mp AppVer: 5.53.168.0
    ModName: sqlsui.dll
    ModVer: 2000.80.194.0 Offset: 000280fd

    I've been doing a few things trying to fix the problem, but I still receiving the same error. For example, I've replaced the sqlsui.dll with the file contained in SP2; I've changed my local settings using control panel; I've enabled TCP/IP pipes using cliconfg.exe....

    Can anyone help
    Thank you
    Hi, This problem was happening to me. I was working in a xp pc ,english version, but my regional settings were Spanish Colombia. So, I change this options to English USA and solve the trouble. Finally, i can install server tools with my sql server 2000 dep edition. i hope this help you.

  15. #15
    Join Date
    Apr 2004
    Posts
    1

    Re: SQL2K Setup Error

    thank you! It really works.

Posting Permissions

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