What's new
By:
USCHO Fan Forum

This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

  • The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.

Computer question 23451s

Ralph Baer

Ralph Baer

Let's Go 'Tute!
My Windows XP system keeps trying to install an update to the SQL Server. Apparently it died during the installation of the update and it keeps trying without success to install it. Can anyone recommend what to it?

I also ask what exactly is SQL Server and do I need it? Would it be simplest to just get rid of it?
 
Re: Computer question 23451s

Ralph Baer said:
My Windows XP system keeps trying to install an update to the SQL Server. Apparently it died during the installation of the update and it keeps trying without success to install it. Can anyone recommend what to it?

I also ask what exactly is SQL Server and do I need it? Would it be simplest to just get rid of it?
Click to expand...

It's probably part of another program. Uninstalling it without knowing what installed it would be unwise. If you can find what it was installed with I would uninstall it and then reinstall it.
 
Re: Computer question 23451s

If this is a machine that you use for work, SQL server may have been put on there as part of a standard drive image. In that case I would imagine it's OK to remove. Either way I've never heard of a software application installing SQL Server (assuming it's the MS one) locally on a machine. I would imagine the licensing costs would be astronomical.

I get these stupid types of errors with Outlook and I usually have success by going into the add/remove programs, double clicking Outlook, and rather than remove it, choose the "repair" option.
 
Re: Computer question 23451s

Zudnic said:
If this is a machine that you use for work, SQL server may have been put on there as part of a standard drive image. In that case I would imagine it's OK to remove. Either way I've never heard of a software application installing SQL Server (assuming it's the MS one) locally on a machine. I would imagine the licensing costs would be astronomical.

I get these stupid types of errors with Outlook and I usually have success by going into the add/remove programs, double clicking Outlook, and rather than remove it, choose the "repair" option.
Click to expand...

We have a couple of software suites at work that use it (bentley autoplant and some allen bradley tools). There are plenty of other ones out there as well. Also, IIRC, access uses SQL in some instances.
 
Re: Computer question 23451s

Zudnic said:
If this is a machine that you use for work, SQL server may have been put on there as part of a standard drive image. In that case I would imagine it's OK to remove. Either way I've never heard of a software application installing SQL Server (assuming it's the MS one) locally on a machine. I would imagine the licensing costs would be astronomical.

I get these stupid types of errors with Outlook and I usually have success by going into the add/remove programs, double clicking Outlook, and rather than remove it, choose the "repair" option.
Click to expand...

It's my home computer, and I don't run a server.
 
Re: Computer question 23451s

Go to Control Panel, Add/Remove programs, and there should be an option along the lines of "show windows updates". See if you can find the offending update in there and do something?
 
Re: Computer question 23451s

Zudnic said:
OK. Can you 'repair' it?
Click to expand...

I am not sure what you meant. I went to Add or Remove Programs. There are four programs dealing with the MS SQL Sever. I assume I should be looking for "Microsoft SQL Server 2005". The other three are "Microsoft SQL Server Native Client", "Microsoft SQL Server Setup Support Files (English)", and "Microsoft SQL Server VSS Writer". Double clicking doesn't seem to do anything. Two buttons read "Change" and "Remove".

BTW, this update is KB 955706.
 
Re: Computer question 23451s

Ralph Baer said:
I am not sure what you meant. I went to Add or Remove Programs. There are four programs dealing with the MS SQL Sever. I assume I should be looking for "Microsoft SQL Server 2005". The other three are "Microsoft SQL Server Native Client", "Microsoft SQL Server Setup Support Files (English)", and "Microsoft SQL Server VSS Writer". Double clicking doesn't seem to do anything. Two buttons read "Change" and "Remove".

BTW, this update is KB 955706.
Click to expand...

Yeah, "MS Sql Server Client" is probably the one you want. If you click to change it, it should give you the option to repair it (if the software is new enough).

Do you know what software you use on your PC that might use the database? Any professional software that might crunch a lot of data?
 
Re: Computer question 23451s

You don't have to run a server to have SQL Server installed and/or required as far as i know. We don't run a SQL server on our work computers either.

Open up the run dialog and type in "services.msc" without quotes. Go through the list and see if you can find anything with SQL in it. That might give some clues as to what is using it.
 
Re: Computer question 23451s

dxmnkd316 said:
You don't have to run a server to have SQL Server installed and/or required as far as i know. We don't run a SQL server on our work computers either.

Open up the run dialog and type in "services.msc" without quotes. Go through the list and see if you can find anything with SQL in it. That might give some clues as to what is using it.
Click to expand...

There are four
SQL Server (MSSMLBIZ) (Provides storage, processing and controlled access of data and rapid transaction processing.)
SQL Server Active Directory Helper (Enables integration with Active Directories.)
SQL Server Browser (Provides SQL Server connection information to client computers.)
SQL Server VSS Writer (Provides the interface to backup/restore Microsoft SQL server through the Windows VSS infrastructure.)

I guess that it is important.
 
Re: Computer question 23451s

Zudnic said:
Yeah, "MS Sql Server Client" is probably the one you want. If you click to change it, it should give you the option to repair it (if the software is new enough).

Do you know what software you use on your PC that might use the database? Any professional software that might crunch a lot of data?
Click to expand...

I do have an old copy of MATLAB. I haven't used it for a while since I only used it when I did work from my job at home. Now I have a work laptop that I use for that purpose.
 
Re: Computer question 23451s

Ralph Baer said:
I do have a copy of an old copy MATLAB. I haven't used it for a while since I only used it when I did work from my job at home. Now I have a work laptop that I use for that purpose.
Click to expand...

That could definitely be it.

Not sure the first in the list is for small business applications (MS Small Business could be an office suite IIRC)

The second in the list is for active directories which are usually part of a server structure. If you don't have a server that's probably not the case.

I'm not familiar with the last two.
 
Re: Computer question 23451s

dxmnkd316 said:
That could definitely be it.

Not sure the first in the list is for small business applications (MS Small Business could be an office suite IIRC)

The second in the list is for active directories which are usually part of a server structure. If you don't have a server that's probably not the case.

I'm not familiar with the last two.
Click to expand...

If that is the only purpose, would it disappear if I removed MATLAB? I could install a new version it if I want to.
 
Re: Computer question 23451s

Ralph Baer said:
If that is the only purpose, would it disappear if I removed MATLAB? I could install a new version it if I want to.
Click to expand...

If it was only for matlab, it would likely disappear when you installed it.

There is one way to check to see if they affect anything. you can try disabling the four SQL Svr entities by right clicking on them and hitting properties. You should see a dropdown window about 2/3 of the way down that says automatic or manual. Change that to disabled for all four and restart your computer. If you don't notice any problems with your programs over the next few days or so I'd say it's probably not affecting much and uninstall it. Once something pops up and says, oh wait, I needed SQL to work you can probably get by with reinstalling that program.
 
Re: Computer question 23451s

dxmnkd316 said:
If it was only for matlab, it would likely disappear when you installed it.

There is one way to check to see if they affect anything. you can try disabling the four SQL Svr entities by right clicking on them and hitting properties. You should see a dropdown window about 2/3 of the way down that says automatic or manual. Change that to disabled for all four and restart your computer. If you don't notice any problems with your programs over the next few days or so I'd say it's probably not affecting much and uninstall it. Once something pops up and says, oh wait, I needed SQL to work you can probably get by with reinstalling that program.
Click to expand...

That makes sense. (I assume that you meant "uninstalled" in the first sentence.)

I'll wait until I hear any other suggestions before trying them.
 
Re: Computer question 23451s

Ralph Baer said:
That makes sense. (I assume that you meant "uninstalled" in the first sentence.)

I'll wait until I hear any other suggestions before trying them.
Click to expand...

Haha, yeah.

Good call on waiting for other suggestions. the ones I put up are more of a last resort kind of thing.
 
You must log in or register to reply here.
Back
Top