Topic
  • 1 reply
  • Latest Post - ‏2010-12-15T17:22:46Z by Staar
Staar
Staar
2 Posts

Pinned topic Database Interface Designer - SQL connection with windows authentication

‏2010-12-15T00:19:36Z |
For some reason when I try to connect to a database it's trying to use the incorrect user to connect to the database. In the config settings I'm using MS SQL Server/Windows. I left the User ID/Password blank since I want it to use Windows Authentication. I'm able to select the Server/Database I'm trying to connect to, but when I use the connection in a map, it always fails. In the map I'm calling it like this:
DBLookup("exec dbo.<Procedure Name> '<Param1>','<Param2>','<Param3>'", "<Path to mdq file>", "<Database Name in MDQ>: -T")

The trace indicates that it's using Windows Authentication, but later shows that it was trying to connect with the NT AUTHORITY\ANONYMOUS user. Any thoughts on how to fix this and make it use windows authentication? The worst part is that the map completes successfully, when in fact it never called the stored procedure and received results.

<344-3680>: Validating the adapter command...
<344-3680>: Database type is MS SQL Server
<344-5560>: Connecting...
<344-5560>: Datalink: <Server>\\<Database>
<344-5560>: UserId :
<344-5560>: Password: *****
<344-5560>: DBLOOKUP Function, Transaction scope: Map
<344-5560>: TRACE command specified, file: Build_File.dbl
<344-5560>: Using Windows integrated security
<344-5560>: Local transaction usage: Transaction ID 0x2FEE62A0
<344-5560>: Transaction started - ISOLATIONLEVEL_READCOMMITTED
<344-5560>: Connection to SQL Server <Server> has been established.
<344-5560>: Retrieving 1 rows per fetch.
<344-5560>: Returned status: (0) Success
<344-5560>: Interface library version 8.3.0.2(23)
<344-5560>: Map: <Compiled Map Location>, Timestamp: 12/14/10 17:54:4
<344-5560>: Data being retrieved for DBLOOKUP function.
<344-5560>: Database adapter: OLE DB / SQL7 Version 8.3.0.2(23)
<344-5560>: Starting a database unload...
<344-5560>: Datalink: <Server>\\<Database>
<344-5560>: UserId :
<344-5560>: Password: *****
<344-5560>: Query : exec dbo.<Procedure Name> '<Param1>','<Param2>','<Param3>'
<344-5560>: DBLOOKUP Function, Transaction scope: Map
<344-5560>: TRACE command specified, file: <Path to trace file>
<344-5560>: Retrieving 1 rows per fetch.
<344-5560>: OLE DB Error code: 0x80040e14
<344-5560>: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
<344-5560>: Returned status: (-6) No error text found
<344-5560>: Cleaning up and closing the transaction...
<344-5560>: Returned status: (0) Success

Any thoughts?
Updated on 2010-12-15T17:22:46Z at 2010-12-15T17:22:46Z by Staar
  • Staar
    Staar
    2 Posts

    Re: Database Interface Designer - SQL connection with windows authentication

    ‏2010-12-15T17:22:46Z  
    Turns out the network cable connected to the machine went bad. It must try to connect with an ANONYMOUS account if it's unsuccessful using windows authentication. Once a new cable was used, the problem went away...