Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Blocking Access Reporting

  
   Database Forums (Home) -> Security RSS
Next:  MS SQL 2005 Certification Dumps  
Author Message
Andy1974

External


Since: Jul 27, 2008
Posts: 1



(Msg. 1) Posted: Sun Jul 27, 2008 7:49 am
Post subject: Blocking Access Reporting
Archived from groups: microsoft>public>sqlserver>security (more info?)
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.

 >> Stay informed about: Blocking Access Reporting 
Back to top
Login to vote
Erland Sommarskog2

External


Since: May 30, 2004
Posts: 1556



(Msg. 2) Posted: Sun Jul 27, 2008 2:46 pm
Post subject: Re: Blocking Access Reporting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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.TakeThisOut@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

 >> Stay informed about: Blocking Access Reporting 
Back to top
Login to vote
newscorrespondent

External


Since: Apr 13, 2006
Posts: 4



(Msg. 3) Posted: Tue Aug 12, 2008 8:24 pm
Post subject: Re: Blocking Access Reporting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
If you don't want any ODBC you can turn it of with the Configuration Tool.
 >> Stay informed about: Blocking Access Reporting 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Reporting Services RSExecRole - What is the function of the RSExecRole? Should I be granting this to users in a development environment who need to create reports? Thanks, Steve

SQL Server Reporting Services failing to install - I'm trying to install SQL Server 2005 on my Small Business Server 2003 PC. When I specify that setup should install everything including SSRS, it always fails with an error message that says, "Failed to create a SharePoint exclusion path". T...

job access - I thought I had read that in SQL 2k5 we would be able to give a non-sa user access to specific jobs, but I can't find how to do this. Is it possible? If so, can someone tell me how? Thanks, Andre

SQL 2000: Profiler Access - Hi, I need to give access of profiler to developers and what is the best way for me to allow the access and not disclosing the sysadmin login? Can I let user access to profiler w/o sysadmin rights? Thank you. Rob

rowset access - Hello! How would it be possible to have a report return a different set of records per user account, if it always ran against the same view or procedure? Is there an easy way to customize such an access for non-domain users whose accounts are created...
   Database Forums (Home) -> Security All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]