?
Solved

MSDE install problems: sqlMangr.exe - Application error

Posted on 2006-05-13
4
Medium Priority
?
1,112 Views
Last Modified: 2008-01-09
Hello,

I downloaded and ran the SQL2KDeskSP3a.exe file on windows 2000 professional.

I tried to setup an msde intance:
'Setup SAPWD=(Some password) INSTANCENAME="aaa" '

After i had restarted my pc after the setup, I tried to run the 'Service Manager', but I got a 'sqlMangr.exe - Application error':

          The instruction at "0x1fa00475" referenced memory at
          "0x00af00b2". The memory could not be "read". Click on OK to terminate the program
          Click on CANCEL to debug the program  


I deleted and re-installed the engine but no progress. How can I solve this problem, Is there something in the registry that should be modified in order to make it work.
0
Comment
Question by:ANISBH
3 Comments
 
LVL 3

Expert Comment

by:lokeshgm7
ID: 16732156
This happens if the path to the sqlctr80.dll in the following registry key is greater than 50 characters.

HKLM\System\CurrentControlSet\Services\MSSQLServer\Performance\Library


Since the problem is in advapi32.dll which is an NT dll, the resolution here is to use shorter path for the installation.

What is the installation path you are providing while installing MSDE?
Can you try to repro this issue on another machine with the same OS build and the same path?

Regards,

Lokesh

0
 

Author Comment

by:ANISBH
ID: 16748975
the value i get from HKLM\System\CurrentControlSet\Services\MSSQLServer\Performance\Library:

C:\PROGRA~1\MICROS~4\MSSQL\BINN\SQLCTR80.DLL

However I tried installing the MSDE on another machine having the same OS but with the latest SP's, I got no errors and everything worked fine. I used the same path to save the MSDE. ==> I think the problem was from the microsoft windows 2000 professional: it should have the latest SP.

Anyway,
thanks for your help.

0
 

Accepted Solution

by:
GranMod earned 0 total points
ID: 16932354
PAQed with points refunded (125)

GranMod
Community Support Moderator
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question