Sorry for my 2c here, but please do not use the System Account (sa) for web
access to your SQL databases. Even if you have a password for it (default is
blank), there are security ramafications to using this account. Set up a
user with the appropriate access rights to the database in questsion.
Kevin Moss
----- Original Message -----
From: "Dave Cahall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 2:18 PM
Subject: RE: SQL Server Licensing
> You are correct. Users will not be connecting to the database other than
> through your web application. Their identity will not be know by MSSQL.
> However, you will need one for each ODBC connect. Therefore, if you are
> goind to allow 10 simultaneous connections, you will have to have 10 CALs.
> When your web app accesses the database, you will use a common ID and
> Password (typically the System Account) which will be controlled through
the
> access of your Web server and Application Server (i.e. ColdFusion, ASP,
> WebShpere, etc.)
>
> Dave Cahall
> Vice President, Professional Services
> Digitaris Technologies, Inc.
> Office: 972.690.4131 ext 116
> Mobil: 214.914.9947
>
>
> -----Original Message-----
> From: Bob Gillham [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 1:57 PM
> To: list dfwcfug
> Subject: SQL Server Licensing
>
>
> Good Afternoon -
> I am having a "friendly dispute" with my systems group. The systems
> director is convinced that in order for our web apps to access an MSSQL
> database we will need to have a CAL for each connection or have to go
> with a processor license. I have been told on several occasions, read
> on several occasions that all you need to access MSSQL is one CAL per
> ODBC connection. We are just beginning to develop web apps and have not
> had to use MSSQL as backend. This "dispute" is over licensing for our
> new database server and software licensing. We want to get it right
> from the beginning and don't want to purchase more licenses than we need
> (processor license) or have to purchase more later because we didn't but
> enough to begin with (CAL). I know this is not straight CF, but it is
> vital to our web application development.
>
> Thanks in advance!
>
> -------------------------------------------------------------------------
> This email server is running an evaluation copy of the MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info: www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
