Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


nate

6461 posts

Uber Geek

Moderator
Trusted
Lifetime subscriber

#31110 5-Mar-2009 00:06
Send private message

I maintain a small intranet app hosted on a mate's computer.  Couple weeks back he had issues with the computer not booting up, so (without my knowledge) he ran it down to his local computer store and they reformatted and put all his programs back on.

The computer is running WinXP Professional, and has Service Pack 3 on it.  I've tried installing SQL Express 2005 many times but it keeps failing, and research is telling me that SP3 and SQL Express don't play together nice. This is also the only thing I can see that has changed since the reformat (it used to run SP2).

I've read Microsoft's guides on how to remove SP3 but none of them work, to me it seems the computer place reinstalled XP with SP3 disks.  SP3 doesn't appear in Add/Remove Programs and the uninstaller doesn't appear in the Windows folder.

Screenshot of the system, any ideas of how to remove SP3 would be great.


Create new topic
Affiliate link
 
 
 

Affiliate link: Find your next Lenovo laptop, desktop, workstation or tablet now.
Regs
4065 posts

Uber Geek

Trusted
Snowflake

  #199319 5-Mar-2009 00:24
Send private message

do you have to use sql 2005 version sql express?  or can you try sql 2008 version instead?  most sql 2k5 apps i work with seem fine on 2k8 so far

alternatively:
Some analysis done by the SQL team has shown that even though you get an error about certain MSXML files not being updated, this error does not actually interfere with the installation of SQL Express; you can continue on in the installation and SQL Express will ultimately install successfully. The main issue here is that most people tend to cancel when they see the error rather than continue on. The workaround here is to just continue on.

http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/0542d9f5-a92e-480d-9f03-94aa0867dc7f/




nate

6461 posts

Uber Geek

Moderator
Trusted
Lifetime subscriber

  #199322 5-Mar-2009 02:28
Send private message



Maybe my issue lies with something else on the system as it seems the service installs but it just won't start.

gehenna
7352 posts

Uber Geek

Moderator
Trusted
Lifetime subscriber

  #199340 5-Mar-2009 08:02
Send private message

As Regs suggests, have you tried SQL Express 2008?



RedJungle
Phil Gale
1108 posts

Uber Geek

Trusted
Red Jungle
Subscriber

  #199342 5-Mar-2009 08:06
Send private message

What does the event log say?




Red Jungle: we make fantastic software

RSS  Twitter  Facebook  Skype

vexxxboy
3830 posts

Uber Geek


  #199377 5-Mar-2009 10:53
Send private message

i have installed and unistalled SP3 2-3 times on my pc, it is easy to remove go to add or remove programs in the control panel make sure the update box is ticked and it should be there under windows service pack 3, it is on mine , click remove it takes a while




Common sense is not as common as you think.


Regs
4065 posts

Uber Geek

Trusted
Snowflake

  #199541 5-Mar-2009 23:28
Send private message

vexxxboy: i have installed and unistalled SP3 2-3 times on my pc, it is easy to remove go to add or remove programs in the control panel make sure the update box is ticked and it should be there under windows service pack 3, it is on mine , click remove it takes a while


that only works if you install service pack 3 manually.  if you build the PC with a Windows XP SP3 intgrated media kit you dont have that option




Regs
4065 posts

Uber Geek

Trusted
Snowflake

  #199543 5-Mar-2009 23:30
Send private message

nate:

Maybe my issue lies with something else on the system as it seems the service installs but it just won't start.


Try disabling any antivirus/antimalware and firewalls while you perform the install in case something is blocking it.  Also, there should be a setup log file that tells you what errors are being encountered






nate

6461 posts

Uber Geek

Moderator
Trusted
Lifetime subscriber

  #199593 6-Mar-2009 11:43
Send private message

Regs: that only works if you install service pack 3 manually.  if you build the PC with a Windows XP SP3 intgrated media kit you dont have that option


That's what I thought, I was pulling my hair out trying to find out where SP3 was hiding.  Is there anyway to remove it if you've installed it this way?

Regs: Try disabling any antivirus/antimalware and firewalls while you perform the install in case something is blocking it.  Also, there should be a setup log file that tells you what errors are being encountered


I've uninstalled NOD32 and removed anything else that I think could interfer.  I will have another crack at it tonight.

Regs
4065 posts

Uber Geek

Trusted
Snowflake

  #199647 6-Mar-2009 17:29
Send private message

nate:
Regs: that only works if you install service pack 3 manually.  if you build the PC with a Windows XP SP3 intgrated media kit you dont have that option


That's what I thought, I was pulling my hair out trying to find out where SP3 was hiding.  Is there anyway to remove it if you've installed it this way?


unfortunately, no.  if you still have problems i'd try either the silent install option, or try installing 2008 express instead.

today i installed a MS CRM client machine which installs a copy of sql express 2k5 as part of the install and it completed no problem on a winxp sp3 machine so the product definately works ok.  At a stretch you could  always d/l and install the CRM client and then just use the crm sql instance :)




moderntalking123
1 post

Wannabe Geek
Inactive user


  #199680 6-Mar-2009 21:47
Send private message

Regs:
nate:
Regs: that only works if you install service pack 3 manually.  if you build the PC with a Windows XP SP3 intgrated media kit you dont have that option


That's what I thought, I was pulling my hair out trying to find out where SP3 was hiding.  Is there anyway to remove it if you've installed it this way?


unfortunately, no.  if you still have problems i'd try either the silent install option, or try installing 2008 express instead.

today i installed a MS CRM client machine which installs a copy of sql express 2k5 as part of the install and it completed no problem on a winxp sp3 machine so the product definately works ok.  At a stretch you could  always d/l and install the CRM client and then just use the crm sql instance :)

 

This is exactly the same as my problem, i've been searching the whole web to find a solution about this, i am really in an urgent need of SQL server and i am unable to uninstall SP3 as it is built in.

please describe more about what i can do! i've heard 2008 express is also not working in this situation,(not tested)

would you please clarify what this CRM client machine is, and where i can download that or any other option for installing SQL server on XP SP3!

Thank you in advance...


Regs
4065 posts

Uber Geek

Trusted
Snowflake

  #199695 6-Mar-2009 23:03
Send private message

moderntalking123:

would you please clarify what this CRM client machine is, and where i can download that or any other option for installing SQL server on XP SP3!



CRM Client:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=60c4a6cc-59d7-416e-9f44-0ae8ff249768

Choose the "Advanced" or "Offline Access" install and it will download and install a sql express engine from the internet.  You must have the .Net 3.0 framework and Outlook 2003SP3 or Outlook 2007 installed already.  Once installed you can then uninstall the client but leave the sql express engine behind.


Have either of you guys tried downloading a new version of the SQL Express setup program?

http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

While the file name will be the same as one you downloaded a year ago, the actual setup program will have been updated.  Perhaps if you are using an older version then a new download will help.

Also, open the sql error log (if exists) and look for more detailed errors for why the sql is not starting.  log exists at:
C:\Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG

(n will be 1 if there is only one engine installed, but it could be anything)


Also check the following KB Article too:
Error message when you try to install SQL Server Express or SQL Server Express Edition or SQL Server Express Edition with Advanced Services: "The SQL Server service failed to start"
http://support.microsoft.com/kb/920114




nate

6461 posts

Uber Geek

Moderator
Trusted
Lifetime subscriber

#199787 7-Mar-2009 18:00
Send private message

FINALLY got SQL Express 2005 installed and working.

Here's what I did:
  • Removed NOD32 just in case it was interfering with the install
  • Download and installed Microsoft SQL Server 2005 Express Edition with Advanced Services
  • When I unchecked the hide advanced feature option, one option I did change was to start the service after install - the service installed, I changed a couple of settings, started SQL Express and now it works fine.
Thanks Regs for all your ideas.

Create new topic





News and reviews »

D-Link G415 4G Smart Router Review
Posted 27-Jun-2022 17:24


New Zealand Video Game Sales Reaches $540 Million
Posted 26-Jun-2022 14:49


Github Copilot Generally Available to All Developers
Posted 26-Jun-2022 14:37


Logitech G Introduces the New Astro A10 Headset
Posted 26-Jun-2022 14:20


Fitbit introduces Sleep Profiles
Posted 26-Jun-2022 14:11


Synology Introduces FlashStation FS3410
Posted 26-Jun-2022 14:04


Intel Arc A380 Graphics First Available in China
Posted 15-Jun-2022 17:08


JBL Introduces PartyBox Encore Essential Speaker
Posted 15-Jun-2022 17:05


New TVNZ+ streaming brand launches
Posted 13-Jun-2022 08:35


Chromecast With Google TV Review
Posted 10-Jun-2022 17:10


Xbox Gaming on Your Samsung Smart TV No Console Required
Posted 10-Jun-2022 00:01


Xbox Cloud Gaming Now Available in New Zealand
Posted 10-Jun-2022 00:01


HP Envy Inspire 7900e Review
Posted 9-Jun-2022 20:31


Philips Hue Starter Kit Review
Posted 4-Jun-2022 11:10


Sony Expands Its Wireless Speaker X-series Range
Posted 4-Jun-2022 10:25









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.