We have an older product that we were running on MSDE and ran into a
database limit of 2GB. We are trying to move the TS Census DB to a sql
2005 remote server but having issues with having TS. Census connect to it.

Hopefully someone will be able to help answer a few questions:

Can I use a remote SQL server to host the database?

Can I use SQL 2005 or do I need SQL 2000?

In the option within the product, I select move datbase, but when I point
to the local datbase files, it says there is no tscensus files.

Any help would be appreciated.