Problem while connecting to the SQL 2008 Server


I have created account with SQL Server Authentication type in Server Security folder, unchecked "Enforce Password Policy" option and assign "public" and" sysadmin" server roles.

When I tried to connect using this account I got next message:

TITLE: Connect to Server

Cannot connect to SQLServer.


Login failed for user 'act_user'. (Microsoft SQL Server, Error: 18456)

For help, click:



After that, I mapped it to database and assign dbo schema.

Anyway I cannot connect to SQL server using this account. (I can connect to the server using Windows account)

Can you please advise how to resolve this issue?

Thx in advance.
Who is Participating?
kamindaConnect With a Mentor Commented:
Does your sql server configured to use Mixed Mode authontication. Right Click on the server instanse and go to properties. under security tab you would see the settings.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
would reading this article help troubleshooting:
Muza01Author Commented:
Thanks to all.

First response has comprehensive information, but second is BINGO. I needed fast answer for my issue and got it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.