Post reply

Trouble installing SQL Server....Please help

  • February 25, 2004 at 2:20 am

    #83867

    Hello,

    I have run sql server 2000 and analysis manager on my laptop for a few months with no probs. On Monday I tried to connect to my computer server from sql server ent manager and it said "no datasource found." and something else about MS ODBC drivers being invalid. Analysis services still worked fine. I tired to connect and add servers and it just would not recognise anything so became software I could not use at all. I then uninstalled all sql server products on my computer. I thought a fresh reinstall would do the job. However now when I try to install sql server I get an error in the installation. It says that it cannot connect to the datasource and installation fails. It tells me to look in a sqlstp log and the bottom of this log is below

    15:50:25 Begin Action:  DialogShowSdUninstall

    15:50:28 ShowDlgUninstall returned : 1

    15:50:28 End Action DialogShowSdUninstall

    15:50:28 Dialog 0x80000000 returned: 1

    15:50:28 End Action ShowDialogsHlpr

    15:50:28 ShowDialogsGetDialog returned: nCurrent=0x0,index=0

    15:50:28 End Action ShowDialogs

    15:50:29 Action CleanUpInstall:

    15:50:29 StatsGenerate returned: 2

    15:50:29 StatsGenerate (0xc0200805,0x2,0xf000000,0x400,1033,303,0x2,0x1,0,0,0

    15:50:29 StatsGenerate -1,rj)

    15:50:29 Installation Failed.

    I havent shown the rest of the log because there is a lot of it. If needed I can copy in the rest.

    The rest of the installation up to this point seems fine. HOwever it doesnt install the unistall files so I cannot uninstall SQL Server now. There is 105 MB of the program on my computer which I can only delete although I havent done this yet.

    Why wont sql server let me install? It is a really annoying problem because it worked fine last Friday and then on Monday it went wrong and I cannot remember doing anything to make this happen. All MS updates are up-to-date. Any help is greatly appreciated

    Thanks

    Richard

  • March 1, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • March 1, 2004 at 8:20 am

    #496465

    If you really want to get rid of SQL Server and start again you could follow the steps in http://support.microsoft.com/default.aspx?scid=kb;EN-US;290991 

    I have been forced to use this in the past and it does work (even though it's not very pretty).

    As for the problem that you are experiencing, I've not seen that before.


    Shamless self promotion - read my blog http://sirsql.net

  • March 2, 2004 at 2:36 am

    #496610

    Thanks for the reply Stacenic. I will look at the link and try it out later today. I will post back in the next few days to let you know how I get on

    Richard

  • March 9, 2004 at 5:28 am

    #497946

    PROBLEM SOLVED!

    The transaction log when I got the error said something about ODBC drivers so I went to the ms web site and downloaded the lastest MDAC drivers

    (http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&DisplayLang=en)

    I then tried the installation and it worked. I guess some of my original driver files must have been corrupt

    (Thanks for your help stacenic I tried what the link said but it didnt work either)

    Richard

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply