"George" <crc@ms1.hinet.net> wrote in message
news:OrytR8TPEHA.4008@TK2MSFTNGP09.phx.gbl...
> I installed a SQL 2000 (with service pack 3a) on a Windows 2003 server ,
> but Windows 2003 server still automatically close down TCP/IP listening
for
> SQL ; I reinstalled both 2003 server and SQL server with sp3a again , But
I
> am still not able to open that listening , any idea ?
>
>

"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
> >
>
>

> 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
>

> 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.
>

Stephen Dybing [MSFT] wrote:
> *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, i
> doesn't
> actually install anything. There's a setup.exe program in th
> directory you
> unpacked the service pack into that needs to be run to install th
> service
> pack. To really make sure that you've got it installed, what doe
> "select
> @@version" return? It should say 8.00.0760.09 if SP3a is installe
> properly.
>
> --
> Sincerely,
> Stephen Dybing
>
> This posting is provided "AS IS" with no warranties, and confers n
> rights.
>
> "George" <crc@ms1.hinet.net> wrote in message
> news:OrytR8TPEHA.4008@TK2MSFTNGP09.phx.gbl...
> > I installed a SQL 2000 (with service pack 3a) on a Windows 200
> server ,
> > but Windows 2003 server still automatically close down TCP/I
> listening
> for
> > SQL ; I reinstalled both 2003 server and SQL server with sp3a agai
> , But
> I
> > am still not able to open that listening , any idea ?
> >
> >