Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rehn
Starting Member
2 Posts |
 Posted - 2008-10-15 : 16:26:52
|
| I have an SQL 2000 server. I have configured a linked server connecting to an ODBC source. When trying to query the linked server from a third system I get the following error.[OLE/DB provider returned message: Unable to find CDD. File not found. (\\tampa\cddlib\NWSMWT.cdd) Error Code=(5) UserName=(REHN\myusername)]OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' reported an error.The vendor(Connx) of the ODBC driver used to build the connection between the SQL server and the external data assisted me with the necessary setup to do a Double Hop connection (delegated Kerberos connection) which works fine on our development SQL server. In production I am getting this error. Any ideas? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-15 : 16:28:27
|
| Maybe your production server is not setup for Security account delegation(delegated Kerberos connection). |
 |
|
|
rehn
Starting Member
2 Posts |
Posted - 2008-10-15 : 18:39:04
|
| Shoot! Sorry, I should have explained a bit more. Setting that up was part of what the ODBC driver vendor had me do. They took me through this process http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspxThe problem is that Kerberos authentication is not working with this one server. I do not know why. One thing I did notice is that the DNS entry for the server is different then the other SQL servers I have. Each server has DNS security entery for domain\servername except this one. There was a security entry that displayed as its SID so I wonder if this server some how has a different SID. Not sure how to recover from this. |
|
|
|
|
|
|
SQL Double Hop