Can you run SQL Server 2005 Express on same box as SQL Server 2000? 1

[cyberspace]

having some bother installing some software that runs on SQL.

The instuctions say that it will set up everything for you if you are installing on the 2005 Express edition, which would be nice...

my concern is running the two on the same box - will this cause issues?

'When all else fails.......read the manual'

 

[Jamfool]

there shouldnt be any issues. sql 2000 will probably be installed in the default instance and sql2005 express usually installs as an instance called sqlexpress.

e.g.

sql 2000 accessed as <ServerName>
sql 2005 expressaccessed as <ServerName\sqlexpress>

 

[cyberspace]

Thanks for that.

It's just several of our major applications run on the full blown SQL server (Anti virus, backup, and office system) and I wouldnt want to cause any trouble there!

The issue is, that the software i am trying to install (Webroot SpySweeper Enterprise), says that it can go on 2000 server. I have set up the database as instructed - then it says when adding new user select "Windows and SQL Server Authentication" (ie, Mixed mode) - however, there is no such option, it's either Windows, or SQL - so, as a result, i get an error message from the installer if i try to set up the user with just one of these (at least i assume tahts why its causing problems - as i installed SQL Express 2005 on my pc as a test and spysweeper installed just fine)

Any thoughts?

the exact wording is:

“Configure your SQL server for SQL Server and Windows Authentication and use an SQL user account instead of a windows account to access a SQL Database with webroot enterprise.”

thanks

'When all else fails.......read the manual'

 

[Jamfool]

if the application will run on sql2000 i would advise against installing sql2005 express as this will lead to further admin overhead, reduced resources for each instances and a major headache if things go pear shaped. (+ expess is a cut down version of ms sql with several limitations)

if you run

exec [master].[dbo].xp_loginconfig

the top line will tell you what login mode you are currently using.

check to see what this is.

 

[cyberspace]

Thanks Jamfool

I ran that using the Query Analyzer - it reports that current login mode is mixed.

So the problem must lie elsewhere!

Their support is fairly slow aswell...

I will just wait to hear from them, thanks for your help.

'When all else fails.......read the manual'