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?
Related posts:
1 response so far ↓
1 Chad B // Jul 3, 2008
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.
Leave a Comment