June 29, 2009 at 2:46 am
USers are working on Myserver with registering in their own sql server, they are able to continue even after i kill their session, whenver they do some activity a new session is created.
The requirement is, i want to restrict the user so they can't register my Server in their local machine, they will connect to the main server only through some specfic application.
if user come from different channel rather than specified channel (some specific application), then is kill their session through SP. but it doesn't work
Jai
June 29, 2009 at 3:06 am
under you MSSMS go to server properties and under connections, untick the allow remote connections to the server.
That should do it ...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
June 29, 2009 at 3:13 am
I can't do this because there are different application connecting remotely on this server.
June 29, 2009 at 3:38 am
this option is for when you connect to the server remotely, from a remote PC, desktop, server, laptop to a MS SQL2005 instance on a server.
The applications connect to your DB and querying you DB so this option will not interfer with that.
Try it out on a test server ...
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
June 29, 2009 at 4:33 am
even after untick the option "Allow remote connection to this server", still i can register/work on this server from different client system.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply