How and what to install

Hi,

My hosting cie sugested I upgrade from Access to SQL wich I did.

I downloaded the fullest version (trial) of SQL I could find, not knowing what I realy needed.

The Trial has now expired and when I try to install the "Microsoft SQL Server 2005 Express Edition with Advanced Services " it sais that I need to uninstall some stuff (the error message is trunckated).

My use for this is to connect to and manage my live database. And to have a local copy of this database on my devellopement and testing machine that I can play around with.

Since i've install this "big version", I find that i'm only using the "sql management studio".

But when I go "add or remove prgms", it says I use everything "Frequently"!
So I do not want to uninstall something that I realy am using "frequently"...

Here is what I have in that list:

SQL server 2005
SQL server 2005 backward compatibitity
SQL server 2005 books online
SQL server Native client
SQL server setup support files
SQL server VSS writer
Visual Studio 2005 premier partner edition -ENU

This takes up 1121.62 MB !

I do not see in this list the sql management studio...?

What do I need to uninstall to be able to install "Microsoft SQL Server 2005 Express Edition with Advanced Services "?

What else should I uninstall because I just would not need ?

When I do uninstall whatever I need to uninstall, and install this express version, will it remember my conections? Find my local database? Basicly, will it screw up anything?!?

Thank you for your help!

Dominique

You can install express as a named instance, which would mean you don't need to install the other version. However, if the other version has expired, then you should uninstall all of it, it's all supporting SQL Server, and you say that doesn't work anymore anyhow.