" 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) "
Plz help me i try all things
Enable remote connections on the instance of SQL Server that you want
to connect to from a remote computer.
Turn on the SQL Server Browser service.
Configure the firewall to allow network traffic that is related to SQL
Server and to the SQL Server Browser service
but still error occur

Plz help me

*** Sent via Developersdex http://www.codecomments.com ***Are you able to connect to SQL Server Management studio and exeute simple
queries like SP_WHO and all?
If no; then verify the network connectivity from host to server.
Thanks
Hari
"hossam mohamed" <hosshoss2@.yahoo.com> wrote in message
news:umAN$vEBHHA.2140@.TK2MSFTNGP02.phx.gbl...
> when i try to attach file there is an error occur
> " 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) "
>
> Plz help me i try all things
> . Enable remote connections on the instance of SQL Server that you want
> to connect to from a remote computer.
> . Turn on the SQL Server Browser service.
> . Configure the firewall to allow network traffic that is related to SQL
> Server and to the SQL Server Browser service
>
> but still error occur

> Plz help me

> *** Sent via Developersdex http://www.codecomments.com ***
No comments:
Post a Comment