Re: Cannot login SQL Server with 'sa'
- From: v-mingqc@xxxxxxxxxxxxxxxxxxxx (Michael Cheng [MSFT])
- Date: Sat, 24 Dec 2005 06:14:20 GMT
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.
.
- Follow-Ups:
- Re: Cannot login SQL Server with 'sa'
- From: kai
- Re: Cannot login SQL Server with 'sa'
- References:
- Cannot login SQL Server with 'sa'
- From: kai
- Re: Cannot login SQL Server with 'sa'
- From: Andrew J. Kelly
- Re: Cannot login SQL Server with 'sa'
- From: kai
- Cannot login SQL Server with 'sa'
- Prev by Date: Re: Cannot login SQL Server with 'sa'
- Next by Date: Re: Cannot add new Database Diagrams
- Previous by thread: Re: Cannot login SQL Server with 'sa'
- Next by thread: Re: Cannot login SQL Server with 'sa'
- Index(es):