Blocking Access Reporting

External Since: Jul 27, 2008 Posts: 1

Is there a way to block Micorosoft Access connections to our SQL database?
Is there a way to allow certain users or computers access to SQL for Access
connections and blocking others? We have users accessing SQL database via
Access on their workstation through ODBC connections that we don't want to
have access.

External Since: May 30, 2004 Posts: 1649

Andy1974 (Andy1974@discussions.microsoft.com) writes:
> Is there a way to block Micorosoft Access connections to our SQL
> database? Is there a way to allow certain users or computers access to
> SQL for Access connections and blocking others? We have users accessing
> SQL database via Access on their workstation through ODBC connections
> that we don't want to have access.

Which version of SQL Server are you on? If you are on SQL 2005 SP2, you
could consider a logon trigger.

See the CREATE TRIGGER topic in Books Online for details. Make sure
that you have a recent version of Books Online, see my signature for a
download link.

--
Erland Sommarskog, SQL Server MVP, esquel DeleteThis @sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx