Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Prevent Excel a...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 11023 of 11265
Post > Topic >>

Prevent Excel and Access access to SQL 2000

by Jimbo <james.goodwill@[EMAIL PROTECTED] > May 7, 2008 at 12:54 AM

Hi,

I'd like to prevent Excel and Access (well any Microsoft Office
application) from gaining access to a     SQL 2000 instance, via an
ODBC connection.

If this we're SQL 2005, I create a logon trigger, and just kill off
unwanted connections.

Can anyone suggest how I can achieve this is SQL 2000?

Thanks,

James.
 




 3 Posts in Topic:
Prevent Excel and Access access to SQL 2000
Jimbo <james.goodwill@  2008-05-07 00:54:21 
Re: Prevent Excel and Access access to SQL 2000
Erland Sommarskog <esq  2008-05-07 21:48:31 
Re: Prevent Excel and Access access to SQL 2000
"Leif Neland" &  2008-05-08 12:21:05 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 25 5:26:04 CDT 2008.