How to protect sqlserver database from unauthorized access

[shine_paravur]

Hi all Can you help me to protect sql server 2005 database from unauthorized access.I am using C#.net2005. Please help me to solve this problem Thanks in advance regards shine.paravur@gmail.com

[dan sh]

Create user logins and assign them appropriate roles.

[Abhijit Jana]

shine_paravur wrote:

Can you help me to protect sql server 2005 database from unauthorized access.I am using C#.net2005.

1. Use Windows Authentication mode, insted of SQL Server Authentication Mode ( As Windows Authentication Mode used ActiveDirecotry to Authenticate user) 2. As you are asking about C# too, Please Encrypt your connection String :-D

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you. View My Latest Article

[Robin_Roy]

There are few options here for you: Using Windows authentication to access the database. Using SQL authentication to access the database. For Windows Authentication, you need to use Active Directory User to map to your database. For SQL Authentication, you need to create a SQL User and map the appropriate Roles and map with your database. In your C# application, encrypt your connection string and use the same. Many a times in shared deployment environment, they allow on SQL Authentication only, in such a case you will have to use SQL Authentication.