How to restrict access to a sql server database from Azure?

SQL Server database security?

  • I'm using my computer as a server on a local network and I have sql server 2000 database installed..the problem is when I keep my computer turned on, anyone can access the data in the database..I don't know how to fix this..I don't know how to add login users..my web application installed on the server can access the database through login accounts on the web application itself. So if I added any other login users on my sql server database, those users might not be able to access the database from the web application. What should I do to secure my database on my computer so that noone can open it if they sat down on my computer?

  • Answer:

    Right click on your desktop choose properties then the screensaver tab and check On resume, password protect and set the wait time to just a few minutes. That way when you leave your computer your pc will be password protected with your login password preventing others from accessing it and SQL Server. Also, when you remember, WindowsKey + L to lock your computer. Make sure your login has a password specified for it.

what goes around comes around at Yahoo! Answers Visit the source

Was this solution helpful to you?

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.