We have a site that upon every page load, it tries to contact a sql server on the local machine. It does not contact localhost, but the actual IP of the local machine. It fails, then contacts the correct DB server for membership information.
In dev, apparently the server was contacting the local sqlexpress server, then contacting the correct DB as well. Only when we stopped the localmachine dev SQLExpress could we recreate the issue. We had removed entries in machine.config, and web.config
to .\sqlexpress, but the problem still persists.
Oddly, the system works, it is just very slow because on every page load, it contacts this phantom sql server. A netstat shows 192.168.1.100 SYN-SENT everytime.
techstaff
0 Points
1 Post
Odd Behaviour- .net site tries to contact a local sql server first (Causes delays on page loads)
Apr 07, 2010 07:42 PM|LINK
Hello,
We have a site that upon every page load, it tries to contact a sql server on the local machine. It does not contact localhost, but the actual IP of the local machine. It fails, then contacts the correct DB server for membership information.
In dev, apparently the server was contacting the local sqlexpress server, then contacting the correct DB as well. Only when we stopped the localmachine dev SQLExpress could we recreate the issue. We had removed entries in machine.config, and web.config to .\sqlexpress, but the problem still persists.
Oddly, the system works, it is just very slow because on every page load, it contacts this phantom sql server. A netstat shows 192.168.1.100 SYN-SENT everytime.
Any ideas?
asp .net 2. 0 sql server timeout
ammd
Participant
1349 Points
257 Posts
Re: Odd Behaviour- .net site tries to contact a local sql server first (Causes delays on page loa...
Apr 08, 2010 03:45 AM|LINK
One of your devs must have hard-coded the connection string somewhere in the code, do a file search to find the ip.
Hope this helps.