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
Related Q & A:
- Can I create a second filestream container on an existing SQL Server 2008 database without going offline?Best solution by Database Administrators
- How to connect Sql Server Database from android app?Best solution by Stack Overflow
- What is the best practice for free space for a SQL server database drive?Best solution by Database Administrators
- How to import XML into SQL Server database?Best solution by Stack Overflow
- How do I connect to a SQL Server database?Best solution by Stack Overflow
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.