SQL Server Database
If I make an SQL server database, 

1) Do I need to install SQL server on client's machine too to use it in vb.net or we can use it just without it, as Access database can be used in vb.net.

2) I created a database with one table.  In BindingSource's Datasource section, when I make new connectin with this database, what datasource should be selected
Microsoft SQL Server or Microsoft SQL server database file?

I tried the second one, chose the file but when tested connection, it failed.

Please advise.
Thanks
Furqan
SQL Server Database
===

If I make an SQL server database, 

1) Do I need to install SQL server on client's machine too to use it in vb.net or we can use it just without it, as Access database can be used in vb.net.

2) I created a database with one table.  In BindingSource's Datasource section, when I make new connectin with this database, what datasource should be selected
Microsoft SQL Server or Microsoft SQL server database file?

I tried the second one, chose the file but when tested connection, it failed.

Please advise.
Thanks
Furqan