Installing SQL Server 2005 Express Edition alongside SQL Server?

I want to install SQL Server 2005 Express Edition on my laptop alongside an
existing version of SQL Server, to learn SS 2005. Is there anything in
particular I need to watch out for, to make sure my SS 2005 installation doe
s
not interfere with the existing SS DBs? Thanks in advance for any guidance.Hi Robert
This should not be a problem, SQL Express and SQL Server 2000 can co-exist
as different instances. Running two instances will use more resources, so
make sure that your machine is going to have enough power to run both
instances and still do other work!
If you only occasionally need SQL 2005, then you may want to consider using
virtual machines.
John
"Robert" wrote:
[vbcol=seagreen]
> I want to install SQL Server 2005 Express Edition on my laptop alongside a
n
> existing version of SQL Server, to learn SS 2005. Is there anything in
> particular I need to watch out for, to make sure my SS 2005 installation d
oes
> not interfere with the existing SS DBs? Thanks in advance for any guidance.[/vbcol
]

Installing SQL Server 2005 Express Edition alongside SQL Server?

I want to install SQL Server 2005 Express Edition on my laptop alongside an
existing version of SQL Server, to learn SS 2005. Is there anything in
particular I need to watch out for, to make sure my SS 2005 installation does
not interfere with the existing SS DBs? Thanks in advance for any guidance.Hi Robert
This should not be a problem, SQL Express and SQL Server 2000 can co-exist
as different instances. Running two instances will use more resources, so
make sure that your machine is going to have enough power to run both
instances and still do other work!
If you only occasionally need SQL 2005, then you may want to consider using
virtual machines.
John
"Robert" wrote:
> I want to install SQL Server 2005 Express Edition on my laptop alongside an
> existing version of SQL Server, to learn SS 2005. Is there anything in
> particular I need to watch out for, to make sure my SS 2005 installation does
> not interfere with the existing SS DBs? Thanks in advance for any guidance.

installing sql server 2005 alongside analysis server 2000

analysis services 2000 work fine on my machine so i dont want to go near them ,but i do want to upgrade sql server 2000 to 2005. can i have sql server 2005 and analysis services 2000 work side by side on a server?Yes - you can do it. The AS2005 will have to be installed as a named instance, because you cannot have two default instances on the same machine and AS2000 didn't support multiinstancing.