I'm using VS 2005 connecting to a SQL 2000 DB on another server. The SQL is
also running IIS 6 with ASP.NET 2.0

When I test the aspx on my computer, it has no problem getting the
information from the SQL. Doing some research, I found I needed to run
aspnet_regsql.exe against my DB. I did and I now see the additional ASP
tables in my DB. I then went into the ASP.NET configuration and went to
Provider Management\Select a single provider for all site management data
and ran the TEST. I get the message "Successfully established a connection
to the database", but it does not work when I publish to this IIS server
running on the SQL? Like I said, it works fine when I debug it from my
computer. What else am I forgetting to get this to work.

All files were copied over to the IIS server correctly from what I can tell.

Thanks!

Newbie Phil