MS SQL Server ODBC - Re: Impossible to reinstall and configure SQL Server

Author

Re: Impossible to reinstall and configure SQL Server

Mark Hurd

2005-05-13, 3:23 am

Windwizard wrote:
<snip>
> It seemed that all ODBC drivers were gone.
> However, I was able to connect to the server via network.
>
>
> Trying to get rid of this problem I uninstalled SQL Server and now I'm
> trying to install it back.
> I can not. In the very end of installation I get the following message.
>
> <Setup failed to configure the server. Refer to the server error logs and
> C:\windows\sqlstp.log for more information.>
>
> In the end of sqlstp.log I found the following lines.
>
> ---
> Starting Service ...
> Cyrillic_General_CI_
AS
> -m -Q -T4022 -T3659
>
> Connecting to Server ...
> driver={sql server};server=RUWS4
003;UID=sa;PWD=;data
base=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=RUWS4
003;UID=sa;PWD=;data
base=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> driver={sql server};server=RUWS4
003;UID=sa;PWD=;data
base=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> SQL Server configuration failed.
> ---
>
> I tried to install the newest MDAC2.8 but it didn't help.
>
> Configuration
>
> Windows 2003 Server,
> SQL Server 2000 Standart Edition.

We're seeing the same scenario with Win2k SP2 and MSDE2000A.

It seems we've lost the ODBC driver registry entries. The files ODBC.INI and
ODBCINST.INI seem to have valid contents, but the corresponding registry
entries are missing.

We're intending to apply the registry entries from a working system, but
we'd like to know what happened and if future driver installations &
upgrades will take automatically...

--
Regards,
Mark Hurd, B.Sc.(Ma.) (Hons.)

Lori McDonald

2005-05-13, 3:23 am

Thank you!!! After searching high and low for my problem this fixed it for me.

I rebooted.

Then I manually cleaned out my registry and deleted my program files

Then I imported the HKEY_LOCAL_MACHINE\S
OFTWARE\ODBC from a machine where it
was working.

I rebooted again and then did the install and it worked!!

Thank you!

"Mark Hurd" wrote:

> Windwizard wrote:
> <snip>
>
>
> We're seeing the same scenario with Win2k SP2 and MSDE2000A.
>
> It seems we've lost the ODBC driver registry entries. The files ODBC.INI and
> ODBCINST.INI seem to have valid contents, but the corresponding registry
> entries are missing.
>
> We're intending to apply the registry entries from a working system, but
> we'd like to know what happened and if future driver installations &
> upgrades will take automatically...
>
> --
> Regards,
> Mark Hurd, B.Sc.(Ma.) (Hons.)
>
>

Mark Hurd

2005-05-16, 3:23 am

Lori McDonald wrote:
> "Mark Hurd" wrote:
<snip>[color=darkred]
>
> Thank you!!! After searching high and low for my problem this fixed it
> for me.
>
> I rebooted.
>
> Then I manually cleaned out my registry and deleted my program files
>
> Then I imported the HKEY_LOCAL_MACHINE\S
OFTWARE\ODBC from a machine where
> it was working.
>
> I rebooted again and then did the install and it worked!!
>
> Thank you!

Yes, we can also confirm this gets MSDE installed.

Still looking for the reason why the ODBC registry keys were empty...
--
Regards,
Mark Hurd, B.Sc.(Ma.) (Hons.)

Addcom

2005-06-02, 7:23 am

Hi
Just give this a try
Go to AddRemove program and check if the SQL progroam or MSDE is still
installed.
If it is then uninstall.
Go to ptrogram Files\Microsoft Server SQL ir the location where the server
program are installed. Delete the folder.
I experience this before if you install MSDE2000 and something goes wrong or
stop the install in the middle then you get the problem you described,...
I think it is to do with the master.mdb being corrupt
have go and lets know

"Mark Hurd" <markhurd@ozemail.com.au> wrote in message
news:ea6sDn3VFHA.2984@tk2msftngp13.phx.gbl...
> Windwizard wrote:
> <snip>
>
>
> We're seeing the same scenario with Win2k SP2 and MSDE2000A.
>
> It seems we've lost the ODBC driver registry entries. The files ODBC.INI
> and
> ODBCINST.INI seem to have valid contents, but the corresponding registry
> entries are missing.
>
> We're intending to apply the registry entries from a working system, but
> we'd like to know what happened and if future driver installations &
> upgrades will take automatically...
>
> --
> Regards,
> Mark Hurd, B.Sc.(Ma.) (Hons.)
>

Sponsored Links