How do I Restict Clients by IP Address to Access SQL Server 2005

Published by: Matt (11/10/2008 3:57:49 PM)

I want to block clients on their ip address for security reasons but i don’t know a way by which i can stop the unauthorized ips to access the sql server 2005. I don’t see any options in SQL Server Management Studio 2005. Please help me to configure this.

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

Can I Add a Column in the Middle of Two other Columns using SQL Command >>

<< Can I Update 2 Tables Using Single SQL Query