Loading

SQl Security (how to ensure that my sqldatabase is secured)

Carlos kambui

have developed systems using .net and sql ,they are working but my sql is open (no security) anybody can just open sql with windows authentication mode and tamper with my data ,what are procedures to to follow to ensure that my database is secured ? kindly help

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jayant Rajwani9y ago
create a new account in your SQL and put your database there use it in your app like

<add name="ANY_NAME" connectionString="data source=JAYANT8;initial catalog=YOUR_DATABASE_NAME;user id=YOUR_USER_ID;password=YOUR_PASSWORD;MultipleActiveResultSets=True" />