A connection was successfully established with the server, but

[pandapatin]

the error is this : A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) its stuck when its come to Myconn.open(). whats wrong with this code? conMyData = New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString")) cmdSelect = New SqlCommand("sp_ValidateUser", conMyData) cmdSelect.CommandType = CommandType.StoredProcedure parmReturnValue = cmdSelect.Parameters.Add("RETURN_VALUE", SqlDbType.Int) parmReturnValue.Direction = ParameterDirection.Input cmdSelect.Parameters.Add("@noPekerja", SqlDbType.VarChar) cmdSelect.Parameters.Add("@pWord", SqlDbType.VarChar) conMyData.Open() cmdSelect.ExecuteNonQuery() intResult = cmdSelect.Parameters("RETURN_VALUE").Value conMyData.Close()

[Dave Kreskowiak]

Troubleshooting: No Process is on the Other End of the Pipe[^] on MSDN. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

[pandapatin]

i enable the pipe name protocols but there is a new error. A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) could u check my code pliz : conMyData = New SqlConnection(ConfigurationManager.AppSettings("psmConnectionString")) cmdSelect = New SqlCommand("sp_ValidateUser", conMyData) cmdSelect.CommandType = CommandType.StoredProcedure parmReturnValue = cmdSelect.Parameters.Add("RETURN_VALUE", SqlDbType.Int) parmReturnValue.Direction = ParameterDirection.Input cmdSelect.Parameters.Add("@noPekerja", SqlDbType.VarChar) cmdSelect.Parameters.Add("@pWord", SqlDbType.VarChar) conMyData.Open() cmdSelect.ExecuteNonQuery() intResult = cmdSelect.Parameters("RETURN_VALUE").Value conMyData.Close() If intResult < 0 Then If intResult = -1 Then lblMessage.Text = "Username Not Registered!" Else lblMessage.Text = "Invalid Password!" End If End If

[Dave Kreskowiak]

There's nothing wrong with the code. Your connection string is either messed up, or you still have configuration issues with your SQL Server. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome