I'm trying to setup a new server but need to stop people accessing the database via Access, Excel etc
Is there any way to set SQL server up to stop connections from such applications?
Is there any way to allow only certain users to connect via a DSN
We are not using windows authentication on the server
Cheers
No, you cannot restrict connections based on the application that made them. But you can restrict connections based on the account they were made with. You can try to have your application connect to SQL Server using a specific account and not grant any connection rights to the users - then they would only be able to access the database through the application. Of course, if they would debug the application, they could figure out how it connects to SQL Server (the account and the password), but this would at least prevent accidental connections from other applications.
Thanks
Laurentiu
No comments:
Post a Comment