SQL server runs as a service, so that assumes an install and a lot more.
for a portable type of application, you'd have to use a portable database; SQL Server Compact,or Access or SQLite or XML, for example.
Then you'd have change your data access layer to use that for the data source; whether it supports all the functionality you are assuming is in place or not is the big question;
I've use a pure XML solution before, which just used the built in ability of a System.Data.DataSet to load and save to an xml document.,
so procedures/functions/views would not be possible, for example. you could emulate their functionality in the app.
it really depends on the details, but it sounds like, without any other changes, you must add your database to an existing SQL instance, or install a new SQL instance with your app if it doesn't exist.
Lowell