"shivaranjaniadimula***@gmail.com" wrote:

> hi all,
> I trying to connect remote sql server from my machine. but
> it giving me some errors
>
> Here are few errors listed,
> 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
> connection to SQL Server))
>
> 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: SQL Network Interfaces, error: 26 - Error
> Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
>
> A connection was successfully established with the server, but then
> an error occurred during the pre-login handshake.  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: 0 - No process is on the other
> end of the pipe.) (Microsoft SQL Server, Error: 233)
>
> A connection was successfully established with the server, but then
> an error occurred during the login process.(provider:  Named Pipes
> Provider, error: 0 - No process is on the other end of the pipe.)
>
> To solve this problem I did following changes in SQL server
>
> Enable the TCP/IP protocol using the Surface Area Configuration
> Utility
> Make sure the TCP/IP protocol is enabled in the SQL Server
> Configuration Utility
> start SQL Server browser
> Exceptions are added in Firewall
> Restart the computer
>
>         But still I am getting same errors.
> Please give me some solution for this problem....
> Thanks in advance.
>
>