Remote Connection Error: Named Pipes Provider error

hbansal · April 11th, 2009, 11:17 AM

Hello Friends

Error Desciption:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Error says problem in remote connection...I have checked dozen of posts of net, giving remedies of remote connection, which is not helping my cause. I have followed each and every step of remote connection, the connection is already enabled. But still the problem persists. Friends please help. I have to submit my major project, all was done until this problem happened. Please solve my problem urgently, please. Some posts say there is a problem in connection string.

Here is the code:

public void connected()

{

con = new SqlConnection("data source=CR32; trusted_connection=yes; database=credit_scoring");

//con.Open();

}

public int login()

{

connection obj = new connection();

obj.connected();

obj.con.Open();

obj.cmd = new SqlCommand("proclogin",obj.con);

obj.cmd.CommandType = CommandType.StoredProcedure;

obj.cmd.Parameters.AddWithValue("acc",acc_no);

obj.cmd.Parameters.AddWithValue("pass",pass);

SqlParameter sp = new SqlParameter();

sp.ParameterName = "@count";

sp.DbType = DbType.Int32;

sp.Direction = ParameterDirection.Output;

obj.cmd.Parameters.Add(sp);

obj.cmd.ExecuteNonQuery();

int flag = Convert.ToInt32(sp.Value);

return flag;

}

Friends I have made a dll file and calling the class of this file to use the above two functions. I think the problem is in datasource, please tell me the appropriate remedy. I have tried of setting datasource as local, but still the problem persists.

gbianchi · April 11th, 2009, 01:07 PM

Please don't cross post

hbansal · April 11th, 2009, 02:36 PM

Thanks Sir. Please solve my query, I will remember of not cross posting in future.

gbianchi · April 11th, 2009, 05:11 PM

I will not "solve" it. I will try to help solve it. Anyway, I already said something on the other thread.

hbansal · April 12th, 2009, 01:36 AM

I have seen that thread, the link mentioned doesn't exist. I have configured remote connection on my PC, but still the problem persists.

gbianchi · April 12th, 2009, 09:51 AM

My question was about this code:

connection obj = new connection();

obj.connected();

obj.con.Open();

This can't be working, there is no connection associated to obj.