Shall I install SQL on each machine + VB.Net Application

[mody82]

Hi for all

I have developed an Application with the help of VS 2008 , and I create my database with SQL Server 2005.

My question is When I want to setup the application on other machine , Shall I install SQL Server 2005 on each machine to work with the application or is there any other solution ? ?

 

[markros]

Do you have a server you can access from your other machines?

 

[JoeAtWork]

Normally you would have one SQL Server that all clients connect to. Sometimes applications are designed as stand-alone, in which case they usually use SQL Server Express.

However, the fact that you are asking the question makes me suspect you did not take multi-user considerations into the design of your application, so you may end up having concurrency issues and other problems when multiple clients are connected at the same time.