A network-related or instance-specific error occurred while establishing a connection to SQL Server

Question

Hi friends.

I am developing asp.net application where i have used foll. connection string:

<connectionStrings>

<add name="ConnectionString"  connectionString="Data Source=67.15.149.222;Initial Catalog=dbDemo;User ID=xxxx;Password=xxxxx;"  providerName="System.Data.SqlClient"/>

</connectionStrings>

  

This connection string runnig properly on localhost PC.
But when iam uploading website on server. it showing foll error:


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 



Plz help me out... it's urgent

Answer 1

Hi Jignesh,
use this for doing that.
string str = "welcome";
string newString = str.Substring(1, str.Length - 1) + str.Substring(0, 1);