Did you change the UN/PW in your datasource? If you change it there, then all connections to your DB using that datasource will go through your new UN/PW.
On Fri, Nov 12, 2010 at 10:55 AM, Doug Ford <[email protected]> wrote: > > Hi folks - > > I am trying to lock down my MS SQL server access when CF access it. > > I have set up a user & password, gave it the right permissions, put that U/N > and p/w into my code and that works. > The problem I have is that CF still allows default access to the DB. > > So whether I use the U/N or P/W, both methods still allow access. > > I have been playing with the security of a test DB to figure out what I need > to do, but I have had no success. > > Any pointers would be appreciated. > > Thanks, > > Doug > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339149 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
