Monday, March 26, 2012

Permit to connectting SQL Server 2005 Express only at specific client ip.

Hi, how can I set SQL Server 2005 Express to permit only specific client ip? Is this possible using T-SQL?

This is not possible using SQL Server or T-SQL.

You may be able to limit the connecting clients by using IPSEC or SSL.

|||Hi,

there is a property which is called Applicationname which can be retrievedt hrough the APP_NAME() function. But be aware, one can change that by just manipulating the connectin string, so if you read this anywhere on the web, that this "security feature" can be used to check the application name, just ignore it.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||And many 'custom' applications do not provide an AppName.

No comments:

Post a Comment