Re: SQL 7.0 sp4 - hotfixed and broken

From: Djana Milton [MS] (djanam@online.microsoft.com)
Date: 01/30/03 

From: "Djana Milton [MS]" <djanam@online.microsoft.com>
Date: Thu, 30 Jan 2003 14:05:14 -0800

Errorlog, please. You might also want to re-enable named pipes and ensure
that your max connections setting of 1 didn't take. 

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Djana O.C. Milton
SQL Server PM
"cauline" <cauline.holdren@dot.state.fl.us> wrote in message
news:085e01c2c895$6703f4b0$cef82ecf@TK2MSFTNGXA08...
> :/  After copying the recommended files and running
> securityhotfix.sql in Query Analyzer, I get the
> message, "Unable to connect to server \\myservername
> Server: Msg 14, Level 16, State 1  [Microsoft][ODBC SQL
> Server Driver][Named Pipes]Invalid Connection."
>
> I know that in the server properties in Enterprise
> Manager, I changed the Max user connections to 1, but
> cancelled due to the warning message. This was just prior
> to running the script.  Now I cannot use Query Analyzer,
> Enterprise Manager, osql after starting sqlservr.exe -c -f
> or the application that depends on SQL Server.  Oh, I also
> ran cliconfg to change from named pipes to TCP/IP.  I'm
> running in circles and getting lost.
>
> Thanks for any help you might be able to give me.

Relevant Pages

  • Re: Upgraded Win2K/ SQL 2K to Win2K3, is now one big mess
    ... TCP/IP and named pipes are both enabled, ... The TCP/IP and Named Pipe protocols need to be enabled. ... > I installed Small Business Server at home, ... the existing server connections still ...
    (microsoft.public.sqlserver.odbc)
  • Re: Number of active http requests keep growing
    ... in our Enterprise Manager 10g, the number of active HTTP connections and ... requests keep growing at a rate of 16/minute. ... about 200 connections, most ESTABLISHED, some TIME_WAIT. ... Are you using an application server and/or a connection manager? ...
    (comp.databases.oracle.server)
  • Re: TCP connections suddenly failing.
    ... do you have a lot of .Net client application connections? ... Microsoft SQL Server MVP ... it back online and that resolved the TCP connect issue. ... >> Connections are instant and lovely using named pipes. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Number of active http requests keep growing
    ... For the picture, look here: ... do you know of a group dedicated to Enterprise Manager? ... We are using an Application Server. ... about 200 connections, most ESTABLISHED, some TIME_WAIT. ...
    (comp.databases.oracle.server)
  • Re: Local named pipes better than TCP/IP?
    ... I'd like to stress that we're having the client and server on the same ... "Local named pipes runs in kernel mode and is extremely fast" ( ... > of shared memory for local connections and TCP/IP for remote connections. ...
    (microsoft.public.sqlserver.connect)