Solved

Problem while connecting to the SQL 2008 Server

Posted on 2011-03-17
3
278 Views
Last Modified: 2012-05-11
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
Comment
Question by:Muza01
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35154375
would reading this article help troubleshooting:
http://www.experts-exchange.com/A_1881.html
0
 
LVL 9

Accepted Solution

by:
kaminda earned 125 total points
ID: 35154417
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
 

Author Closing Comment

by:Muza01
ID: 35154730
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question