Thanks Chris.
Getting the data / database from SQL Server Express to SQL Server 2005 does seem to be the rub.
I have downloaded a tool called "SQL Server Management Studio Express CTP" which may enable me to backup the data from the express and restore it to 2005. In reality I don't really need to transfer data as I am happy to start from scratch. I just need to know how to get the app working with SQL 2005 in the first place rather than just defaulting to Express.
Various forums and blogs seem to indicate that I need to run aspnet_regsql.exe
aspnet_regsql.exe to prepare my SQL 2005 Database.
(this blog generally seems to detail the whole process I need to follow, but I'm not quite understanding it yet)
I understand what you say about me having a login to part of a shared SQL Server 2005 database, but I'm wondering how I can have more than one database / app running on my bit of it. Do I need to generate different instances?
Cheers,
Will