Hey Derek,
They don't have to have a hosted website ... just IIS running on one of their servers. Then your connection string to SQL Server is in a web.config in the WebServices directory in IIS.
Whichever way you end up doing it, I also agree with Mike that you should use the SQL Server name rather than it's IP.
~~Bonnie
>Hi Bonnie!
>
>Not sure our clients will have a hosted website. I know they will have an SQL Server and T1 lines... Plus we're really looking to support one data protocol (c# .NET direct to SQL).
>
>If Microsoft SQL Server works the way the documentation states (IP address in Connection String and Encryption) then that solves remote connectivity issues in one shot!
>
>Do you know anyone using this?
>
>Thanks.