shresthaal
Programmer
i want to disallow a hostname from connecting to the sql server can i do it? if i can how would i do it
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to disconnect a connection from sql server
- Thread starter shresthaal
- Start date
- Status
mrdenny
Programmer
- May 27, 2002
- 11,595
You would need to do that via your firewall which would require the machine you want to block to have a static IP.
There isn't a way to block my host name.
Why not simply revoke that persons login to the database.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
(Not quite so old any more.)
There isn't a way to block my host name.
Why not simply revoke that persons login to the database.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
(Not quite so old any more.)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
