If you had developed a VS 2005 project containing ADOX references on a Win XP machine and moved the project to a Vista machine, VS 2005 may not  access to ADOX reference. Then you’ll need  to use the “tlbimp.exe” (Type Library Importer) tool which is shipped with Visual Studio 2005 (full path is “\Microsoft […]

Read More → Moving a Visual Studio 2005 project containing ADOX references from XP to Vista may fail with ADOX references

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