Trouble Uploading to remote site from VS

I am working on my first asp.net website. I designed the site to use SQL Server 2005 and user authentication (the site is not public).

Unfortunately, the remote SQL Server 2005 and the authentication scheme does not work once the site is online.

I am able to access the remote database from my local machine but it is not being accessed online. Also, the authentication worked on the local machine but is not working online. (I looked into the tables created by the regsql.exe as specified in a KB article and the tables are empty of users i created)

Can someone guide me through the process of enabling the SQL Server to work with the site and for the authentication to work.

the site is only a test at this time so if i need to redo it no problem and use another method or perhaps i missed steps in the method i did use.

thank you for any help

willie

 

Conn str

Thanks,
That is the KB article which i have already used to modify the web config.
it appears that there is something else i am missing but am not knowledgable enough to know what it is i am not doing...

willie

 

There is also a Step-by-step Webcast for this:
http://iis7test.com/webcasts/