Re: Cannot login SQL Server with 'sa'

Michael ,

Thank you for your help.
It is enabled. I check my other two SQL Servers, they all have the same
problems.
Kai


"Michael Cheng [MSFT]" <v-mingqc@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:8qxTKFFCGHA.3992@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi Kai,
>
> Generally speaking, error code 18452 suggests SQL Authentication is not
> enabled. Would you please check to see whether it was enabled?
>
> - Right Click the instance name in the Object Explorer, select Properties
> - Select Security page and make sure SQL Server and Windows Authentication
> mode is selected.
>
>
> Sincerely yours,
>
> Michael Cheng
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>


.

Relevant Pages

  • Re: "Reinigung" einer grossen Datenbank
    ... von Michael wuerde ich gerne wissen, ob er es denn probiert hat. ... Alleine schon die Lernkurve bzgl. des SQL Servers rechtfertigt für das vorgestellte Problem nicht. ... Er hat nämlich keine Probleme bzgl. mangelnder Geschwindigkeit oder zu geringem SQL-Sprachumfang, oder dass er eine echte Client-Server-DB bräuchte. ...
    (microsoft.public.de.access)
  • Re: Enumerating Named Instances of SQL Server/MSDE
    ... Michael, se my posting in the thread ... Get all sql servers on network from dot net app.. ... > named instances. ...
    (microsoft.public.dotnet.languages.csharp)