Click here to Skip to main content
14,332,032 members
Rate this:
Please Sign up or sign in to vote.
See more:
hi i have written a program with sql server 2008 and vb.net
that will works in
only one computer,what i should install in that computer?
should i install sql server 2008 on that computer?
Posted
Updated 17-Jan-11 4:30am
v2
Rate this:
Please Sign up or sign in to vote.

Solution 1

It depends.

Normally, you would install SQL Server in one PC, and the others then connect to it over the network. The clients then need no extra installation unless they are editing teh database directly, rather than via your app.

If you are using SQL server as a standalone database that is a little overkill: consider SQLCE or Access instead. They are both a lot smaller and may be better suited to a standalone application.

SQL Server is not a small installation, and may leave security holes if you make it available to every user...
   
Comments
Аslam Iqbal 17-Jan-11 10:52am
   
yeah it is true. but need a client application.
Reza Oruji 17-Jan-11 10:55am
   
database is local and i have to use sql server
Rate this:
Please Sign up or sign in to vote.

Solution 2

Yeah. You need to Install SQL Server on target machine. To do this goto publish & click on prerequisites & check the proper components. i.e:
SQL Server Compact ...
SQL Server.......
Crystal Report.....
.................................
And all other components you need.
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100