How to manage database in an application ?

[Toshi Trivedi]

I am developing an application in c# using SQL Server as database. The application's .exe file will be installed on different machine's and a server will be there having Sql Server. The connectivity to the database is done in the code and machines are connected thru Local Area Network.
I am doing this for the first time, so i am confused that how the security of the database is maintained. The admin password is used to access the database. Is it the right way or there is some other way to include the database.

Please Help Me .

Thanks in advance.

[David Gluth]

Try posting you question in the SQL section for SQL specialist to see.

I would create a user that only your application will use. Grant appropriate access (datareader, datawriter) to that user to the application database only. This will limit the access that the application has.