Reputation: 969
How to give the permissions to sql server 2008 database to insert the data from client system in c# windows application(I am able to fetch the data from database in remote server but i am unable to insert the data from client system to remote server database)
Upvotes: 0
Views: 594
Reputation: 13150
You need to create a user in SQL server 2008
database having rights to insert data, and use that user's credentials in your connection string
.
Upvotes: 1