is it necessary to install SQL in client to access database?

Question

i am configuring a program database with microsoft sql 2005. to access that database is it necessary to install sql in server also

Answer 1

If the database will only be accessed from a particular PC, then no. However, if it is to be accessed over a network or by a web app, there has to be some sort of service active to provide connectivity.

Answer 2

Depends. It is possible to access SQL from one machine to another depending on how SQL (particularly the db users) and your firewall are configured. However, there will be a speed bottleneck if the database is being hit frequently, is transferring lots of information or if the connection between machines is slow.



If this is a web app then its preferable to have SQL installed on the machine running the app. If expense is an issue then you might want to look at mySQL as a possible alternative.

Answer 3

To administer or access the DB from a client app, you do not need to install the Server engine on the client. The .NET framework runtimes on the client have the necessary DB drivers to establish a connection.



Use SQL Management stusio express (free) on the client to manage the DB (add tables, etc...). You can use 2k5 or 2k8 to connect to the 2k5 server

http://www.microsoft.com/downloads/details.aspx?familyid=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Answer 4

Don't ask me.