Re: Cannot login SQL Server with 'sa'

Andrew,
Thanks for your help. I checked it, it is enabled. I found additional
error when I login second time:

"Login failed for user 'sa'.The user is associated with a trusted SQL Server
connection. (Microsoft SQL Server, error: 18452)

Kai
"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:%23pGIiaACGHA.736@xxxxxxxxxxxxxxxxxxxxxxx
> 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: different environment fails to fill a dataset
    ... Well I recreated the login but it didn't make any difference. ... Andrew J. Kelly SQL MVP ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)