How can a create a ODBC connector that all users (even those not in the local Admin / Power users group) use to connect to a database on SQL 7.0 Server.???
Senario: Win2K Terminal Server w/ Citrix 2000 Metaframe. I have an Database Application that uses an ODBC connector to connect to an SQL 7.0 database / server.
When I create the ODBC connector as a User w/ admin privaledges (only those user in the local admin group or power users group can use the “system DSN – ODBC” connector. If any other user log’s on they receive an error “Can connect to ODBC Data source”.
Since the problem is NT rights — how can I ?change the security to add/assign a specific NT user group (users who need to access this database)the appropriate rigts.
I’ve looked in the local Security policies and could not see anything that jumped out at me, that would work.
I do know that if I place the users in the local Power users group, that this works — but then I don’t want to give these users that much power on the local member server.
I would appreciate any suggestion or help.
Sincerely,
Bill Miller, MCSE
Network Engineer
Alpern, Rosenthal & Co.
wmiller@alpern.com
