“don’t allow remote connections ” error

 In previous articles i explained how to solve a network related or instance specific error .If we get error like “don’t allow remote connections ”or A connection was successfully established with the server, but then an error occurred during the login process in sql server 2005,we have to change the remote connections ,we have to change the Remote Connections in sql server.

Do the below steps to resolve this issue:
1.Goto MicrosoftSqlServer2005->Configuration Tools
2.select SqlServer Surface Area Configuration

3.select the data base what you have used in sytem

4.Then select the remote connection.Here we can see three options,In these we have to select using both TCP/IP and names pipes