SQL 7.0 sp4 - hotfixed and broken

From: cauline (cauline.holdren@dot.state.fl.us)
Date: 01/30/03 

From: "cauline" <cauline.holdren@dot.state.fl.us>
Date: Thu, 30 Jan 2003 11:25:52 -0800

:/ 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: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot connect client to server 2003
    ... you need to reconfigure the IP schema of your SBS ... On the SBS 2003 Server open the Server Management console. ... On the Connection Type page, click Broadband, and then click Next. ... Alternate DNS server, type the IP addresses that are provided by your ISP ...
    (microsoft.public.windows.server.sbs)
  • Re: Connection failures
    ... similar to what query analyzer does at login if the object browser is ... certain it's not SQL related. ... Do you have any concurrent connection limits configured? ... the shares on the server and copy files off so there's nothing wrong ...
    (microsoft.public.sqlserver.clustering)
  • Re: Outgoing POP3 email missing/lost/not received
    ... ISP's mail server instead of the domain name on the ... SUMMARY OF SETTINGS FOR CONFIGURE E-MAIL AND INTERNET ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)
  • Re: Networking Question - VLANs on SBS 2003 Premium SP1
    ... port on the old router so I now have a segregated WLAN. ... be sure you do not enable any DHCP server in internal network. ... On the Connection Type page, click Broadband, and then click Next. ... On the Network Connection, You must enable and configure the network ...
    (microsoft.public.windows.server.sbs)