how to create sql user for remote login?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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


.

Relevant Pages

  • Weakness introduced by denying remote logins on AIX, possibly others
    ... AIX 4.3.3 and AIX 5.1, ... is possible to remotely enumerate the passwords of a known AIX account. ... believed to be in the response from the login program after authentication ... Give accounts that have been restricted from remote logins strong passwords. ...
    (Security-Basics)
  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: AD Security Groups break Authentication
    ... I can do a domain login using my own account & a couple others, but one specific account can't login. ... My ping testing showed that 1430 was the highest MTU setting that wouldn't result in fragmentation. ... As soon as the network engineers changed the MTU from the default of 1500 to 1400, all domain traffic stopped and they detected a ton of errors, so we restored the MTU to 1500. ...
    (microsoft.public.windows.server.active_directory)
  • Need example of working PAM.CONF file that enables ssh login using winbind and AD
    ... login into my system using ssh. ... (explicit because of pam_rhost_auth) ... # Default definitions for Authentication management ... cron account required ...
    (SunManagers)
  • Re: AD Security Groups break Authentication
    ... It would take 15+ minutes to login and there was a 1-2 minute delay each time we tried to access resources. ... account only in Domain Users, indicates something else is surely going ... We tried reducing the MTU on our routers this morning to 1400. ... Microsoft network server: Digitally sign communications ...
    (microsoft.public.windows.server.active_directory)