IIS7.5 unable to connect to SQL server using 32 bit odbc.
We are upgrading our server from windows 2000 and IIS6 to windows 2008 R2 and IIS7.5. Earlier our SQL DB was on same machine. But now we are configuring it on a seperate windows 2008 R2 machine. So, we configured 32 bit version of ODBC to access SQL server. It uses windows authentication (it must use as per client requirement). IIS7.5 is configured to use windows authentication(it uses domain ID and this also a must as per client requirement). When ASP try to access sql server it is fething following error(even though ASP and IIS is design/configure to save login detail): Number Of Errors = 1 SQL State = 28000 Error #-2147217843 Description: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. NativeError: 18456 Reported by: Microsoft OLE DB Provider for ODBC Drivers Connection = DSN=sopnmui_systf5 Error Number = -2147217843 Error Description = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Error Source = Microsoft OLE DB Provider for ODBC Drivers We verified in the same ASP, it had session detail and able to print on screen. Have no idea how it translate from windows authentication to Anonymous. I check following link and whatever it sugest, it is already configured: http://vladimir.remenar.net/running-classic-asp-on-iis7/
July 3rd, 2012 10:15am

Which account is the Application Pool running under which is attempting the logon? also what are the settings for the DSN that you're calling?Doug Kentner
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2012 11:37am

IIS forum would be the best place to ask this question. http://forums.iis.net/1041.aspxPress any key... What the ... Where's any key ? This posting is provided "AS IS" with no warranties or guarantees and confers no rights. About Me ?
July 3rd, 2012 12:36pm

Application pool is running using NetworkServices but I tried also with ApplicationPoolIdentity. Setting for DNS I am using are: Physical Path Credential: ClearText Protocol: http. Can you please be particular about which setting for DNS you are asking for?
Free Windows Admin Tool Kit Click here and download it now
July 5th, 2012 7:59am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics