Re: CF Admin DSN error

["JR "Bob" Dobbs" <webforumsuser@xxxxxxxxxxxxxx>]

[q][i]Originally posted by: [b][b]elDonrico[/b][/b][/i]
 When you say [Q]run your CF service as a Windows user with access to your 
database[/Q]...

 which service are you talking about? ODBC Agent? ODBC Server? App server? 

 also, if i was to do this, what are the draw backs to running the services as 
a user as opposed to "Local System"

 thanks.[/q]


 If you use a Windows account run the CF and access your database you will need 
to run the "ColdFusion MX 7 Application Server" service as a specific windows 
user.  Since you will be using Microsoft's JDBC you need not alter the ODBC 
services.

 Here an article that lists the required permissions for your windows account 
to be able to run the service.  You should use a strong password for this 
account and change the password regularly.
 I'm not sure there any drawbacks to this approach other than needing to manage 
another windows account.  An advantage is that your CF server can access 
network resources, such as file shares, which Local System cannot.
 http://www.adobe.com/go/tn_17279

 See this post for setting up your driver/DSN (this refers to an older version 
of the driver, but should be appicable to the newest version as well)
 
http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=6&t
hreadid=1206110&highlight_key=y&keyword1=integrated

 Driver download from Microsoft
 
http://www.microsoft.com/downloads/details.aspx?FamilyID=C47053EB-3B64-4794-950D
-81E1EC91C1BA&displaylang=en

 About driver
 http://msdn2.microsoft.com/en-us/library/ms378749.aspx