web database dev

Novice doing OJT. I have a web page on a virtual server with a hosting company which offers sql server 7. My question is How do I connect to the database or do I have to have sql server 7 on my local machine and upload my database to the server?? Any help or direction would be greatly appreciated. Remember you once were naive.