connections remote SQLExpress

22 Dec 2005 8:31 AM

EWAT

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

22 Dec 2005 12:52 PM

Andrew J. Kelly

You need to run the Surface Area Configuration tool and enable Remote
connections.

--
Andrew J. Kelly SQL MVP

Show quote

"EWAT" <eaba***@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
>

23 Dec 2005 5:30 AM

Roger Wolter[MSFT]

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

Show quote

"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" <eaba***@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
>>
>
>