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

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

SQL SERVER 2005 - FIX Error: 18456 : VISTA Windows Authentication vistaauth

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

SQL SERVER 2005 - FIX Error: 18456 : VISTA Windows Authentication vistaauth1

3. Type In Login Name as ComputerName\UserName

SQL SERVER 2005 - FIX Error: 18456 : VISTA Windows Authentication vistaauth2

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

SQL SERVER 2005 - FIX Error: 18456 : VISTA Windows Authentication vistaauth3

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

SQL SERVER 2005 - FIX Error: 18456 : VISTA Windows Authentication vistaauth4

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

, ,
Previous Post
SQL SERVER – Find Table in Every Database of SQL Server – Part 2 Extension
Next Post
SQL SERVER – Create Database Error in Windows Vista

Related Posts

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
  • This helped for Windows 7 too… Thanks a ton…

    Reply
  • thanks. it helped.

    Reply
  • thanks….

    Reply
  • thank u

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

    Reply
  • Thank you,

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

    Reply
  • thanx a lot

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

    Reply

Leave a Reply