to run as "Administrator" that would solve your problems. I DO NOT
recommend this in a production environment.
I myself usually set up an account called "ColdFusion" or something like
that and give it only the necessary permissions. I then connect to my
SQL server using SQL authentication and a VERY long password.
Ideally, your SQL server should NOT be exposed to the internet. Run it
on a private .10 network or something instead.
Is there any reason why you need Windows only authentication?
-Novak
-----Original Message-----
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:37 AM
To: CF-Talk
Subject: CF and MS SQL server authentication
When setting up ColdFusion to work with MS SQL server 2000 I am having
trouble with usage of Windows only authentication (prefered), I am
forced to use SQL authentication. SQL and CF run on different computers
on the same network. What accounts (permissions) should SQL and CF work
on for windows authentication to work?
TK
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
