What is your connection string in ASP? Are you specifying a SQL Login? I have come across the "Not associated with a trusted SQL Server connection" before, and it usually means that the SQL Server does not allow SQL Logins, however it only allows for NT Authentication.
You can enable SQL Server to accept SQL Logins using the following steps: 1) Open Enterprise Manager 2) Connect to the desired SQL Server 3) Right-click on the SQL Server and select Properties 4) Click on the Security tab 5) Select SQL Server and Windows under the Authentication section 6) Click OK to complete the change You can also use integrated NT Authentication is you connection string (assuming that ASP is running under a user account that has access to that SQL Server): Provider=SQLOLEDB;Data Source=(local);Initial Catalog=pubs;Integrated Security=SSPI HTH. >< Scott > -----Original Message----- > From: Clark, Aimee [mailto:aclark@;stinsonmoheck.com] > Sent: Monday, November 04, 2002 4:52 PM > To: CF-Talk > Subject: FW: Running ASP on a server used for CF > > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
