Make sure you have sql authentication turned on on your sql server. -----Original Message----- From: Haggerty, Mike [mailto:MHaggerty@;mbda.gov] Sent: Monday, November 04, 2002 4:15 PM To: CF-Talk Subject: RE: Running ASP on a server used for CF
Here's what Microsoft says about the issue: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q186726&; -----Original Message----- From: Clark, Aimee [mailto:aclark@;stinsonmoheck.com] Sent: Monday, November 04, 2002 4:07 PM To: CF-Talk Subject: Running ASP on a server used for CF I have a situation in which I will begin coding some pages in ASP vs CF and I plan to do so on the same IIS server that my CF is running on. Because of the way that the server has been configured, I am curious to know if there is anything I need to be aware of if I plan to do this. So far, I have run into a problem when trying to run an ASP page and it generates a SQL error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. /isweb/pdissues/addIt.asp, line 11 Now, I have gone back and setup an ODBC connection with SQL authentication and no luck. Also on the IIS server the NT authentication is how we have it setup because we use an intranet on this server and we use NT authentication in a lot of the code we generate. So, if anyone has any insight into what I should be aware of, I would really appreciate it. I'm just trying to understand why I am receiving this error and if it's the result of trying to code ASP on a server with CF. Thank you, Aimee Clark Web Developer Stinson Morrison Hecker LLP 816-691-3461 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
