multiple sql server 2005 express?

is it possible to have sql server 2005 express in one computer?

Can you explain what you're asking, in a different way?

I'm not sure I understand your actual question - you have multiple in the subject line, but talk about 'one computer' in your text.

|||

test2003:

is it possible to have sql server 2005 express in one computer?

If you mean multiple instances the answer is yes but Express comes with 1gig restriction per instance so you will quickly run into performance probelms related to RDBMS(relational database management systems) hardware use issues. And the second instance must be a named instance because the first can be a Default or Named instance all others must be Named instance. Hope this helps.

|||

Sorry that my question was not clear. Yes I meant multiple instances.

I am new to database, Can you give me some links about setting up sql server and the restriction/performance problem for express version?

Thanks.

|||

All you need is covered in the links below but read the link explaining named instances carefully because Express is not included in the instance aware components because Microsoft created a setup when using Express you cannot use both Advanced the Algebra relational engine and the Tool kit the Calculus end together. To use both you need the no deployment Developer edition. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms143388.aspx

http://msdn2.microsoft.com/en-us/library/ms143531.aspx