Re: Windows Authentication and software in a hosted environment.

What type of authentication are you using for the VPN? Windows? or
something else.

If you are using something like ISA server then the user is passing windows
credentials in order to gain access to the domain. In this case you could
use windows auth on the SQL server.
In my experience with hosted DB solutions almost always SQL auth is used.

I dont see any reason why the client would have any type of server.

You could write as part of your client implementation script a SQL account
Creation. Perhaps make it the same script that creates the db using
something like

CREATE DATABASE Sales_1
ON
( NAME = Sales_dat,
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\saledat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'c:\program files\microsoft sql
server\mssql\data\salelog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )

USE sales
GO
sp_addlogin @loginame = 'Sales_1', @password = 'password', defdb = 'sales_1'
GO
USE sales
GO
sp_grantdbaccess 'Sales_1'
GO




--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"Sam Davis" <SamDavis@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6779F1A3-5788-4DF1-9EDB-9494CE5D6289@xxxxxxxxxxxxxxxx
We are looking at creating an application which we would like to offer in
a
hosted environment. The database would be held at our data center, and the
user would connect through VPN to access the data. My question is if we
use
Windows Authentication do we need to manage the remote offices network
authentication, require them to have a windows server for authentication,
or
are we limited to just using SQL Authentication? What are the scenarious
required for this? In addition we would have a database per customer.
Which
means we would have to manage N domains, N = Number of Customers.

Any thoughts on the subject is appreciated.

Thanks

Sam


.

Relevant Pages

  • RE: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Accessing SQL Server w/ Forms on Intranet
    ... Windows Integrated Authentication as that is what our network runs on. ... > of authentication are you using on SQL Server - Windows? ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Connecting to SQL Without Windows Authentication
    ... Are you connecting to the SQL ... Server via named ... >> I have a Windows 2000 server ... If I connect using SQL Authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL / IIS Application Pool Identity
    ... Set the authentication tag in web.config to "windows" (this way it actually ... to sql, which will obviously be different for each user. ... I want to use the application pool identity to make the> connection to the SQL server database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Need help configuring Wireless Connection profile
    ... and I can only use the intel OR windows utility, not both at the same time. ... Windows authentication for all users,4129,LRG\ryanv,4149,Wireless WPA2 ... SMALL BUSINESS SERVER: ... STEP #1 Install Certificate Services ...
    (microsoft.public.windowsxp.general)