Searching Hosted MSSQL

I haven't found a solution for my current situation. So I hope someone has one for me.

I need the ability to search a hosted MSsql 2005 database. I have a database hosted and ALWAYS connected by ( lets say ) user1. I would like to connect to that database with either the same user or a newly created user if it must be required. Currently we can connect to the database from multiple locations with the same credentials and then that information is synchronized as needed.

We are currently using Teamviewer Manager to manage a hosted database. Teamviewer will search for its own session id or unique customer name but will not search any information entered into the customer information boxes. ( perhaps in a future release was what I was told ) I do not need read/write functionality just a way to search the database fields that contains needed information not searchable in Teamviewer

By searching the database we should be able to search for a portion of customer information and have all information contained under that customer.
I.E.

Customer name
ticket system 1
ticket system 2
email
phone number
address

By searching for email it would cross reference and show all information on that customer
or by searching ticket system 1 you can also find all information on that customer in the searcha

by hosted ... i mean....

example....

my.database.somewhere.net
mydatabase_name
user
password

I hope I am making sense. If anyone knows of a small program that will make that hosted database searchable I would appreciate a shove in the correct direction.

thanks.