MSDE not starting properly

I have MSDE come up when my system boots, but the server name does not appear
in the 1st dropdown box. So, I have to type the server name in and click the
start button in the MSDE window to get it to come up. I just want it to
start at boot-up, and be there without having to type the server name in
every time. Help.
You have the following options:
1. Add the following statement to Win.ini
Run = "SCM -Action 1 -Service mssqlserver -Silent"
2. Run the following in DOS:
REM modify SCM
SCM -Action 7 -Service mssqlserver -SvcStartType 2 -Silent
REM start sql service now
SCM -Action 1 -Service mssqlserver -Silent
"Tom Nowak" <TomNowak@.discussions.microsoft.com> wrote in message
news:BB6F9956-3BD9-4B00-A332-A5D79EC1ABAB@.microsoft.com...
> I have MSDE come up when my system boots, but the server name does not
appear
> in the 1st dropdown box. So, I have to type the server name in and click
the
> start button in the MSDE window to get it to come up. I just want it to
> start at boot-up, and be there without having to type the server name in
> every time. Help.

MSDE Installation problem on NT 4.0 Error 32

Hi,
I am trying to install MSDE on an NT 4.0 sp6a box. I have applied the
Q258437i hotfix. I have never come accross this error before on other
MSDE installations and I can't find a similar case in the news groups.
I am stumped..
There is nothing overly special about this box except that it is
running the NT SMTP Service. I made sure that the "Server" service is
running. What else could it be? The user that I am logged on as has
local Administrative priviledges.
It starts installing and then about 1-2 minutes into it, the progress
bar starts going backwards and it terminates.
It gives error 32 (as you can see in the log portion below) which is a
sharing violation (I haven't seen anyone mention this error code when
installing MSDE). Any help on this would be much appreciated!
Richard
PS. See log portion below.
TempFolder is C:\TEMP\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\TEMP\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 32
Action ended 10:54:40: InstallFinalize. Return value 3.
MSI (s) (D4:6E): User policy value 'DisableRollback' is 0
MSI (s) (D4:6E): Machine policy value 'DisableRollback' is 0
MSI (s) (D4:6E): Executing op:
Header(Signature=1397708873,Version=200,Timestamp= 815158970,LangId=1033,Platform=0,ScriptType=2,Scri ptMajorVersion=21,ScriptMinorVersion=4,ScriptAttri butes=1)
MSI (s) (D4:6E): Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (D4:6E): Executing op: DialogInfo(Type=1,Argument=Microsoft
SQL Server Desktop Engine)
Hi Richard,
While I was going through your problem I came across the KB Article
#315083, that describes the exact problem that you are facing. The link for
that KB article is
http://support.microsoft.com/default...&Product=sql2k
|||Thanks,
I'll try that..
Richard
"Ashish Ruparel [MSFT]" <v-ashrup@.online.microsoft.com> wrote in message
news:tCEctcyKEHA.3048@.cpmsftngxa10.phx.gbl...
> Hi Richard,
> While I was going through your problem I came across the KB Article
> #315083, that describes the exact problem that you are facing. The link
for
> that KB article is
>
http://support.microsoft.com/default...&Product=sql2k
|||Thanks! It worked..
Richard
"Ashish Ruparel [MSFT]" <v-ashrup@.online.microsoft.com> wrote in message
news:tCEctcyKEHA.3048@.cpmsftngxa10.phx.gbl...
> Hi Richard,
> While I was going through your problem I came across the KB Article
> #315083, that describes the exact problem that you are facing. The link
for
> that KB article is
>
http://support.microsoft.com/default...&Product=sql2k
|||Richard,
I was having a similar kind of a problem with MSDE 2000 on Windows XP machine. I have created an installer for my application with MSDE merge modules. Could you tell me as to what exactly you did from the knowledge base article that had fixed you up.
Thanks,
Alagiri
"Richard Nasr" wrote:

> Thanks! It worked..
> Richard
>
> "Ashish Ruparel [MSFT]" <v-ashrup@.online.microsoft.com> wrote in message
> news:tCEctcyKEHA.3048@.cpmsftngxa10.phx.gbl...
> for
> http://support.microsoft.com/default...&Product=sql2k
>
>

MSDE install problems

hi ppl,
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.

Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.

After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.

the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt

i have attached log file.
Please help a stoopid newbie :(Please ignore this previous message, I seemed to have bypassed this old error, this old error only appeared when I don't specify an instance name.

When i do now specify one, then I get this error:

Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 267
Action ended 0:18:23: InstallFinalize. Return value 3.

I tried numerous things but the only stuff that works is when I make a C:\Program Files\Microsoft SQL Server\MSSQL\Binn directory and copy sqlctr.ini and sqlctr.h into it (which i poached from an install that didnt rollback).

But this results in the following error:

Starting custom action InstallSQLAgentSecurity
LoadLibrary failed for C:\Program Files\Microsoft SQL Server\Mssql\BinnMSSQL$DONALD007\Binn\SEMNT.DLL. GetLastError() returned: 126
Action ended 0:05:57: InstallFinalize. Return value 3.

Does anyone know how to solve this?
btw here are parameters

REINSTALL=All
REINSTALLMODE=omus
COLLATION=Latin1_General_CI_AS
TARGETDIR=C:\Program Files\Microsoft SQL Server\Mssql\Binn
DATADIR=C:\Program Files\Microsoft SQL Server\Mssql\Data
SAPWD=1111
INSTANCENAME=Donald007

This is a clean install of msde using sql service pack 3 on win xp pro.

I have attached a copy of my log file that is generated when this "LoadLibrary failed.." error occurs.

I also noticed that in the services i can still see a SQLSERVERAGENT even though this service is not started and the file it refers to has been deleted.

Originally posted by deekay2003
hi ppl,
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.

Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.

After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.

the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt

i have attached log file.
Please help a stoopid newbie :(

MSDE Install Failure - Unable to Configure Server

I have seen a few posts loosely related to this issue - but check this one out.

On a windows xp home box, I installed MSDE without an issue. I then upgraded said pc to MDAC 2.7 SP1 (XP) and got the above mentioned "Unable to Configure Server" error.

We have 3 users who are also getting this error when attempting to install the MSDE from our media, so I really need some help on this one!

I'm reasonably sure it is mdac, but I cannot determine the specifics yet. We also have this same issue on one lonely 98 box here in our office.

Does anyone have any experience with this typ of MDAC issue? Anything you could share would be great.Make sure to stop any anti virus application running.