Running applications without SQL Server database only client tools?

Question

How to run an application on a system without instaling SQL Server by inserting SQL Server's CD? i mean, i want to install my application using some installation wizards and the sql server also will installed automatically. anyone knows any idea? I heard abt installing only SQL Server client tools..
I am using MS SQL Server 7

Please help me

Answer 1

There is a SQL Server 2005 Express Edition redistributable installer from Microsoft that should suit your needs:



http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en



If you plan to redistribute the installer, Microsoft requires you to sign up for that (it's free):



http://www.microsoft.com/sql/editions/express/redistregister.mspx

Answer 2

You can wrap your installation wizard and sqlserver installation in a batch file and execute the batch file

Answer 3

sure you can install only client or connectivity tools, not overall engine