September 18, 2001 at 8:25 am
I've been searching the net this past few weeks looking for guidelines, best practices and security recommandations...
We are offering shared web hosting to our clients and they are asking us to host their databases as well.
Since SQL Server is more enterprise-based, the task of putting together a web hosting solution which include support for a SQL Server DB is not a trivial task.
I seek for help... Anyone has something on the subject (links or advices...)
Thanks,
September 18, 2001 at 10:09 am
Only advice I can offer is to give them the minimum privileges possible.
Andy
September 18, 2001 at 1:50 pm
Yeah but, but What about the network architecture, the delegated administration, any ideas?
September 19, 2001 at 5:18 pm
Redundant everything. For security, I'd say you have a couple choices. One would be grant DBO access to the client for their database, let them handle administration from there. As long as they are limited to their db, not much damage they can cause. If you can give them less, so much the better. Probably want to set a growth limit on both db and log so they cant max your drive when you're not looking.
You might consider some kind of web version of EM that would limit what they can do, most users aren't going to be big TSQL users anyway.
Assuming your network guys are handling the hardware, I'd say a single instance of SQL 2000, put together a set of scripts to set up a db and users easily. Help page to explain to users how to connect.
You might want to look at other newsgroups, maybe find one that is about hosting - probably a good idea to leverage that knowledge if you can find it.
Andy
September 19, 2001 at 7:27 pm
About the only thing I've found that even comes to close doesn't really. However, you may have a look at the operations guide:
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
September 20, 2001 at 8:18 am
Thanks guys! That was very toughtful.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply