Solved

Problem while connecting to the SQL 2008 Server

Posted on 2011-03-17
3
273 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
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Backup & Restore 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.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

837 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