You may want to look into switching it to mixed mode authentication: http://support.microsoft.com/?kbid=319930#6
chris >-----Original Message----- >From: Tyler Silcox [mailto:[EMAIL PROTECTED] >Sent: Saturday, June 14, 2003 1:35 PM >To: CF-Talk >Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> > >Hehe...yea, and WinXP's ODBC Data Source Administrator and Enterprise >Manager are hitting it fine-> > >Tyler > >btw: I hope it does turn out to be something silly, just as long as it >turns >out soon-> > >----- Original Message ----- >From: "Dave Lyons" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Saturday, June 14, 2003 4:27 PM >Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> > > >maybe a silly ? but is your db running? > > >----- Original Message ----- >From: "Tyler Silcox" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Saturday, June 14, 2003 4:23 PM >Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> > > >> Yea...CFMX developer edition on WinXP home, served up from CF's built in >> server-> >> >> Tyler >> >> ----- Original Message ----- >> From: "Dave Lyons" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Saturday, June 14, 2003 4:11 PM >> Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> >> >> >> sorry, wasnt thinking as usual, I was thinking xp pro & IIS >> but it still could be an issue, chris maybe right though >> but heres a link to try if his suggestions doesnt pan out >> >> >http://www.macromedia.com/support/ultradev/ts/documents/understanding_ntfs. >h >> tm >> >> >> >> ----- Original Message ----- >> From: "Tyler Silcox" <[EMAIL PROTECTED]> >> To: "CF-Talk" <[EMAIL PROTECTED]> >> Sent: Saturday, June 14, 2003 3:58 PM >> Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> >> >> >> > Where's (and what's) that? >> > >> > 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