Re: SQL Logins vs Windows Authentication

Richard Mueller [MVP] (rlmueller-nospam@xxxxxxxxxxxxxxxxxxxx) writes:
I assume it would not be the domain the hosting company uses for their
normal business, but a domain they created for the hosted customers. I
don't know how the customers will make the connection, but they will
login to the Active Directory domain. They will use one of several
application servers where they would launch several applications,
including mine. I assume the SQL Server is in the same domain.

As Roy said, that may be the catch.

If the SQL Server machine is in your customer domain, I guess that will
make administration more difficult for the hosting company.

But if the SQL Server machine is in your customer domain, I see no
reason why you should not be permitted to use Windows authentication.

It seems to me if SQL Logins are used, either all customers use the same
SQL credentials, or I read the credentials from text files. Why have
passwords in that case?

You have to descend to give them login window and a personal SQL login
and password to log in with. This would be needed for auditing etc.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: SharePoint Services
    ... I'm under the impression that the data tables can be uploaded to a SharePoint location, and that read / edit permissions could be enabled for different users??? ... It was common for customers to have accounts in more than one store / town ... ... However if you do not have share point services setup, nor do you have the expertise and training and resource personnel to run and set up those servers + SharePoint, **if** you users NOW have some type of connection to you network, then then I think the easiest and least amount of effort would be to simply put the backend database on SQL server and and link your front ends to that back end user. ... So, if these people are outside of your corporate network now, then expertise and ability to set up secure connections to allow them to come into your corporate network and pull data from sql server is VERY seriuos issue. ...
    (comp.databases.ms-access)
  • Re: User Question
    ... and write capabilities. ... Should that be an SQL login or Windows login? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 express blank sa passwords
    ... that uses the Sa login, I need to set the password to blank. ... I suggest that you get a voodoo doll of that former DBA, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Using sql to execute a batch file, xp_cmdshell
    ... In here I have entered the login and password for an accepted ... credential when I am running the bath file? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server Royalty
    ... would the customer, but this "royalty premium"... ... > to work on its database. ... > in house applications using SQL Server to other databases ... >>> customers this 'premium' if customers want to use their ...
    (microsoft.public.sqlserver.clients)