Unable to connect with integrated security in ASP.NET MVC3

Connectivity
Enthusiast

Unable to connect with integrated security in ASP.NET MVC3

I have an ASP.NET MVC3 application that uses integrated security.  I have both the driver and the Teradata.Client.Provider.dll and the Teradata.Net.Security.Tdgss.dll in my bin directory.  I am unable to connect to the TeraData database. 

[Teradata Database] [8017] The UserId, Password or Account is invalid.

Here is my connection string in my web.config:

<add name ="AMAPSDatabase" connectionString="Data Source=myDatabase;Integrated Security=true;"/>

Here is my code that I am using to connect:

TdConnection conn = new TdConnection
{
ConnectionString = ConfigurationManager.ConnectionStrings["AMAPSDatabase"].ToString()
};
conn.Open();

Do I need to have the Teradata Driver installed on the web server or are the TeraData drivers managed code and the XCopy deployment is okay?  Why wouldn't it be able to connect if the web application is integrated security?

1 REPLY
Enthusiast

Re: Unable to connect with integrated security in ASP.NET MVC3

Okay, the fix for the above issue is adding this to the web.config:

<identity impersonate="true"/>

See this article on MSDN that is for SQL Server that works with with TeraData:

http://msdn.microsoft.com/en-us/library/bsz5788z%28v=vs.100%29.aspx