Dazed & Confused

I have an application running on 2 w2k3 servers, each running IIS. (These
servers sit behind a load balancer.) Each server needs to connect to a
database on a remote server. The connection string to the remote server is
stored on another SQL server in the same LAN as the IIS servers; the
applications on the IIS servers retrieve the connection string before
attempting to connect. One IIS server connects without incident, but the
other consistently does not connect. The error message on the Remote SQL
server in the Application Event log is “Error: 17832, Severity: 20, State: 9
Connection opened but invalid login packet(s) sent. Connection closed.”
To really confound the problem, I can connect to the remote server from the
troubled IIS server using SQL Managment Studio.

I’ve checked the dlls on both IIS servers – all are identical versions. I
compared the executable for Size & Last Modified Date – they are the same,
too. The dlls & executables were written in VB 6.
Rebooting has resolved nothing.
I didn’t capture anything helpful with SQL Profiler on the SQL server – it
showed no errors. I tried to see what’s happening with NetMon, but SQL
connections are ‘forced encryption’ on the SQL server, so I wasn’t able to
see what was in the login packets.
I’m at a loss for the next steps to investigate. Any suggestions?

.

Relevant Pages

  • Re: Web and SQL Security
    ... Your connection string needs to be a low privileged account. ... SQL auth is never recommended, ... Therefore web app communicates with the SQL server using ...
    (microsoft.public.sqlserver.security)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • how to configure ms sql server 2k and windows server 2k in order to sql from remote computer (with v
    ... My local database (under ms sql server 2000, ... database using a connection string with the ADODB VB object. ...
    (microsoft.public.sqlserver.connect)
  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... I wen to the Sybase site and found a reference to Connection String ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
Loading