http://support.microsoft.com/default.aspx?scid=kb;en-us;816499&Product=sql
Also, there should be a setup log created that might have more information.
After a short period of time where the status bar shows about 9 seconds left the status bar runs backwards down to zero and installation stops.
No error message, no crashes, just packs up its tent and goes away.
I have tried running setup from a batch file with the same results.
I have turned off my antivirus program as well as all other programs.
Need Input! - Thanks - T.C.nothing in the System error log?|||Still have the probl if you modify msde setup.ini to install?
e.g.
----------------------------
TARGETDIR="C:\Program Files\Microsoft SQL Server\Mssql$MyInstance\Binn"
DATADIR="C:\Program Files\Microsoft SQL Server\Mssql$MyInstance\Data"
INSTANCENAME="MyInstance"
SECURITYMODE="SQL"
SAPWD="mysapassword"
----------------------------|||Thanks for the tries but...
Adjusting the ini gave me the same negative results.
System Event viewer just tracked that Installer was used.
Application Event viewer returned error message:
"Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."
and when i follow link to web site i am told Sorry but no help here.|||Hi, I am having the same problem. I have done a bit of research on the net and the MS knowledge base and come up with the following kb article...
http://support.microsoft.com/default.aspx?scid=kb;[LN];816499|||And seeHOW TO: Manually Remove a Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Instance|||thank you one and all for try but alas to no avail. I have not a previous version of SQL so i am a bit stuck.|||You can try to open RPC services, and Server Services.
They are in control pad.|||I have found what it was, I also was having the problem. You have to start the service Server started, even if it is Manual, you will still need to start it.
In the instalation docs for MSDE SP3 under Install Log Verbose at the bottom to look for "Value 3", and withing 10 lines of that you find the item that failed. I found "InstallSQLAgentSecurity failed..." I then proceeded to do a search for that on Technet and low and behold there it was. in the very first sentance of "829386 - You Cannot Install MSDE 2000 if the Server Service Is Not Running" it says you need the Server service running.|||I had the same problem, with my Windows XP home. I worked on it for 4 hours, the problem was that you have to have a network set-up on your computer. so I entered into setting up a home network wizard, windows installed all the components and then I installed the MSDE. Worked like a charm. So the way to solve this is to start the network Wizard! and then install MSDE.
Thanks guys.sql
I have this problem with MSDE Installation:
I install MSDE then from prompt c:\sql...\msde\
I type: setup INSTANCENAME=pippo SECURITYMODE=SQL SAPWD=pp
then I restart but I see on the toolbar the icon of the SQL server but Ihaven't any Server or Service, in the Icon there is not the green signal nether the red signal, the little circle is white.
what I need to do?
thanks,
lucaHi Luca,
What version of Windows is this?
Don|||Windows XP Pro.
Now I unistall MSDE and Re-install it and now is ok.
Is the 1st time I use MSDE and I'd like t know wath's the use of SAPWD ?
and I need to indicate in the SETUP SAPWD=... etc. also uid= ?
and uid wath's
thanks,
luca|||I'm having the same problem. I'm using Windows 2000 Professional.
I do have the SQL Server 2000 CLIENT Tools installed on my computer, but as far as I know, those are just for connecting to SQL db's, it's not the actual engine; that's why I want MSDE on my machine. Would those client tools be conflicting with my MSDE installation?|||I've tried uninstalling it and then reinstalling it...
When I double click the little server icon in the tray and I go to hit the green play button, there are no services in the dropdown menu to start.
Anyone know how to solve this?|||Hi Luca,
The SAPWD switch lets you set the sa (system administrator, SQL Server's superuser) password which you shouldALWAYS do because of worms that have taken advantage of it.
uid is user id, the user you can use to log into MSDE.
Don|||Hi Matt,
I'm not sure I understand what you're saying about having the SQL Server client tools installed. You can use those to connect to and manage the engine of any SQL Server or MSDE installation on the local machine or across the network that you have permissions to access.
Do you mean that those don't include the database engine? If so, yes, that's right. So you would indeed want to install MSDE in order to use databases locally. And no, the client tools won't conflict with your MSDE installation at all.
I don't know why you aren't getting any services listed. If you go into Computer Management from the Control Panel do you have MSSQLSERVER listed under Services and Applications | Services? If so, can you start it from there?
This could be because you already had the client tools installed when you installed MSDE. So you probably have to add a registration to the local MSDE. Go into Enterprise Manager, expand Microsoft SQL Servers in the treeview, right-click on SQL SErver Group and select New SQL SErver Registration from the popup menu. In the available servers select either LOCAL (it might say LOCALHOST) or the machine name. If it isn't listed, type it in. Then complete the other steps in the wizard.
Does that solve it?
Don|||Don:
Since my last post I UNinstalled MSDE. You did clear up a lot for me though. I was unsure if the Client Tools were somehow conflicting, but now I know they won't.
I'll REinstall MSDE and register it in Enterprise Manager and see what happens.
Thanks for your help!
