July 2, 2009 at 3:48 am
We are running SQL 2005.
I want to restrict the user so they connect the SQL server only through some specific application (e.g. vb.net application), they should not able to register this server on another system.
I already untick the "allow remote connection" from Server Properties --> Connection.
July 2, 2009 at 3:55 am
Have a look at Application Roles in books online. These should allow you to control what applications are connecting through.
July 2, 2009 at 4:32 am
Hello,
Would it be possible to create a Login just for the application i.e. do not grant any access to the SQL Server to the “real” user accounts?
From what I understand of Application Roles, the users would still need to be granted access to the SQL Server, as the switch to an Application Role occurs after the connection - or am I mistaken?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply