[2005] Deployment of Application in vb.net

Hello All,
Can someone tell me that suppose I create an Application in vb.net with SQL Database , do i need to install sql server on client end run the application.

Thanks

The client must have access to an SQL Server in order to access an SQL Server database. If there isn't already an instance available on the network then you will have to install it on the local machine. Note that VS 2005 will install SQL Server Express automatically along with the .NET Framework if you create a ClickOmce or MSI installer for your app and select it as a prerequisite.

Thanks for your prompt reply
So i dont need to install SQL Server on client end. the installer does all that. and what if I have to share database over the netowrk in LAN, say there are 10 users does evey node must have sql server installed

As I said in my previous post, the user must have access to an SQL Server instance. If there is already an instance installed and accessible on the network then it's not necessary to install another. That means that if you're installing your app on a 10 node network then you only need to install SQL Server on one of those nodes, assuming that the others will all access the database on that server.

Hello

When I use the Build> Publish button (in vb2005) for creating the "setup" file, it works OK, but when I run the setup file, it doesn't ask me where to install my app. or whether or not I need a desktop shortcut for it. It just installs it in an unknows folder (I don't know where it is). I read in vb help that I should use File> NewProject> Deployment Project for making more advanced setup files, but when I click on "New Project", I only have these options:

http://imgplace.com/directory/dir205...20190_2740.JPG

Now I want to know how I can create more advanced setup files for my app? Should I install a different version of vb or I have all my needs on this version and just don't know where they are?

Thank you

javad2000, that post is not related to the topic of this thread. Please delete it and start a new thread of your own.

Sorry
Didn't mean to interrupt the topic. Just thought my prob. is also a "deployment" prob.