ODBC Connection - Trusted Vs Not Trusted

Vic wrote:
> Trusted means that the domain login has a domain login on SQL Server.
>
> "untrusted" means that you've set up a generic login on your
> SQL server.
>
> The benefit of trusted is the user isn't prompted for a user
> name and password every time they use ODBC. The drawback is
> that if you have a lot of ODBC users it can be a PITA to set
> up all the privileges for each user.

For my SQL work, I ONLY use trusted connections. I manage multiple users by
putting them into AD Security Groups. One group for read-only, another for
power-users, an admin group (for full access), etc. Now I just have to add
users to security groups. If a user leaves the company, I don't worry as
long as the user account is disabled. Also, there's no hard-coding passwords
into your code.

It's the only way to go IMHO.

Mark W.
What is the difference between having an ODBC connection setup as trusted Vs. Untrusted? What are the benefits of each? Disadvantages?

Thanks
Â
Dustin Biniek




[Non-text portions of this message have been removed]
Simple:

Trusted means that the domain login has a domain login on SQL Server.

"untrusted" means that you've set up a generic login on your SQL server.


The benefit of trusted is the user isn't prompted for a user name and password every time they use ODBC. The drawback is that if you have a lot of ODBC users it can be a PITA to set up all the privileges for each user.

I have a generic login that provides READ ONLY access. For some users who love Excel and need to download the contents of a table I provide them the untrusted login info.

We have CSG's ADP Payroll custom code and for my 2 Payroll clerks I've set up as TRUSTED because they use it all the time and a login would be a PITA and also they require UPDATE/DELETE/INSERT access privileges to the ADP supplementary tables.




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of melissa hietala
Sent: Thursday, October 08, 2009 3:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Connection - Trusted Vs Not Trusted

What is the difference between having an ODBC connection setup as trusted Vs. Untrusted? What are the benefits of each? Disadvantages?

Thanks
Â
Dustin Biniek




[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links