SQL 2000 in a shared web hosting environment

  • ralphy

    SSC Rookie

    Points: 27

    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,

  • Andy Warren

    SSC Guru

    Points: 119694

    Only advice I can offer is to give them the minimum privileges possible.

    Andy

  • ralphy

    SSC Rookie

    Points: 27

    Yeah but, but What about the network architecture, the delegated administration, any ideas?

  • Andy Warren

    SSC Guru

    Points: 119694

    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

  • K. Brian Kelley

    SSC Guru

    Points: 114486

    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:

    http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp

    K. Brian Kelley

    bk@warpdrivedesign.org

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • ralphy

    SSC Rookie

    Points: 27

    Thanks guys! That was very toughtful.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply