Re: 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
--


To clarify, several customers will use the hosted application and each will
have their own database with confidential information. The plan is to
determine the customer from the AD account parent container and group
membership, so the app connects to the correct database. Each customer will
have several users.

Richard


.

Relevant Pages

  • RE: cannot view web pages after transferring files to web server
    ... Integrated Windows authentication. ... What we want is - if a logged-in Windows user has database rights, ... asp.net in-built development server. ... However, when I copy this website to a virtual directory on an IIS server, I ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cannot view web pages after transferring files to web server
    ... Integrated Windows authentication. ... What we want is - if a logged-in Windows user has database rights, ... asp.net in-built development server. ... local machine using Visual Web Developer, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Database connection from PDA over cradle
    ... I've had no problems with Vista, but I believe based on your comments, that may be because I installed the WM 6.0 SDK which includes Device Emulator 2.0. ... Are you attempting to log in using Windows authentication or SQL Server ... >>> that the database can not be found. ...
    (microsoft.public.pocketpc.developer)
  • Re: manage page access rights
    ... storing department info in a database is limiting when you are using windows authentication. ... The departments and roles are stored in a database. ... Whats the best way to store the department/roles information and at ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Cannot connect to SQL from FrontPage (Data View WebPart)
    ... retrieving list of databases) ... I'm not sure why 'Windows Authentication' is there anyway because how ... > View to any user with access rights of any kind to the database in question. ... > So for instance on one database I have a user just for the WSS webpart that ...
    (microsoft.public.sharepoint.windowsservices)