Tuesday, March 20, 2012

connections remote SQLExpress

how I can connect remotely to SQLExpress?.. I have enabled TCP/IP, but it
does not work.
error:
...
When connecting to SQL server 2005m this failure may be caused by the fact
the under the default settings SQL server does not allow remote
connections (provider SQL Network Interfaces, error 26 error, locating
server/instance specified).
.....
...
thanksYou need to run the Surface Area Configuration tool and enable Remote
connections.
Andrew J. Kelly SQL MVP
"EWAT" <eabarca@.medinet-igd.com> wrote in message
news:OM3KqItBGHA.2920@.tk2msftngp13.phx.gbl...
> how I can connect remotely to SQLExpress?.. I have enabled TCP/IP, but it
> does not work.
>
> error:
> ...
> When connecting to SQL server 2005m this failure may be caused by the
> fact the under the default settings SQL server does not allow remote
> connections (provider SQL Network Interfaces, error 26 error, locating
> server/instance specified).
> .....
> ...
> thanks
>|||Since SQL Express installs with a named instance, you also need to enable
and start the SQLBROWSER service.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23j1qbavBGHA.1180@.TK2MSFTNGP09.phx.gbl...
> You need to run the Surface Area Configuration tool and enable Remote
> connections.
> --
> Andrew J. Kelly SQL MVP
>
> "EWAT" <eabarca@.medinet-igd.com> wrote in message
> news:OM3KqItBGHA.2920@.tk2msftngp13.phx.gbl...
>

No comments:

Post a Comment