We have SQL 2000 server. And our DBA clients connect to the various
databases on their using SQL Enterprise Manager installed on each of their
computers. For authentication to the databases they can connect by either
Windows Authentication or SQL authentication inside of SQL Enterprise
Manager. We do want to keep this dual authentication capability. The
problem is the owner here also has SQL Enterprise Manager installed on his
computer. (He is not a DBA and that worries us). What I would like to do is
somehow edit his SQL Enterprise Manager so that it would only allow him to
connect via an SQL account and NOT by Windows Authentication. Is there a reg
hack or ini file that I can edit that would remove or grey out this option?
-Rich

No, this is not possible. You could (but this is a really hack,
disable TCP as a client protocol for SQL Server at his computer), but
this should be consider as an option, so forget about that :-)

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Hi Rich,

Can you remove his NT account off the SQL Server? That would be the only
way to force the person to use a SQL login.
Builtin\administrators also allows anyone with NT account in the local admin
group of the server to be a sa role.

"Rich L" <RichL (AT) discussions (DOT) microsoft.com> wrote