To deploy a desktop application(C# 2008,SQL SERVER 2005)

Question

I want to deploy a desktop application.Help me out to create a set up file such that there wont be any SQL SERVER database error.The Client machine wont be having visual studio2008 and SQL SERVER 2005 installed.I want after the installation of software(my application)there should not be any error or exception ,it should run successfully without any error.This is my first .net project.help me to solve my problem.Thank you.