Set up a username and password combination on SQL Server, and only give any read and write access to that user.
http://technet.microsoft.com/en-us/library/aa337545.aspx[
^]
You can't set SQL server to reject applications (since it can be running on a separate PC that doesn't know what application generated the request), but you set set it to only allow "UserX" access to a specific database.