> Server and a M$ SQL Server (CF5 & M$ SQL Server 2000).
> Currently the network is on a domain.
> Soon it will be on a workgroup. Here's my question:
>
> Three services are tied to the domain account: Cold Fusion
> Application Server, MSSQLServer and SQL Server Agent. They
> are logged in as: DOMAIN\USER NAME. Typically, I use Windows
> Authentication to connect to SQL Server.
>
> When I switch to a workgroup, I will register the three services
> as: LOCALHOST\USER NAME. Will this work? Will I have any issues
> with database connectivity and CF? Are there any pitfalls to
> doing this? Obviously, I am not a networking guru and I need
> your help!
Within a workgroup, there's no direct analog to a "domain account". So,
assuming that your CF server is on one box, and your SQL Server is on
another box, you may have trouble running CF as an account that you can
grant login rights to within SQL Server.
You can, of course, switch to untrusted connections, in which you use native
SQL logins instead of Windows authentication. Currently, if you plan to
upgrade to CFMX, you may need to do this anyway (the status of trusted
connections via the JDBC drivers that CFMX provides is a bit up in the air
right now - DataDirect 3.3 supports trusted connections, but CFMX doesn't
provide an obvious way to enable them).
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
