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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4