I have an express instance setup and I can connect on that pc using windows
authentication and sql authentication using the SA account. However, I can't
login using the SA account from another computer on the same lan.

Named Pipex, TCPIP and SQL browser are on/running.

I'm guessing that perhaps the SA user doesn't allow login from remote so
that's why I'm asking how to make another user

instance name mypcname/sqlexpress
SA/topsecret

Hello,

Enable the remote connection using the SQL Server surface area
configuration. You could test the remote connection using TELNET and
see if you can listen to SQL Server

TELNET <IPDARRESS> Port#

Thanks
Hari

"Rob" <nospam@nospam.com> wrote in message
news:%23BJy9RFtHHA.3364@TK2MSFTNGP02.phx.gbl...
>I have an express instance setup and I can connect on that pc using windows
>authentication and sql authentication using the SA account. However, I
>can't login using the SA account from another computer on the same lan.
>
> Named Pipex, TCPIP and SQL browser are on/running.
>
> I'm guessing that perhaps the SA user doesn't allow login from remote so
> that's why I'm asking how to make another user
>
> instance name mypcname/sqlexpress
> SA/topsecret
>

I checked, using the surface config. it already shows remote connections
allowed through tcpip and named pipes.

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:O2FoQAItHHA.2752@TK2MSFTNGP06.phx.gbl...
> Hello,
>
> Enable the remote connection using the SQL Server surface area
> configuration. You could test the remote connection using TELNET and
> see if you can listen to SQL Server
>
> TELNET <IPDARRESS> Port#
>