VB - SQL SERVER integrated setup

Hi,

Is it possible to integrate sql server 2000 with vb setup.So that
no need to manually run sql server 2000.What are the required
files to add in vb setup to install sql server.

Any suggestion / link ref. regard is highly appreciated.

....

So you want to instll SQL Server and VB at the same time??

The question would be why!!!

You should have your app and the database on differant machines really are you on about the SQL client??

SQL Server has to be installed via the Microsoft CDS (or copies of them) as there is a lot of security on it.

What you could do is a simple script that prompts for the SQL Server CD and runs Setup.exe and then prompts for your install but I think SQL Server needs a reboot.

I need to include sql server in vb setup for 2 reasons -

1).for demo which will all works without user prompt
2).some time application to be loaded in same computer where
database reside.

My need is to install sql server by novice without any expert help.

You can't legally distribute SQL Server with your app. You could script the database and create your DB on an already installed server but you can't just send out a copy of SQL Server with your app.