I think the issue is not just Enterprise Manager, but opening up ports 1433 and 1434 to the internet. I have hosted situations which allow that access, and to be honest, it bothers me a little...the slammer worm made a lot of people more wary of having those ports open. Microsoft recommends that they not be open.... http://www.microsoft.com/sql/prodinfo/previousversions/securingsqlserver.mspx
On 2/6/06, Mike Kear <[EMAIL PROTECTED]> wrote: > 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:231421 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
