RE: Machine x receives results meant for machine y

Hi,
I understand that you found that your web server 2 sometimes recived a
result set from your SQL Server 2005 instance, however the result set
should have been destined for a connection on your web server 1.
If I have misunderstood, please let me know.

I do not believe that SQL Server 2005 would do this. I recommend that you
use SQL Profiler to monitor your SQL Server 2005 instance. From the trace
file, you can check the submitted T-SQL queries, spids, and client IP
addresses etc. One scenario I can imagine is that your client actually
submitted the same query from both of your web server 1 and web server 2.

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================



.

Relevant Pages

  • RE: Problems with WebParts
    ... to a database called aspnetdb. ... > The connection string specifies a local SQL Server Express instance using a ... > server account must have read and write access to the applications directory. ... > This is necessary because the web server account will automatically create ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Remote development advice
    ... We are using IIS as the web server. ... The IIS and SQL Server is setup in his ... I want to be able to access the pages that my friend has done remotely ... Then whichever web site he has configured as the default site on IIS should appear, assuming the web server was configured correctly. ...
    (microsoft.public.dotnet.general)
  • Re: SQL2K WIN2K3 CONNECTION SECURITY
    ... My own benchmarking indicates that TCP/IP is faster than named pipes. ... the benchmark stats as the starting point... ... Perfmon and SQL Server Profiler along with SQL Server Query Analyser. ... encrypted on the web server. ...
    (microsoft.public.security)
  • Re: connect to sql server on web server
    ... I want to connect to SQL Server on the web server from my workstation ... My workstation is in the same room as the web server but our network ... as a general networking question. ...
    (microsoft.public.sqlserver.connect)
  • Re: sometimes endless loop, sometimes not
    ... I couldn't afford a hosting with SQL server:) ... and ensure that row level locking isn't being disabled. ... >> to use it on my web server and moved to SQL Server when I started getting ...
    (microsoft.public.data.ado)
Loading