Thursday 14 July 2016

Login Falied : The Login is from an untrsuted domain for SQL Error.


Today, i followed Microsoft article to create it a SQL alias.

After creating an SQL alias in SQL configuration manager.

When i opened  SSMS and try to login with New SQL Alias name got hit by below error.


I got above error if authentication is Windows but if a changed to SQL server authentication was able to connect the new SQL Alias without any issue


Troubleshooting:-

1. Ping the new SQL Alias name was getting response.

2. Checked the DNS entry.

3. Checked for error in event viewer and found " SSPI handshaked Failed" in application log


Solution:-

DisableLoopBackCheck

We have to create Disable loop back check in registry editor.
Powershell to create it.

New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -Value "1" -PropertyType dword

We can created it manaully by following below steps:-

1. Ctrl + R type Regedit hit enter.
2.EXPAND "HKEY_LOCAL_MACHINE \SYSTEM\CONTROLSET001\CONTROL\LSA"
3. Right Click on LSA, New and click DWORD32.
4. Give name to it DisableLoopbackCheck, modify the value to 1.


After this i was able to login with New SQL Alias using windows authentication.

Happy SharePointing :)





No comments:

Post a Comment