MSDE setup errors

I am trying install MSDE on XPSP2 pro. It fails the following set of erros
in the setup log. These lines are from a non-verbose log I created while
running the setup.
Appreciate any help.
Thanks
Shishir
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action SkuIt
Setting SqlEdition property failed
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
-V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
-- Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
I got some info on the possible causes of failure as below. Unfortunately
neither of them help.
If your machine name has lowercase characters then you may be hitting this
issue - http://support.microsoft.com/default...;en-us;Q285100
If you had a old instance of MSDE on the machine you may be hitting this
issue - http://support.microsoft.com/default...b;en-us;816499
"Shishir" wrote:

> I am trying install MSDE on XPSP2 pro. It fails the following set of erros
> in the setup log. These lines are from a non-verbose log I created while
> running the setup.
> Appreciate any help.
> Thanks
> Shishir
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action SkuIt
> Setting SqlEdition property failed
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> TempFolder is
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
> Loading extended custom action library
> C:\DOCUME~1\Admin\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
> SOFTWARE\Microsoft\Microsoft SQL Server
> Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
> Starting custom action ConfigServer
> Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe
> -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> MSI (s) (B4!D0) [17:39:55:781]: Product: Microsoft SQL Server Desktop Engine
> -- Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
>
|||hi Shishir,
Shishir wrote:
> I am trying install MSDE on XPSP2 pro. It fails the following set
> of erros in the setup log. These lines are from a non-verbose log I
> created while running the setup.
>..
> Engine -- Setup failed to configure the server. Refer to the server
> error logs and setup error logs for more information.
this exception is sometime related to MDAC stack corruption... as no MDAC XP
sp2 refresh is available to fix it, you can only go as indicated in
http://www.macropool.com/en/download/mdac_xp_sp2.html
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I downloaded the repair tool and reregistered all the components. It still
fails the same way.
"Andrea Montanari" wrote:

> hi Shishir,
> Shishir wrote:
> this exception is sometime related to MDAC stack corruption... as no MDAC XP
> sp2 refresh is available to fix it, you can only go as indicated in
> http://www.macropool.com/en/download/mdac_xp_sp2.html
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
sql

MSDE Remote Connect strange problem

I'm trying to connect to the SharePoint MSDE database from Windows XP

SP2 machine over Ethernet LAN. I was getting server not found or access

denied, until I enabled TCP/IP via svrnetcn.exe. Now, I'm getting

OK

Connection failed:

SQLState: '01000'

SQL Server Error: 10061

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen

(Connect()).

Connection failed:

SQLState: '08001'

SQL Server Error: 17

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not

exist or access denied.

I just did an netstat -an and I don't see the server listening on 1433.

What am I not doing?

The svrnetcn tool has no effect. I make a change and check the logs,

but nothing happens. What would be causing this?

Did you ever get an answer to this problem? I'm having a similar error on Windows XP SP2 machines that have MDAC 2.8SP1. I have an MS Access front end that links to SQL Server database using ODBC connections. The report will run, but keeps asking for SQL Server login info, then finally I get the same Connection failed error you listed with the exception on the line: SQL Server Error: 10048. However, the report actually finishes with all the data requested.

I have this same Access front end running on other XP machines with SP1 and Windows 2000 machines with MDAC 2.7 SP1. When the report runs on those machines it only asks for SQL Server login info when the program is first connecting to the db.

Any ideas?

|||

Thank you thank you for letting me know about the svrnetcn.exe tool. I have been trying for hours to get a Sharepoint portal going and whilst for the error I had MS KB said enable tcp/ip, it didn't say how to do it for msde. Where did you find out about svrnetcn.exe and are there other useful tools I should know about? I'm ok with osql.

I have seen the error you are getting. It will happen if I'm not using Windows integrated authentication. If I try to connect with osql -U sa -S servername\instancename it doesn't work and gives a server does not exist or access denied. I have to use osql -E -S servername\instancename and it goes in fine.

Hope this helps - even if its a bit late!

Nath

|||

Nathan,

here is the linke which might be useful to you guys

http://www.codeproject.com/database/ConfigureMSDE.asp

Best regards,
Web

sql