deployment of vb.net application with MSSQL db

[ssfftt]

I built my application using VB.NET 2003, MSSQL database which is hosted locally. How can i build the deployment file? plz help in details, i am new

 

[ssfftt]

i built an msi file with the application inside. when i installed it in another pc which has vb.net2003, the framework and mssql enterprise installed, the program doesnt work, error: SQL server does not exisit

what should i do now?

1) should i install something else in target pc?

2) how can i make a copy of the mssql db on the target pc?

plz help