Security Problems

   How can we overcome security problems in MSSQL?

One of the most common security problems in mssql When we enter mssql with IIS7 from localhost(wwwroot folder), you can find how to create localhost from previous my tutorials.

1.If security is missing in your login list addnew login
Login Name: IIS APPPOOL\DefaultAppPool
























2.Right click database  which you use, and  click   properties as shown. Then select all grants from the opened window as shown in the picture.












3.Thus we can solve our mssql security problems.

Yorumlar

Yorum Gönder

Bu blogdaki popüler yayınlar

Phpprogrammingusing IIS7

        Installing PHP on IIS7             The Important Steps: 1. Open Control Panel. Open Programs-> Uninstall Programs. 2. Open the Windows Features on or off.Then IIS7 will create a new folder in C: disk C://  inetpub/wwwroot Now Download the VS CODE from Microsoft Web Pages . After downloading run the VS CODE  Press  the (ctrl +,) keys together.Write php search section and select php and choose edit in setting.json then add your php-cgi.exe in as following code.Then,write following php scripts and save as: C://inetpub/wwwroot/ info.php As a finally press the run button and select add configuration and change the line as same: "url":And choose the Chrome or Microsoft Edge and run the program. <?php phpinfo(); ?>
Devamı