You need to enable trusted connections for your SQL server. Refer to this technote for more info:
http://www.macromedia.com/support/coldfusion/ts/documents/tn18245.htm I would suggest not using trusted connections if that's possible in order to take advantage of the JDBC drivers. Hope that helps, chris >-----Original Message----- >From: Tyler Silcox [mailto:[EMAIL PROTECTED] >Sent: Saturday, June 14, 2003 1:01 PM >To: CF-Talk >Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> > >And since the first email, I've added a password to my User account in >WinXP >and I'm running the 3 cfmx services as my logon, and it is still telling my >that the dsn is "Not associated with a trusted SQL Server connection." when >i create it in the CFMX admin, and use my SQL "sa" account and password-> > >Tyler > >----- Original Message ----- >From: "Dave Lyons" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Saturday, June 14, 2003 3:48 PM >Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> > > >have you set your permission to share in XP home? > > > >----- Original Message ----- >From: "Tyler Silcox" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Saturday, June 14, 2003 3:23 PM >Subject: Setting up user for CFMX for MSSQL on WinXP home>>> > > >> I know this should be very easy, but I need help (and quickly! >(...please)): >> >> I've set up CFMX on my WinXP Home laptop, and I also set up MSDE/SQL >Server and I get a "User not on a trusted connection" when I try to create >a >SQL datasource in CF Administrator. I think I need to run CFMX as a user, >so that it SQL will accept the connection, but I have no idea how to do >this. >> >> I've searched everything (cf talk's archive, google, macromedia, etc) for >the last 30/45 minutes and I can't find squat on how to do this on WinXP >home. >> >> I don't have any passwords on the laptop, just on the SQL server. I've >tried running the CFMX service as my account, but I do not have a password, >so when I leave it blank and hit "Apply"; it does not throw an error, it >just says that next time the service starts it will log in as the given >account...blah blah blah. But when I restart the service, it rejects me >because of the logon. >> >> Any help would be greatly appreciated...this should be relatively >painless-> >> >> Tyler >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
