December 16, 2010 at 8:49 am
Hi all can u help me in suggesting the best options for the following scenario on SQL SERVER 2005
Database should not be accessible by end users even if they have SQL client on their desktop
Users should be able to access the database using Terminal Services window (by running SQL on the server directly)
All suggestions will be really appreciated...
December 16, 2010 at 9:23 am
It can be done, just don't allow remote connections in SQL Server network configuration.
However, I don't see any reason for this.
Giving Terminal Server access could be much more harmful than giving SQL access.
SQL Server security model can allow you to set the permissions for each user with an extremely deep granularity.
-- Gianluca Sartori
December 16, 2010 at 9:29 am
The only problem with disabling remote connections to the SQL Server is if your app connects from a different server then that too will error.
SQL Server does have a very granular security model and you can use that to lock down access.
Gethyn Elliswww.gethynellis.com
December 16, 2010 at 12:00 pm
As stated by the other repliers, it doesn't seem to make much sense.
you can restrict login at ipaddress level using a server level trigger (sql2005 SP2 or higher)
but just keep this in mind : http://www.sqlservercentral.com/articles/Administration/64974/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 16, 2010 at 11:32 pm
So it is better to restrict the user at the database level by minimizing his\her access because for terminal access a login account is to be created at the Server which can result in breach of security ?
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply