Only allow certain processes to connect to MS SQL
- by Fred
I've lost the source code for a very old application that connects to a MS SQL-server for some SQL queries. Since the login is hard-coded in the application I can't change the username/password on the server.
One day the password will probably be known to the users and we surely need to change it. But how?
One idea is to only allow the old application to do the queries on the SQL server and block out any other application like the query analyzer etc. Can I set process permission somehow?
The SQL server (MS SQL 2005) and application (C++) are on the same machine
It's too costly to rewrite the old program
Thanks for help!