October 20, 2006 at 6:27 am
Hello, everyone.
Situation is very simple. 2 SQL 2000 servers both with SP4, in the same network segment (perfectly visible to each other), let's call them S1 and S2. Neither of them has Kerberos installed. Both servers are properly registered with MSTDC.
1. On S1 I added S2 as linked server.
2. On S2 I added a login specifically for use with link from S1. It's SQL authentication only, having dbo privileges on a database (let's call it Database2) on S2.
3. On S1 in linked server properties (security tab) I added this login with correct password for "Connection be made using this security context"
Now, when I try to execute any query from S1, for example:
SELECT * FROM S2.Database2.dbo.table2
I get the following error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface returned 0x80004005: The provider did not give any information about the error.].
Which is not very descriptive...
I tried everything. Including using Windows authentication users mapped to existing logins (I cannot use impersonating due to absence of Kerberos, obviously). I dropped and re-created logins and linked servers, you name it... Still the same error.
Maybe someone has some experience with it?
Thanks and good luck, everyone.
October 20, 2006 at 11:07 am
What version of the operating system, including the operating system service pack, are you running on each server? If you are running Windows Server 2003, there were fundamental changes to DTC that causes you to have issues you wouldn't have seen in Windows 2000. An article you'll want to take a look at:
How to enable network DTC in Windows Server 2003
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply