I am getting this error message: SQL Network Interfaces, error: 26 -
Error Locating Server/Instance. I have talked with my hosting company
and they don't allow remote connections. Is there a work around code I
can put in my web.config file for this? Thanks

I have AS400 database attached as a linked server to my SQL2005:
EXEC master.dbo.sp_addlinkedserver @server = N'THE', @srvproduct=N'THE',
@provider=N'MSDASQL', @datasrc=N'THE'
"THE" is the ODBC DSN pointing to the specific ip.

I installed SQL 2005 with some settings which is below.
INSTANCE NAME: CAVCAV
Protocols For CAVCAV :
Shared Memory : Enabled