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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 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
RE: Setting up user for CFMX for MSSQL on WinXP home>>>
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
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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 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
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 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
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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting up user for CFMX for MSSQL on WinXP home>>>
lol, had too ask:) try these http://www.uwec.edu/help/WinXP/perm-estab.htm (watch the wrap) http://www.macromedia.com/support/coldfusion/ts/documents/odbc_ds_undefined. htm - Original Message - From: "Tyler Silcox" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 14, 2003 4:34 PM 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Setting up user for CFMX for MSSQL on WinXP home>>>
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
Re: Setting up user for CFMX for MSSQL on WinXP home>>>
Hallelujah! It was a silly: You can change the Authentication from "Windows only" to "SQL Server and Windows" on the Security tab of the sql server properties in EM. So instead of Windows trying to let me in, SQL will allow me to set up a DSN straight from CF Administrator using the sa account. It works fine, and now I can continue my project from home, with my wife and my dog. Thanks for all the help-> Tyler - Original Message - From: "Dave Lyons" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 14, 2003 4:42 PM Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> lol, had too ask:) try these http://www.uwec.edu/help/WinXP/perm-estab.htm (watch the wrap) http://www.macromedia.com/support/coldfusion/ts/documents/odbc_ds_undefined. htm - Original Message - From: "Tyler Silcox" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 14, 2003 4:34 PM 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting up user for CFMX for MSSQL on WinXP home>>>
This will work also...thanks again-> Tyler - Original Message - From: "Chris Kief" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 14, 2003 4:47 PM Subject: RE: Setting up user for CFMX for MSSQL on WinXP home>>> 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Setting up user for CFMX for MSSQL on WinXP home>>>
As long as u got it! :) - Original Message - From: "Tyler Silcox" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 14, 2003 4:51 PM Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> > Hallelujah! It was a silly: > > You can change the Authentication from "Windows only" to "SQL Server and > Windows" on the Security tab of the sql server properties in EM. So instead > of Windows trying to let me in, SQL will allow me to set up a DSN straight > from CF Administrator using the sa account. It works fine, and now I can > continue my project from home, with my wife and my dog. Thanks for all the > help-> > > Tyler > > - Original Message - > From: "Dave Lyons" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, June 14, 2003 4:42 PM > Subject: Re: Setting up user for CFMX for MSSQL on WinXP home>>> > > > lol, had too ask:) > > try these > http://www.uwec.edu/help/WinXP/perm-estab.htm > > (watch the wrap) > http://www.macromedia.com/support/coldfusion/ts/documents/odbc_ds_undefined. > htm > > > > > > - Original Message - > From: "Tyler Silcox" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, June 14, 2003 4:34 PM > 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