• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • 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
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.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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