Question:

How can I upgrade from MS Standard Srever 2005 to Ms Server 2008 Express without losing my settings?

Solution:

I would say there’s no clear way. But you have to keep in mind that SQL express edition has some limitations, not all the features available in SQL standard edition are available. I would start by reviewing this link, so you can make sure that all the features you’re currently using are supported in the express edition:

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

Secondly, you should definitively check this link which explains the considerations to upgrade to SQL 2008.

http://msdn.microsoft.com/en-us/library/ms144267.aspx

Also, although this other link talks about the upgrade from express to standard, I think it could also help you understand what you need to take into consideration while upgrading:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67639