Our ISP allows Ent Mngr on shared hosting (we've never had a security issue)....they lock down connections by IP (a bit of a pain at times....but better than most ISPs). So you get DTS, which as you said is dang handy ;-)
Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: "Mike Kear" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, February 06, 2006 6:40 AM Subject: Enterprise Manager in a shared hosting situation > Is it a security risk to allow site owners to access their databases in a > shared hosting arrangement by using Enterprise Manager? (Obviously I'm > talking a windows box and MS Sqlserver2000+) > > I would have thought it was no more of a risk than allowing users to access > their databases with other tools, no?? > > I'm looking at a new hosting company and they're terrific in many respects, > but they dont allow access to SQLServer databases except by the on line > browser-based SQLManager and/or ColdFusion To that's going to mean writing > export routines to export data to CSV files or something, ftp it to the > site, then run an app on the site to import the data to the SQL that > way. > > It's a pain because it's very convenient to use a DTS package to upload a > whole bunch of data automatically I wouldnt be able to do this with this > hosting company. > > -- > Cheers > Mike Kear > Windsor, NSW, Australia > Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231447 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
