Re: Cannot login SQL Server with 'sa'

Do you have Shared Memory connections enabled? Run the SQL Server
Configuration Manager and look at the protocols and shared Memory to see if
it is enabled or not.

--
Andrew J. Kelly SQL MVP


"kai" <kailiang@xxxxxxxxxxxxx> wrote in message
news:5HZqf.9593$nm.595@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
> After I setup 'sa' password in SQL Server 2005, I get out SQL Server and
> re-login using SQL Authentication mode with 'sa' and pasword, I get error:
>
> "A connection was successfully established with the server, but then the
> error occured during the login process. (Provider: Shared memeoryprovider,
> error 0 - No process is on the other end of the pipe.) (Microsoft SQL
> Server : error 233)"
>
> Please help
>
> Thanks
>
> kai
>


.

Relevant Pages

  • RE: Shared Memory Provider error
    ... I tried the lpc sqlcmd and indeed got an error: ... Shared Memory Provider: The Shared Memory dll used to connect to SQL Server ... An error has occurred while establishing a connection to the server. ...
    (microsoft.public.sqlserver.connect)
  • RE: Shared Memory Provider error
    ... when we try to connect by the "sqlcmd -S lpc" command. ... Shared Memory is enabled in the SQL Server Configuration Manager. ... I assume that the SQL Server is installed on the default path. ... Microsoft Global Technical Support Center ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server 2K connection is interrupted regularly, why ?
    ... I've never had connectivity problems at start up of a remote connection. ... > I found that if I turned of Shared Memory in the Client Configuration ... stop and restart SQL Server. ...
    (microsoft.public.sqlserver.connect)
  • Re: sqlclient: existing connection was forcibly closed
    ... I saw that post regarding flipping off Shared Memory. ... The box that runs my SQL Server instance also runs a series of processes ... Windows Server 2003 sp2 ...
    (microsoft.public.sqlserver.clients)
  • RE: Shared Memory Provider error
    ... "Connection was successfully established with the server, ... (provider: Shared Memory Provider, ... Server 2005 Express Edition and SQL Server 2005 Developer Edition do not ... However, if this issue still persists, let's try LPC for shared memory ...
    (microsoft.public.sqlserver.connect)