FreeTDS Development Group

["Geoff Winkless" <geoff AT farmline.com>]

"James Cameron" <james.cameron AT compaq.com> writes:
> Geoff Winkless wrote:
> > You have got SQL Server authentication turned on for the SQL server, I
> > take it?
>
> Cooperation with the server administrator is not clearly defined, this
> is a subversive effort ... "Just use Windows" they say.
>
> There are multiple databases involved.  Evidence so far suggests that
> some of them require Windows NT Domain authentication only, whereas some
> of them require SQL Server authentication, all within the same
> application.

Hmm.

AFAICT you can only specify authentication types at the server level. It's
simply a matter of going to one server and five button clicks.

For the user, you can add a user in Server->Security->Logins->New Login,
then you have a list of access permissions for each database (under Database
Access). You can then specify the roles you want the user to have in each
database. Assuming that security on the database is set up in a sane manner
(so that the roles have the access you want them to) that's all you have to
do.

To be honest you have to do this whether you access it through NT security
or using SQL auth, there's no more work involved either way. Someone is
either being deliberately awkward or doesn't understand what you're asking
for.

AFAIAA freetds doesn't even attempt NT security, although I suppose you
could "borrow" the NT domain stuff from samba. Basically as it stands
there's no way you'll access an NT-only database with anything except
Windows.

> One server has 640 tables defined, and that is used as the
> argument as to why they don't want to try to implement functionality
> that a minority request.

Someone's deliberately being a pain. There's one in every company. Just find
him and tell him :-)

Geoff