MS SQL Server - Block MS Office Connection

Author

Block MS Office Connection

T Morris

2006-10-28, 7:14 pm

SQL Server 2000.

Is there a simple way to block MS Office connections to a SQL Server database?

Thanks,
Tom

Brian Pursley

2006-10-28, 7:14 pm

Easy, dont give them a login to use.

"T Morris" <TMorris@discussions.microsoft.com> wrote in message
news:1C16D499-3B03-4252-A474- 042650A67385@microso
ft.com...
> SQL Server 2000.
>
> Is there a simple way to block MS Office connections to a SQL Server
> database?
>
>
> Thanks,
> Tom

Arnie Rowland

2006-10-28, 7:14 pm

Yes, disable the network adapter.

The long answer is no. If the user has a valid SQL Server username/password
(or) their network identity or group has access to the server/database, then
there are many applications, including Office products, that can be used to
access the data in the database.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

"T Morris" <TMorris@discussions.microsoft.com> wrote in message
news:1C16D499-3B03-4252-A474- 042650A67385@microso
ft.com...
> SQL Server 2000.
>
> Is there a simple way to block MS Office connections to a SQL Server
> database?
>
>
> Thanks,
> Tom

John Bell

2006-10-31, 12:15 am

Hi Tom

One option may be to use an Application Role for your own application and
only grant the privileges needed to access the tables to this role.

If you restrict access to be only by stored procedures and don't use dynamic
SQL then your users will only be able to execute these procedures and not
access the data directly regardless of the application they are using.

John

"T Morris" wrote:

> SQL Server 2000.
>
> Is there a simple way to block MS Office connections to a SQL Server database?
>
>
> Thanks,
> Tom

Sponsored Links