The SQL server we have running sits on its own box. So, the web server is independent of it. There are ODBC connections from the web server to the SQL server.
-----Original Message----- From: Haggerty, Mike [mailto:MHaggerty@;mbda.gov] Sent: Monday, November 04, 2002 3: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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
