I have a PC that was purchased secondhand from a TAFE (for eastern states ppl, that is a college that does trades quals and diploma's etc).
It has XP 2002 and SP3 is installed.
I use it obviously as a standalone home PC for the interweb, and stuff all else.
It keeps prompting me to download an update - Microsoft SQL Server 2005 Express Edition service pack 3.
It won't download, it won't install, it does stuff all. But it keeps prompting me. I guess is is a remnant of having been used on a network before?
( History: When I was using dialup, it always used to have a little icon dwn the bottom and when I hovered over it it said a network cable or ethernet cable was unplugged. Thus I thought it was at some stage networked. Makes sense.
Now I am using wireless broadband and the modem is plugged into the ethernet port doohicky I haven't seen that.)
So do I need the update? I doubt it.
If not how do I make the bloody prompt go away?
If I don't download it, and don't get rid of the prompt, will it not prompt me for any other updates that I do need, until this one is downloaded? I don't wanna miss anything important....
If you go into control panel
and go to Automatic Updates
open that and click
turn off automatic updates...
then once a week or so you go
to the same place control panel
Automatic updates and go to the line that says install updates from the web
it will take you to the Microsoft web site and you will see all the updates it has for you
untick the ones you don't want and see if it will update...
Sometimes this can go astray because some of the updates are inter woven with the ones you might say no to..
God I hope that makes sense ![]()
Hi,
we have TAFEs over here too!
Anyway this SQL server express edition is for some application on your computer that needs a little database server to run. Who knows what the application is.
Does the computer have a whole bunch of applications on it that would have been used for teaching? If so, probably the best thing to do would be to wipe the computer and load Windows on again. The only proviso to this is you have all the installation files and codes for applications you need plus you back up your data.
If you don't want to do but are sick of the update not working then you can do something like right clicking on the update icon, then manually installing the icon the going to the update list and then deselecting the update that won't install. It will warn you about not installing it. It will then go on the ignore list. I am on a mac right now so can't check it exactly.
SQL Server Express Edition is the free play edition you install for learning about the product. It uses less memory and disk than the full product. I doubt it is serving any useful purpose.
I would just deinstall it. You can download it again for free from the Microsoft web site if you want it back.
What I would really do is reformat the hard drive and reinstall the whole operating system from scratch. It doesn't take too long and you get a nice clean computer. You need the original disks for Windows and any software you use. Most software can be downloaded free off the net.
Jeez these topics ramble off course ![]()
Based on the original question, No! you dont need it.
in fact, you dont need it at all for what your using the laptop for.
Go into Control Panel
Remove Programs
(find SQL Server Personal Edition)
Uninstall
Hi Mark this problem is common but rather complicated to fix if your not really IT savvy.
SQL is a database hosting program. If none of your programs that you know of use a database, then just uninstall all of SQL Express from your add/remove programs icon in your control panel. If your not sure, perhaps tell us what progams you use on that PC and I can tell you if they use SQL.
The exact problem is (techno jargon warning) due to some of the sql scripts not having a complex password set, and not meeting the PC's password policy. The only way around it is to manually edit the .sql scripts and change the default password of "Yukon90_" to something more complex like "Yukon90_Password123"
There is a technet article on the MS knowledge base on this, and I have had to do it on all our SQL servers at work each time there is a new service pack for SQL 2005 (currently up to service pack 3). If you know anyone who is comfortable with editing files etc I can PM you the technet link and the steps on fixing the problem so the service pack successfully installs.
Mark,
This is a trojan horse being implemented by the Illuminati working within Microsoft as a way of gaining mind control. You can try to avoid it but...
Oh, sorry. Wrong thread! ![]()
In all seriousness, I'd uninstall the sucker and reclaim some disk space. Otherwise just follow GD's instructions should do the trick.
so much for buying a clean coputer with everything removed and Windows reinstalled huh
Thanks fellas ![]()
(and I learned something else - I thought TAFE was WA only and they'd be called something else on the totherside. There you go.)