SQL Server Configuration

Is it possible to copy an existing instance of SQL Server 2008 R2. I have a databse that is set up w开发者_JAVA百科ith the security etc already sorted. I want to deploy an installation of SQL Server 2008 R2 with the application I have developed but the user should have no interaction at all.

There is an embedded version of sql server 2008 that is free to distribute: http://www.microsoft.com/sqlserver/2008/en/us/compact.aspx

However, it doesn't support all the nice goodness that 2008 does so it depends on how complex your sql code is.....