I've developed one asp.internet application with sql servor 2008 that has also used the net services. It's runnig perfectly in localhost however when i attempt to host it on the internet (Free hostinng sits www.somee.com). I acquired error

Server was not able to process request. ---> A network-related or instance-specific error happened while creating an association to SQL Server. The server wasn't found or wasn't accessible. Verify the instance title is correct which SQL Server is set up to permit remote connections. (provider: Named Pipes Provider, error: 40 - Couldn't open an association to SQL Server)

i've already transformed the MS sql conncetion string towards the provided connection string through the webhost and web service address from local host towards the hosting directory. Can there be something more i have to do ?..could u help me..saying thanks to u ahead of time

Regards

Kamal

Book your connection string and i believe you need to speak to your host company about correct connection string. Please look at this blog publish too:

How to Resolve Error 40

Hope it will help.