Re: Windows 2003 server automatically close down TCP/IP listening for SQL
From: Stephen Dybing [MSFT] (stephd_at_online.microsoft.com)
Date: 05/19/04
- Next message: Stephen Dybing [MSFT]: "Re: compile"
- Previous message: Joe M: "2 servers, 2 lans, 1 SQL"
- In reply to: George: "Re: Windows 2003 server automatically close down TCP/IP listening for SQL"
- Next in thread: George: "Re: Windows 2003 server automatically close down TCP/IP listening for SQL"
- Reply: George: "Re: Windows 2003 server automatically close down TCP/IP listening for SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 May 2004 15:39:38 -0700
So that means you didn't actually install SQL Server SP3a. 8.00.0194 is the
original release version with no service packs or hotfixes applied.
The default service pack install directory is c:\sql2ksp3 but there is no
molap subdirectory. It looks to me like you downloaded and installed
Analysis Service SP3a, or sql2kasp3.exe. That does happen to be the first
file listed on the download page,
http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en#filelist,
and it's easy to make that mistake if you don't read the text carefully.
What you really want is the third file listed, sql2ksp3.exe. The middle one,
sql2kdesksp3.exe is the MSDE update
-- Hope this helps, Stephen Dybing This posting is provided "AS IS" with no warranties, and confers no rights. "George" <crc@ms1.hinet.net> wrote in message news:%23AuBxIdPEHA.3012@TK2MSFTNGP09.phx.gbl... > Thank you for your reply , But I really setup the sp3a from the unpacked > directory (under the msolap-->install) , "select @@version" returns > "8.00.194 (intelX86) Aug6 2000 00:57:48" > > > I apologize in advance if this sounds like I'm talking down to you, but > you > > did install the service pack and not just download and unpack it, right? > > When you download the file and run it, it only unpacks the files, it > doesn't > > actually install anything. There's a setup.exe program in the directory > you > > unpacked the service pack into that needs to be run to install the service > > pack. To really make sure that you've got it installed, what does "select > > @@version" return? It should say 8.00.0760.09 if SP3a is installed > properly. > > > > -- > > Sincerely, > > Stephen Dybing > > > >
- Next message: Stephen Dybing [MSFT]: "Re: compile"
- Previous message: Joe M: "2 servers, 2 lans, 1 SQL"
- In reply to: George: "Re: Windows 2003 server automatically close down TCP/IP listening for SQL"
- Next in thread: George: "Re: Windows 2003 server automatically close down TCP/IP listening for SQL"
- Reply: George: "Re: Windows 2003 server automatically close down TCP/IP listening for SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|