SQL.NET connection error in Active Directory

This has been driving me crazy for past few days so I hope there is an
answer here...

We are moving from NT to AD and the web app that used to work fine
stopped working with following errors: SQL Server does not exist or
access denied.

I am using Windows authentication as it's an intranet app and recently
enabled identity impersonation to true...

Here is the kicker though. Whatever I do ( I tried impersonation
method here: http://www.15seconds.com/issue/040511.htm ), I always end
up getting that SQL connection error unless...

1. log into the server
2. open the web config
3. save without changing anything
4. log on to localhost of the site

Then it works... and I can get online from other machines as well.

Obviously I can't log onto localhost every minute as it will time
out... and it seems to be application cache problem... but.. why is it
doing this and how can I solve it?

Any solution is welcome although less change to the code would be
nice.

Help~!

John

.

Relevant Pages

  • SQL.NET connection error in Active Directory
    ... SQL Server does not exist or ... enabled identity impersonation to true... ... up getting that SQL connection error unless... ... Obviously I can't log onto localhost every minute as it will time ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Starter kit will not install no localhost connection
    ... there should be no any SQL Server Service running on your machine. ... telnet localhost 1433 ... In the command prompt, ... osql -S localhost -E (If this works, you installation will be OK) ...
    (microsoft.public.sqlserver.setup)
  • Re: Using SQL on Development Machine
    ... Note that (localhost) worked on my other computer and I see localhost used in several examples. ... If I right-click on the database in the Server Explorer and select the Modify Connection command, I see 'Use Windows Authentication' is selected, for which I obviously have correct authentication. ... SQL Server 2005 Services ... TCP/IP = Disabled ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error: SQL Server does not exist or access denied
    ... > I'm accessing the server using LOCALHOST as suggested by ASPFAQ. ... If you are running SQL Server or MSDE on the same machine as your ASP pages, ... Did you try 127.0.0.1, the local network name,, ., the local IP ...
    (microsoft.public.inetserver.asp.db)