prevent access based on hostname

[johnv20]

Hi,
does anyone if its possible to prevent read access to a SQL 2005 db based on the client hostname attaching..

 

[ousoonerjoe]

If you are trying to deny that host machine all together, then set it in the Local Users and Groups settings or the Active Directory to prevent access.

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[mrdenny]

One thing you can try, which may or may not work is to setup a login on the server for the computer account which you want to deny, then deny access to that login.

Computers have accounts in AD just like users do. Setup a login like DOMAINNAME\ComputerName$ and setup that login to deny access to the server or database and see if that works.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog