We help IT Professionals succeed at work.
Get Started

SQL Server Instances

darrennelson asked
Last Modified: 2012-06-27

I have been testing out SQL Server 2005 and MOSS 2007.  I initially installed MOSS 2007, then installed SQL Server 2005 for the tools, but inadvertantly installed the db server, as well.  I now have the following instances:

ver 9.0.2047

ver 9.0.1399

ver 9.0.1399

I believe MOSS installs an embedded database, which is why it probably has a different verison number.  In add/remove, I have the following:

MS SQL Server 2005
MS SQL Server 2005 Analysis Services ADOMD.NET
MS SQL Server 2005 backward Compatibility
MS SQL Server Native Client
MS SQL Server Setup Support Files
MS SQL Server VSS Writer
MS Office SharePoint Server 2007

I am trying to figure out what's what.

1.  Can/How do I get rid of SPS02/SPS02 and SPS02 instances?

2.  What's the difference between the MOSS embedded db and a regular sql db?
Watch Question
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE