TITLE: Connect to Server
------------------------------

Cannot connect to RAGLAND\SQLEXPRESS.

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

Login failed for user 'Ragland\ragland'. (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
------------------------------

right click your SQL Server 20018 exe and running as administrator, I suspected this is UAC issue

for better answer I suggest you contact SQL Server forum

• Edited by britishdhez 37 minutes ago

right click your SQL Server 20018 exe and running as administrator, I suspected this is UAC issue

for better answer I suggest you contact SQL Server forum

• Edited by britishdhez Wednesday, April 01, 2015 6:42 AM

Hi Ragland,

Details

Product: SQL Server

ID: 18456

Source: MSSQLServer

Version: 10.0

Component: SQLEngine

Symbolic Name: LOGON_FAILED

Message: Login failed for user '%.*ls'.%.*ls

   

Explanation

When a connection attempt is rejected because of an authentication failure that involves a bad password or user name, a message similar to the following is returned to the client: "Login failed for user ''. (Microsoft SQL Server, Error: 18456)".

User Action

If you are trying to connect using SQL Server Authentication, verify that SQL Server is configured in Mixed Authentication Mode.

If you are trying to connect using SQL Server Authentication, verify that SQL Server login exists and that you have spelled it properly.

If you are trying to connect using Windows Authentication, verify that you are properly logged into the correct domain.

If your error indicates state 1, contact your SQL Server administrator.

Regarding to SQL server question, our help might be limited, we suggest you post your issue to following Forum for further support

https://social.technet.microsoft.com/Forums/en-US/home?category=sqlserver

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Regards

D. Wu