Community
Wiki Posts
Search

SQL Server 2005

Thread Tools
 
Search this Thread
 
Old Dec 26, 2008 | 4:12 pm
  #1  
Original Poster
All eyes on you!
20 Years on Site
 
Join Date: Apr 2006
Location: New York City/NY22
Programs: AA Platinum 2.3MM (Lifetime PLT)
Posts: 5,291
SQL Server 2005

I somehow wound up with this program on a new laptop using XP SP3. (No, I am not using Business Contact Manager.)

Can I safely uninstall it?

Any idea what it does?

Yes, I did go to microsoft.com but the home page for this product seems to require a masters degree.
Landing Gear is offline  
Old Dec 26, 2008 | 4:14 pm
  #2  
FlyerTalk Evangelist
Conversation Starter
All eyes on you!
20 Years on Site
 
Join Date: Nov 2002
Location: ORD
Posts: 14,771
SQL Server is a database server.

Some programs will install a light version of SQL Server to store their data. Be sure that none of your programs needs it.

(SQL = Structured Query Language)
gfunkdave is offline  
Old Dec 26, 2008 | 4:17 pm
  #3  
Original Poster
All eyes on you!
20 Years on Site
 
Join Date: Apr 2006
Location: New York City/NY22
Programs: AA Platinum 2.3MM (Lifetime PLT)
Posts: 5,291
Originally Posted by gfunkdave
SQL Server is a database server.

Some programs will install a light version of SQL Server to store their data. Be sure that none of your programs needs it.

(SQL = Structured Query Language)
I have not yet installed any part of Office 2007. (I have been uninstalling craplets like BCM.)

Would you give me some examples of programs that use SQL Server? I am assuming that IE7 is not one of them.

Thank you for your help.
Landing Gear is offline  
Old Dec 26, 2008 | 4:25 pm
  #4  
 
Join Date: Feb 2002
Posts: 48
Some industrial HMI software packages like Wonderware Intouch use SQL Server, and will include it with their software.
erichris is offline  
Old Dec 27, 2008 | 9:39 am
  #5  
A FlyerTalk Posting Legend
10 Countries Visited20 Countries Visited30 Countries Visited20 Years on Site
 
Join Date: Apr 2001
Location: PSM
Posts: 69,232
There are tons of programs out there that use it. Anything that collects data, monitors a system or even a backup application could be using it. Microsoft gives it away for free to developers to use in an embedded mode, which is what you're seeing, and free makes it somewhat likable.

Before uninstalling it - which will almost certainly break something on your computer - try going into the Services MMC (Start | Run | Services.msc) and stopping the service (MSSQLSERVER). If you're lucky it might say MSSQLSERVER$SomethingElse and the "SomethingElse" part will be a hint to the program that is using it. By stopping the service you are essentially breaking the system the same way as you would be if you uninstall it, but with the ability to fix the system by simply rebooting your machine and letting SQL start up normally.

s.
sbm12 is offline  
Old Dec 27, 2008 | 10:24 am
  #6  
Original Poster
All eyes on you!
20 Years on Site
 
Join Date: Apr 2006
Location: New York City/NY22
Programs: AA Platinum 2.3MM (Lifetime PLT)
Posts: 5,291
Originally Posted by sbm12
There are tons of programs out there that use it. Anything that collects data, monitors a system or even a backup application could be using it. Microsoft gives it away for free to developers to use in an embedded mode, which is what you're seeing, and free makes it somewhat likable.

Before uninstalling it - which will almost certainly break something on your computer - try going into the Services MMC (Start | Run | Services.msc) and stopping the service (MSSQLSERVER). If you're lucky it might say MSSQLSERVER$SomethingElse and the "SomethingElse" part will be a hint to the program that is using it. By stopping the service you are essentially breaking the system the same way as you would be if you uninstall it, but with the ability to fix the system by simply rebooting your machine and letting SQL start up normally.

s.
Is that the same thing as going to Run>MSCONFIG and then the Services tab?

If so, I already tried that and I can report to you what happened.

In the meantime, would you agree with my guess that SQL wound up on my computer because Business Contact Manager (who uses this?) was pre-installed?
Landing Gear is offline  
Old Dec 27, 2008 | 10:50 am
  #7  
10 Countries Visited
20 Countries Visited
30 Countries Visited
20 Years on Site
 
Join Date: Feb 2003
Location: Cincinnati, OH
Programs: NW-PE, Blue Star SeaSmiles
Posts: 6,789
Originally Posted by Landing Gear
Is that the same thing as going to Run>MSCONFIG and then the Services tab?
Corrected, look at next post.

Originally Posted by Landing Gear
In the meantime, would you agree with my guess that SQL wound up on my computer because Business Contact Manager (who uses this?) was pre-installed?
If this is a brand new laptop like a Thinkpad, then yes BCM is the likely source. As noted SQL can be installed by other apps usually a financial\salesforce package.

So if this is new laptop sometimes it's just easier to run your recovery software and restore it to "Factory Default/etc..etc". Usually the main image doesn't have all the "added" ware or an option to restore with selecting apps.

Last edited by Blank Sheet; Dec 27, 2008 at 4:36 pm
Blank Sheet is offline  
Old Dec 27, 2008 | 11:27 am
  #8  
A FlyerTalk Posting Legend
10 Countries Visited20 Countries Visited30 Countries Visited20 Years on Site
 
Join Date: Apr 2001
Location: PSM
Posts: 69,232
Originally Posted by Landing Gear
Is that the same thing as going to Run>MSCONFIG and then the Services tab?
Sortof.
That interface will tell you what is running but won't allow you to stop the service. It will allow you to disable the service, but that doesn't take effect until you reboot.

Originally Posted by Landing Gear
In the meantime, would you agree with my guess that SQL wound up on my computer because Business Contact Manager (who uses this?) was pre-installed?

BCM does install the SQL engine as part of its install, so that it most likely the source of that SQL instance on your computer.
sbm12 is offline  
Old Dec 27, 2008 | 10:04 pm
  #9  
Original Poster
All eyes on you!
20 Years on Site
 
Join Date: Apr 2006
Location: New York City/NY22
Programs: AA Platinum 2.3MM (Lifetime PLT)
Posts: 5,291
SQL Server is uninstalled with (apparently and hopefully) no ill effects.
Landing Gear is offline  
Old Dec 27, 2008 | 10:13 pm
  #10  
 
Join Date: Sep 2008
Location: Cypress, TX
Programs: CO Plat, Priority Club Plat
Posts: 641
Originally Posted by Landing Gear
SQL Server is uninstalled with (apparently and hopefully) no ill effects.
It is a short trip to Microsoft.com if you end up needing it again...
speedster1978 is offline  
Old Dec 28, 2008 | 7:02 am
  #11  
A FlyerTalk Posting Legend
10 Countries Visited20 Countries Visited30 Countries Visited20 Years on Site
 
Join Date: Apr 2001
Location: PSM
Posts: 69,232
Originally Posted by speedster1978
It is a short trip to Microsoft.com if you end up needing it again...
It isn't quite that simple.

The SQL instance that is installed as part of BCM has things like the database definition and content loaded in it. It would require a repair of the program from the add/remove programs menu at a minimum, and BCM might be more complicated.
sbm12 is offline  
Old Dec 28, 2008 | 8:30 am
  #12  
All eyes on you!
15 Years on Site
 
Join Date: Apr 2008
Location: Chicago
Posts: 582
Microsoft money may use it too. It's very likely sqlServer lite version. Not sure, but some versions of MS Access and Excel may share some programs with it.
mrcamp is offline  
Old Dec 28, 2008 | 8:38 am
  #13  
A FlyerTalk Posting Legend
10 Countries Visited20 Countries Visited30 Countries Visited20 Years on Site
 
Join Date: Apr 2001
Location: PSM
Posts: 69,232
Originally Posted by mrcamp
Microsoft money may use it too. It's very likely sqlServer lite version. Not sure, but some versions of MS Access and Excel may share some programs with it.
Neither Access nor Excel use SQL. Both can connect to a SQL database and query/display data from it, but neither will install the runtime version that the OP had running.
sbm12 is offline  
Old Dec 28, 2008 | 11:44 am
  #14  
Original Poster
All eyes on you!
20 Years on Site
 
Join Date: Apr 2006
Location: New York City/NY22
Programs: AA Platinum 2.3MM (Lifetime PLT)
Posts: 5,291
Originally Posted by sbm12
It isn't quite that simple.

The SQL instance that is installed as part of BCM has things like the database definition and content loaded in it. It would require a repair of the program from the add/remove programs menu at a minimum, and BCM might be more complicated.
That's okay. I don't know what BCM is or even anyone who uses it so I doubt that I'll be installing it, just the "regular" version of Outlook 2007.
Landing Gear is offline  


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.