SQL Logins vs Windows Authentication



I have a VB6 app that uses an SQL Server database. The application uses
Windows Authentication to connect to the database. Permissions in the
database are granted to a domain group. I am considering having the
application hosted. The hosting company says they are configured for SQL
authentication and cannot allow Windows Authentication for security reasons.
They use SQL Server 2005 (cluster). This puzzles me. The users running my
app will have Active Directory accounts in the hosting company's domain.
What security reasons could there be? I hesitate to code SQL Login names and
passwords in my application.

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--


.



Relevant Pages

  • Re: Blocking MS Access from linking tables...
    ... Does connection pooling work the same way? ... database that was converted from Access to SQL Server. ... I know that using an Access form can create multiple SPIDs on SQL Server ... If you're using Windows authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: cannot open database requested in login
    ... Is the connection object using Windows Authentication? ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > I have a DTS replication which truncates the destination> of one database and copies all the rows from the source> table of another database of same serverin> first step. ...
    (microsoft.public.sqlserver.dts)
  • Re: Trouble connecting to SQL Server express over Peer to Peer network
    ... I have a program that accesses an SQL Server Express database. ... Configuration and I connect using Windows Authentication. ... that have never been connected to the domain, I have an issue connecting. ...
    (microsoft.public.vb.general.discussion)
  • Re: Open DB using OLE DB
    ... is there a way of the user to select the SQL Server ... >> database? ... >Windows Authentication instead, ... first shift-minus last a t m s n d o t c o m ...
    (microsoft.public.vb.general.discussion)
  • Which Back-End Affordable Database do you RECOMMEND???
    ... I need to hear from you experts what database system you prefer to use ... when you're creating a VB6 app that is going to need an *affordable* ... To give you a bit of a benchmark, though I have used SQL Server in the ...
    (microsoft.public.vb.general.discussion)