SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication

May 6, 2008

In previous post I have mentioned about SQL SERVER 2005 – Vista Ultimate and SQL Server 2005 DEV Edition. There was one simple issue with the installation. I was not able to login using windows authentication method. I was able to successful login using sa username and password.

I kept on receiving following error.

TITLE: Connect to Server
——————————
Cannot connect to SQLAUTHORITY.
——————————
ADDITIONAL INFORMATION:

Login failed for user ‘SQLAUTHORITY\Pinal’. (Microsoft SQL Server, Error: 18456)

For help, click:

——————————
BUTTONS:
OK
——————————

After a while I realize that this may be due to one needs Administrator rights to do any task in SQL Server. I added the my current login as administrator in SQL Server and next time I was able to login successfully using Windows Authentication.

Following diagrams explains the fix.

1. Error while using Windows Authentication

2. Login using SA username and password and go to Security >> New Login

3. Type In Login Name as ComputerName\UserName

4. Click Server Roles and check sysadmin server role, after that click OK.

5. Now login using Windows Authentication and it should work fine.

Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Error Messages, SQL Server Security, Vista

SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension

SQL SERVER – Create Database Error in Windows Vista

SQL SERVER – Errorlog The Server was Unable to Initialize Encryption Because of a Problem with a Security Library

March 14, 2017

SQL SERVER – Msg 3168, Level 16 – The Backup of the System Database on the Device Cannot be Restored Because it was Created by a Different Version of the Server

June 23, 2017

SQL SERVER Data Tools – SSDT for Visual Studio 2017 Installation Error 0x80070002: Error 0x80070002: Failed to Acquire Payload

February 5, 2018

106 Comments. Leave new

Igzyy (@Igzyy)
October 10, 2011 4:58 pm

OK, thanks anyway..

now i try to create a new login (SQL express 2008R2 & SQL express 2005) , with the tips from the Pinal (above)

now….i get a new error ;

Create failed for Login ‘IGZYY-PCSQLEXPRESS05igorSQL’.

Windows NT user or group ‘IGZYY-PCSQLEXPRESS05igorSQL’ not found. Check the name again. (Microsoft SQL Server, Error: 15401)
———————————————————————————————-

> WTF!!!!

same thing with the creation of login (“sa” login , witch is ok) , i just can’t create a new login with the windows authority.

Please help

Reply
Igzyy (@Igzyy)
October 20, 2011 7:26 pm

THX all..

It was problem with virtual VMware , remember all internet propertis on virtual machine set to “default” and NAT bridget onnection…

Check with “ping” and shutdown firewall

that’s it…

Reply
APPY
December 6, 2011 10:42 am

This helped for Windows 7 too… Thanks a ton…

Reply
zehra
December 6, 2011 7:01 pm

thanks. it helped.

Reply
arun
February 27, 2012 7:29 pm

thanks….

Reply
srinath
March 1, 2012 9:49 pm

thank u

Reply
murtuza
June 13, 2012 5:10 pm

Thanks a lot it really worked with me.
i can connect to the sql server. Thanks.

Reply
amr
August 2, 2012 1:46 am

Thank you,

Reply
bhumika
December 19, 2012 10:44 am

thank you very much, this post was very useful for user like me ;)

Reply
Guru
December 25, 2012 9:09 am

thanx a lot

Reply
Guru
December 25, 2012 9:32 am

is there any other way to connect to the server in sql 2005 without using “run as administrator”

Reply