Make users such as webuser that only has read access and webudate that has
read and write access. That will help you out. If you put these users in
the model database then anytime you create a new database it will copy them
over. In CF admin all you would need to do then is to put webuser and then
the pass or just nothing at all. The only thing that will happen is that cf
will not be able to verify if you have sql access only. If you have nt user
access then it should be okay if the id that you are logged onto your cf box
with has admin rights. Email me at [EMAIL PROTECTED] if you need a more
in depth explanation or anymore help.
Joshua Tipton
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 10:19 PM
To: CF-Talk
Subject: CF as User
OK all. I'm in the process of setting up my new SQL Server as some of
you know my my licensing snafu. :)
Now, I'm wondering if I NEED to set CF up as a user to access the
databases on the SQL machine. Will the username and password to the
SQL databases in CF administrator be good enough if I connect with
TCP/IP?
On a side note. I'm still new to the NT stuff and was brand new to it
when I bought the Web/CF server. Dell set up the partition with my OS
as FAT for who knows what reason. I have ColdFusion and Website and
all my applications on an NTFS partition so I can set the necessary
permissions up on that if need be to run CF as a user. I made them
set up everything on the SQL Server as NTFS.
If I set CF up as a user account, will I need to make it a member of
Administrators since the OS is FAT? And I hate to even ask this, but
is there a way to change the FAT partition to NTFS without doing a
clean install? I don't even want to think about that. LOL
Thanks a bunch.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
