Solution :
1. Go to C:\Windows\System32\drivers\etc
2. Open HOSTS File in notepad (Run as Admin)
3. Add below lines:
127.0.0.1 localhost
127.0.0.1 mycomputername -- this will be computer name
4. Save and close the notepad.
5. Connect SQL Server
Source:
http://blog.sqlauthority.com/2012/09/06/sql-server-fix-error-cannot-connect-to-login-failed-the-login-is-from-an-untrusted-domain-and-cannot-be-used-with-windows-authentication-microsoft-sql-server-error-18452/
1. Go to C:\Windows\System32\drivers\etc
2. Open HOSTS File in notepad (Run as Admin)
3. Add below lines:
127.0.0.1 localhost
127.0.0.1 mycomputername -- this will be computer name
4. Save and close the notepad.
5. Connect SQL Server
Source:
http://blog.sqlauthority.com/2012/09/06/sql-server-fix-error-cannot-connect-to-login-failed-the-login-is-from-an-untrusted-domain-and-cannot-be-used-with-windows-authentication-microsoft-sql-server-error-18452/
No comments:
Post a Comment