Tag: linked server
Accessing Excel files on a x64 machine
In the old times while all the CPUs were 32bit, we were happily using JET OLEDB Provider reaching Excel or MDB files for long time without any issues. After we started using x64 CPUs and x64 Windows machines, we noticed that JET OLEDB Provider is not working. The reason for this was x64 Windows operating […]
Read More → Accessing Excel files on a x64 machineHow to set up a Kerberos Authentication Scenario with SQL Server Linked Servers
Let’s say you’ve got a SQL Server (KIRK) containing a linked server against another SQL Server (SCOTTY) and you’re connecting the KIRK from remote client machine (SPOCK) using SQL Server Management Studio and receiving the error message below when you executed a query involving the linked server : “Error 18456: Login failed for user ‘NT […]
Read More → How to set up a Kerberos Authentication Scenario with SQL Server Linked Servers