Error Message "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

My name is Archana CM from Microsoft SQL Developer Support team, we support SQL Connectivity issue along with data access technologies and SSIS. I had chance to work with SQL DBA who was having issues while connecting to his SQL server machine. We have seen many issue with connectivity to SQL but the solution we…

32

SQL BULK COPY ERROR (“Operating system error code 5(Access is denied.)”)

  While there are various forms of bulk copy this blog specifically deals with copying data from a file into SQL Server. It deals about the specific error “Operating system error code 5(Access is denied.)” which might crop up under certain circumstances when doing a bulk copy. For a while now I worked with a…

14

Testing connection to SQL Server from a service running under Local System Account

  We sometimes run into scenarios where an application or a windows service running under Local System Account needs to connect to SQL Server and encounter authentication Errors/issues with SQL Server. In SQL Developer support team, we have worked on customer issues where SCCM (System Center Configuration Manager), SCOM (System Center Operations Manager) or a…

3

How to grant ReadServicePrincipalName and WriteServicePrincipalName rights to SQL Server service start-up account without using ADSDIEDIT tool.

I hope you probably know how to fix below different authentication related errors that can occur while connecting to SQL Server with Windows Integrated Authentication.   1.       Login failed for user ‘(null)‘. Reason: Not associated with a trusted SQL Server connection. 2.       Login Failed for user ‘NT Authority\ANONYMOUS’ LOGON 3.       Login Failed for user ‘…

4

SQL Connectivity errors related to SPN and troubleshooting them.

You might get the following error when there is any issue related to a SPN in the environment: 1) Login failed for user ‘null’ 2) Login failed for user ‘’ 3) Login failed for user ‘NT Authority\Anonymous Logon‘ 4) Cannot generate SSPI context We get these errors when we use windows authentication and there is…

3