Re: Cannot login SQL Server with 'sa'


Is it possible you're trying to connect multiple times over the dedicated
Admin connection?

--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com


"kai" <kailiang@xxxxxxxxxxxxx> wrote in message
news:jB_qf.9068$3Z.3336@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> 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: authentication error
    ... this account is not given access to SQL Server; ... Adding "Integrated Security=false" to your connection string will turn this ... > I've been having a problem connecting to my sql 2000 server database. ... > Under the defaults menu I've set the database to Andrew. ...
    (microsoft.public.sqlserver.connect)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: One Script, multiple DBs
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I can change the connection that the ExecuteSQL task points to. ... > read them in to change the one connection properties? ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: No data in Sql 2005 tehre is data in sql 2000
    ... a connection string. ... > Thanks for replying, Andrew. ... >>> I developed a windows application that connects to Sql server 2000, ... >>> windows authentication and it works, able to retrive and other data ...
    (microsoft.public.sqlserver.connect)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)