• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

Problem while connecting to the SQL 2008 Server

Hi,

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.

------------------------------
ADDITIONAL INFORMATION:

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

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.
0
Muza01
Asked:
Muza01
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
would reading this article help troubleshooting:
http://www.experts-exchange.com/A_1881.html
0
 
kamindaCommented:
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.
0
 
Muza01Author Commented:
Thanks to all.

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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now