Hello,
Thinking about synchronous hardware based mirroring using EMCs clariion
product line over a dedicated fiber connection between two geographically
separate data centers. I realize that there is a basic speed of light issue
here regarding the distance I can have between the two sites and still keep
my servers synched real-time.
Would someone please shed some more light on what is involved here? What's
the maximum distance I can have betwen these sites and why? Any other
caveats with this setup I should be aware of? Thanks.
BTW - running an OLTP environment SQL2000.
I don't believe that these solutions are truly synchronous, and second its
way slower than the speed of light.
The most significant factors are price and skill set required. If you think
replication is tough wait till you get behind EMC's SRDF.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mb" <mb@.discussions.microsoft.com> wrote in message
news:8AB9A09B-325B-4A59-9C54-1CC65BD1348B@.microsoft.com...
> Hello,
> Thinking about synchronous hardware based mirroring using EMCs clariion
> product line over a dedicated fiber connection between two geographically
> separate data centers. I realize that there is a basic speed of light
issue
> here regarding the distance I can have between the two sites and still
keep
> my servers synched real-time.
> Would someone please shed some more light on what is involved here?
What's
> the maximum distance I can have betwen these sites and why? Any other
> caveats with this setup I should be aware of? Thanks.
> BTW - running an OLTP environment SQL2000.
|||I'm curious why you state the hardware mirroring is not truly synchronous?
It was my understanding that if distances were kept under a certain limit
then this solution could be considered to be essentially synchronous.
Oh, just got your replication book Hilary - great read!
"Hilary Cotter" wrote:
> I don't believe that these solutions are truly synchronous, and second its
> way slower than the speed of light.
> The most significant factors are price and skill set required. If you think
> replication is tough wait till you get behind EMC's SRDF.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "mb" <mb@.discussions.microsoft.com> wrote in message
> news:8AB9A09B-325B-4A59-9C54-1CC65BD1348B@.microsoft.com...
> issue
> keep
> What's
>
>
|||My understanding from EMC is that there are two modes. 1) Synchronous and 2)
asynchronous.
In the Synchronous mode, data is written to the source and the app receives
the commit. Then under the covers the write is written to the destination.
So, its not a true split write. Asynchronous has queuing built in.
Let me check with my EMC rep and confirm this.
Glad you like the book!
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"mb" <mb@.discussions.microsoft.com> wrote in message
news:1910F129-8553-42BA-BD15-8B8517D9BC0B@.microsoft.com...[vbcol=seagreen]
> I'm curious why you state the hardware mirroring is not truly synchronous?
> It was my understanding that if distances were kept under a certain limit
> then this solution could be considered to be essentially synchronous.
> Oh, just got your replication book Hilary - great read!
> "Hilary Cotter" wrote:
its[vbcol=seagreen]
think[vbcol=seagreen]
clariion[vbcol=seagreen]
geographically[vbcol=seagreen]
Showing posts with label hardware. Show all posts
Showing posts with label hardware. Show all posts
Sunday, February 19, 2012
Tuesday, February 14, 2012
Catch22
Hi all,
Our SQL server hardware died and we bought a new server with Windows 2003
server. We have the SQL 2000 CD and the CD with service pack 3a.
When we try to install SQL 2000 we get the warning that anything below SP3
is not supported on W2003 and the installation fails at the server
configuration. We can start the server but starting the Agent fails. We
thought that we might win and tried to run SP3 anyhow but the install stops
with the message that there is no SQL installed.
Does anybody have an idea how we get around this? We searched the KB and
didn't come up with anything.
Thanks for your help
ClausYou will need to download and apply SP3a in order for SQL Server 2000 to
work properly.
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>|||Sorry.. short read your message. Try uninstalling SQL Server, reboot,
re-install SQL Server, apply SP3 -before- restarting again.
"Morgan" <abcd@.senditon.com> wrote in message
news:ubUybFHaEHA.2488@.tk2msftngp13.phx.gbl...
> You will need to download and apply SP3a in order for SQL Server 2000 to
> work properly.
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > Our SQL server hardware died and we bought a new server with Windows
2003
> > server. We have the SQL 2000 CD and the CD with service pack 3a.
> > When we try to install SQL 2000 we get the warning that anything below
SP3
> > is not supported on W2003 and the installation fails at the server
> > configuration. We can start the server but starting the Agent fails. We
> > thought that we might win and tried to run SP3 anyhow but the install
> stops
> > with the message that there is no SQL installed.
> >
> > Does anybody have an idea how we get around this? We searched the KB and
> > didn't come up with anything.
> >
> > Thanks for your help
> > Claus
> >
> >
>|||You can install past the warning. SQL agent will fail since Windows 2003
disables the network libraries on any installation below SP3. Start and
stop the SQL server instance once after the base install. You can then
install SP3a. Once SP3a is installed, everything should be fine. You may
have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
work correctly.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>|||Geoff/Morgan
The SQL installation fails at the server configuration. No SQL instance is
present and SP3 will not install because it doesn't find the server. When I
searched the KBs I did find one that said if the server name is small or
mixed letters it could fail. I renamed the server all caps but the problem
is still the same.
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> You can install past the warning. SQL agent will fail since Windows 2003
> disables the network libraries on any installation below SP3. Start and
> stop the SQL server instance once after the base install. You can then
> install SP3a. Once SP3a is installed, everything should be fine. You may
> have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
> work correctly.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > Our SQL server hardware died and we bought a new server with Windows
2003
> > server. We have the SQL 2000 CD and the CD with service pack 3a.
> > When we try to install SQL 2000 we get the warning that anything below
SP3
> > is not supported on W2003 and the installation fails at the server
> > configuration. We can start the server but starting the Agent fails. We
> > thought that we might win and tried to run SP3 anyhow but the install
> stops
> > with the message that there is no SQL installed.
> >
> > Does anybody have an idea how we get around this? We searched the KB and
> > didn't come up with anything.
> >
> > Thanks for your help
> > Claus
> >
> >
>|||Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
Standard Edition on Windows 20003 Standard Edition. If you have an Open or
Select license you can download the correct version, otherwise you will
probably have to contact Microsoft directly for a media refresh. SQL 2000a
is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
patched DLL and allow you to install correectly. YOu will still have to
install SP3a, but you should at least get past where you are stuck now.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Geoff/Morgan
> The SQL installation fails at the server configuration. No SQL instance is
> present and SP3 will not install because it doesn't find the server. When
I
> searched the KBs I did find one that said if the server name is small or
> mixed letters it could fail. I renamed the server all caps but the problem
> is still the same.
> Claus
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > You can install past the warning. SQL agent will fail since Windows
2003
> > disables the network libraries on any installation below SP3. Start and
> > stop the SQL server instance once after the base install. You can then
> > install SP3a. Once SP3a is installed, everything should be fine. You
may
> > have to get refreshed media (SQL 2000a) for the install on Windows 2003
to
> > work correctly.
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "cjobes" <cjobes@.nova-tech.org> wrote in message
> > news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > >
> > > Our SQL server hardware died and we bought a new server with Windows
> 2003
> > > server. We have the SQL 2000 CD and the CD with service pack 3a.
> > > When we try to install SQL 2000 we get the warning that anything below
> SP3
> > > is not supported on W2003 and the installation fails at the server
> > > configuration. We can start the server but starting the Agent fails.
We
> > > thought that we might win and tried to run SP3 anyhow but the install
> > stops
> > > with the message that there is no SQL installed.
> > >
> > > Does anybody have an idea how we get around this? We searched the KB
and
> > > didn't come up with anything.
> > >
> > > Thanks for your help
> > > Claus
> > >
> > >
> >
> >
>|||Thanks,
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kGzetHaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
> Standard Edition on Windows 20003 Standard Edition. If you have an Open
or
> Select license you can download the correct version, otherwise you will
> probably have to contact Microsoft directly for a media refresh. SQL
2000a
> is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
> patched DLL and allow you to install correectly. YOu will still have to
> install SP3a, but you should at least get past where you are stuck now.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > Geoff/Morgan
> >
> > The SQL installation fails at the server configuration. No SQL instance
is
> > present and SP3 will not install because it doesn't find the server.
When
> I
> > searched the KBs I did find one that said if the server name is small or
> > mixed letters it could fail. I renamed the server all caps but the
problem
> > is still the same.
> >
> > Claus
> >
> > "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> > news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > > You can install past the warning. SQL agent will fail since Windows
> 2003
> > > disables the network libraries on any installation below SP3. Start
and
> > > stop the SQL server instance once after the base install. You can
then
> > > install SP3a. Once SP3a is installed, everything should be fine. You
> may
> > > have to get refreshed media (SQL 2000a) for the install on Windows
2003
> to
> > > work correctly.
> > >
> > > --
> > > Geoff N. Hiten
> > > Microsoft SQL Server MVP
> > > Senior Database Administrator
> > > Careerbuilder.com
> > >
> > > I support the Professional Association for SQL Server
> > > www.sqlpass.org
> > >
> > > "cjobes" <cjobes@.nova-tech.org> wrote in message
> > > news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > Hi all,
> > > >
> > > > Our SQL server hardware died and we bought a new server with Windows
> > 2003
> > > > server. We have the SQL 2000 CD and the CD with service pack 3a.
> > > > When we try to install SQL 2000 we get the warning that anything
below
> > SP3
> > > > is not supported on W2003 and the installation fails at the server
> > > > configuration. We can start the server but starting the Agent fails.
> We
> > > > thought that we might win and tried to run SP3 anyhow but the
install
> > > stops
> > > > with the message that there is no SQL installed.
> > > >
> > > > Does anybody have an idea how we get around this? We searched the KB
> and
> > > > didn't come up with anything.
> > > >
> > > > Thanks for your help
> > > > Claus
> > > >
> > > >
> > >
> > >
> >
> >
>
Our SQL server hardware died and we bought a new server with Windows 2003
server. We have the SQL 2000 CD and the CD with service pack 3a.
When we try to install SQL 2000 we get the warning that anything below SP3
is not supported on W2003 and the installation fails at the server
configuration. We can start the server but starting the Agent fails. We
thought that we might win and tried to run SP3 anyhow but the install stops
with the message that there is no SQL installed.
Does anybody have an idea how we get around this? We searched the KB and
didn't come up with anything.
Thanks for your help
ClausYou will need to download and apply SP3a in order for SQL Server 2000 to
work properly.
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>|||Sorry.. short read your message. Try uninstalling SQL Server, reboot,
re-install SQL Server, apply SP3 -before- restarting again.
"Morgan" <abcd@.senditon.com> wrote in message
news:ubUybFHaEHA.2488@.tk2msftngp13.phx.gbl...
> You will need to download and apply SP3a in order for SQL Server 2000 to
> work properly.
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > Our SQL server hardware died and we bought a new server with Windows
2003
> > server. We have the SQL 2000 CD and the CD with service pack 3a.
> > When we try to install SQL 2000 we get the warning that anything below
SP3
> > is not supported on W2003 and the installation fails at the server
> > configuration. We can start the server but starting the Agent fails. We
> > thought that we might win and tried to run SP3 anyhow but the install
> stops
> > with the message that there is no SQL installed.
> >
> > Does anybody have an idea how we get around this? We searched the KB and
> > didn't come up with anything.
> >
> > Thanks for your help
> > Claus
> >
> >
>|||You can install past the warning. SQL agent will fail since Windows 2003
disables the network libraries on any installation below SP3. Start and
stop the SQL server instance once after the base install. You can then
install SP3a. Once SP3a is installed, everything should be fine. You may
have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
work correctly.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>|||Geoff/Morgan
The SQL installation fails at the server configuration. No SQL instance is
present and SP3 will not install because it doesn't find the server. When I
searched the KBs I did find one that said if the server name is small or
mixed letters it could fail. I renamed the server all caps but the problem
is still the same.
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> You can install past the warning. SQL agent will fail since Windows 2003
> disables the network libraries on any installation below SP3. Start and
> stop the SQL server instance once after the base install. You can then
> install SP3a. Once SP3a is installed, everything should be fine. You may
> have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
> work correctly.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > Hi all,
> >
> > Our SQL server hardware died and we bought a new server with Windows
2003
> > server. We have the SQL 2000 CD and the CD with service pack 3a.
> > When we try to install SQL 2000 we get the warning that anything below
SP3
> > is not supported on W2003 and the installation fails at the server
> > configuration. We can start the server but starting the Agent fails. We
> > thought that we might win and tried to run SP3 anyhow but the install
> stops
> > with the message that there is no SQL installed.
> >
> > Does anybody have an idea how we get around this? We searched the KB and
> > didn't come up with anything.
> >
> > Thanks for your help
> > Claus
> >
> >
>|||Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
Standard Edition on Windows 20003 Standard Edition. If you have an Open or
Select license you can download the correct version, otherwise you will
probably have to contact Microsoft directly for a media refresh. SQL 2000a
is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
patched DLL and allow you to install correectly. YOu will still have to
install SP3a, but you should at least get past where you are stuck now.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Geoff/Morgan
> The SQL installation fails at the server configuration. No SQL instance is
> present and SP3 will not install because it doesn't find the server. When
I
> searched the KBs I did find one that said if the server name is small or
> mixed letters it could fail. I renamed the server all caps but the problem
> is still the same.
> Claus
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > You can install past the warning. SQL agent will fail since Windows
2003
> > disables the network libraries on any installation below SP3. Start and
> > stop the SQL server instance once after the base install. You can then
> > install SP3a. Once SP3a is installed, everything should be fine. You
may
> > have to get refreshed media (SQL 2000a) for the install on Windows 2003
to
> > work correctly.
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "cjobes" <cjobes@.nova-tech.org> wrote in message
> > news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > >
> > > Our SQL server hardware died and we bought a new server with Windows
> 2003
> > > server. We have the SQL 2000 CD and the CD with service pack 3a.
> > > When we try to install SQL 2000 we get the warning that anything below
> SP3
> > > is not supported on W2003 and the installation fails at the server
> > > configuration. We can start the server but starting the Agent fails.
We
> > > thought that we might win and tried to run SP3 anyhow but the install
> > stops
> > > with the message that there is no SQL installed.
> > >
> > > Does anybody have an idea how we get around this? We searched the KB
and
> > > didn't come up with anything.
> > >
> > > Thanks for your help
> > > Claus
> > >
> > >
> >
> >
>|||Thanks,
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kGzetHaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
> Standard Edition on Windows 20003 Standard Edition. If you have an Open
or
> Select license you can download the correct version, otherwise you will
> probably have to contact Microsoft directly for a media refresh. SQL
2000a
> is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
> patched DLL and allow you to install correectly. YOu will still have to
> install SP3a, but you should at least get past where you are stuck now.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > Geoff/Morgan
> >
> > The SQL installation fails at the server configuration. No SQL instance
is
> > present and SP3 will not install because it doesn't find the server.
When
> I
> > searched the KBs I did find one that said if the server name is small or
> > mixed letters it could fail. I renamed the server all caps but the
problem
> > is still the same.
> >
> > Claus
> >
> > "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> > news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> > > You can install past the warning. SQL agent will fail since Windows
> 2003
> > > disables the network libraries on any installation below SP3. Start
and
> > > stop the SQL server instance once after the base install. You can
then
> > > install SP3a. Once SP3a is installed, everything should be fine. You
> may
> > > have to get refreshed media (SQL 2000a) for the install on Windows
2003
> to
> > > work correctly.
> > >
> > > --
> > > Geoff N. Hiten
> > > Microsoft SQL Server MVP
> > > Senior Database Administrator
> > > Careerbuilder.com
> > >
> > > I support the Professional Association for SQL Server
> > > www.sqlpass.org
> > >
> > > "cjobes" <cjobes@.nova-tech.org> wrote in message
> > > news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > Hi all,
> > > >
> > > > Our SQL server hardware died and we bought a new server with Windows
> > 2003
> > > > server. We have the SQL 2000 CD and the CD with service pack 3a.
> > > > When we try to install SQL 2000 we get the warning that anything
below
> > SP3
> > > > is not supported on W2003 and the installation fails at the server
> > > > configuration. We can start the server but starting the Agent fails.
> We
> > > > thought that we might win and tried to run SP3 anyhow but the
install
> > > stops
> > > > with the message that there is no SQL installed.
> > > >
> > > > Does anybody have an idea how we get around this? We searched the KB
> and
> > > > didn't come up with anything.
> > > >
> > > > Thanks for your help
> > > > Claus
> > > >
> > > >
> > >
> > >
> >
> >
>
Catch22
Hi all,
Our SQL server hardware died and we bought a new server with Windows 2003
server. We have the SQL 2000 CD and the CD with service pack 3a.
When we try to install SQL 2000 we get the warning that anything below SP3
is not supported on W2003 and the installation fails at the server
configuration. We can start the server but starting the Agent fails. We
thought that we might win and tried to run SP3 anyhow but the install stops
with the message that there is no SQL installed.
Does anybody have an idea how we get around this? We searched the KB and
didn't come up with anything.
Thanks for your help
Claus
You will need to download and apply SP3a in order for SQL Server 2000 to
work properly.
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>
|||Sorry.. short read your message. Try uninstalling SQL Server, reboot,
re-install SQL Server, apply SP3 -before- restarting again.
"Morgan" <abcd@.senditon.com> wrote in message
news:ubUybFHaEHA.2488@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> You will need to download and apply SP3a in order for SQL Server 2000 to
> work properly.
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
2003[vbcol=seagreen]
SP3
> stops
>
|||You can install past the warning. SQL agent will fail since Windows 2003
disables the network libraries on any installation below SP3. Start and
stop the SQL server instance once after the base install. You can then
install SP3a. Once SP3a is installed, everything should be fine. You may
have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
work correctly.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>
|||Geoff/Morgan
The SQL installation fails at the server configuration. No SQL instance is
present and SP3 will not install because it doesn't find the server. When I
searched the KBs I did find one that said if the server name is small or
mixed letters it could fail. I renamed the server all caps but the problem
is still the same.
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> You can install past the warning. SQL agent will fail since Windows 2003
> disables the network libraries on any installation below SP3. Start and
> stop the SQL server instance once after the base install. You can then
> install SP3a. Once SP3a is installed, everything should be fine. You may
> have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
> work correctly.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
2003[vbcol=seagreen]
SP3
> stops
>
|||Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
Standard Edition on Windows 20003 Standard Edition. If you have an Open or
Select license you can download the correct version, otherwise you will
probably have to contact Microsoft directly for a media refresh. SQL 2000a
is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
patched DLL and allow you to install correectly. YOu will still have to
install SP3a, but you should at least get past where you are stuck now.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Geoff/Morgan
> The SQL installation fails at the server configuration. No SQL instance is
> present and SP3 will not install because it doesn't find the server. When
I[vbcol=seagreen]
> searched the KBs I did find one that said if the server name is small or
> mixed letters it could fail. I renamed the server all caps but the problem
> is still the same.
> Claus
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
2003[vbcol=seagreen]
may[vbcol=seagreen]
to[vbcol=seagreen]
> 2003
> SP3
We[vbcol=seagreen]
and
>
|||Thanks,
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kGzetHaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
> Standard Edition on Windows 20003 Standard Edition. If you have an Open
or
> Select license you can download the correct version, otherwise you will
> probably have to contact Microsoft directly for a media refresh. SQL
2000a[vbcol=seagreen]
> is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
> patched DLL and allow you to install correectly. YOu will still have to
> install SP3a, but you should at least get past where you are stuck now.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
is[vbcol=seagreen]
When[vbcol=seagreen]
> I
problem[vbcol=seagreen]
> 2003
and[vbcol=seagreen]
then[vbcol=seagreen]
> may
2003[vbcol=seagreen]
> to
below[vbcol=seagreen]
> We
install
> and
>
Our SQL server hardware died and we bought a new server with Windows 2003
server. We have the SQL 2000 CD and the CD with service pack 3a.
When we try to install SQL 2000 we get the warning that anything below SP3
is not supported on W2003 and the installation fails at the server
configuration. We can start the server but starting the Agent fails. We
thought that we might win and tried to run SP3 anyhow but the install stops
with the message that there is no SQL installed.
Does anybody have an idea how we get around this? We searched the KB and
didn't come up with anything.
Thanks for your help
Claus
You will need to download and apply SP3a in order for SQL Server 2000 to
work properly.
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>
|||Sorry.. short read your message. Try uninstalling SQL Server, reboot,
re-install SQL Server, apply SP3 -before- restarting again.
"Morgan" <abcd@.senditon.com> wrote in message
news:ubUybFHaEHA.2488@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> You will need to download and apply SP3a in order for SQL Server 2000 to
> work properly.
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
2003[vbcol=seagreen]
SP3
> stops
>
|||You can install past the warning. SQL agent will fail since Windows 2003
disables the network libraries on any installation below SP3. Start and
stop the SQL server instance once after the base install. You can then
install SP3a. Once SP3a is installed, everything should be fine. You may
have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
work correctly.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>
|||Geoff/Morgan
The SQL installation fails at the server configuration. No SQL instance is
present and SP3 will not install because it doesn't find the server. When I
searched the KBs I did find one that said if the server name is small or
mixed letters it could fail. I renamed the server all caps but the problem
is still the same.
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> You can install past the warning. SQL agent will fail since Windows 2003
> disables the network libraries on any installation below SP3. Start and
> stop the SQL server instance once after the base install. You can then
> install SP3a. Once SP3a is installed, everything should be fine. You may
> have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
> work correctly.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
2003[vbcol=seagreen]
SP3
> stops
>
|||Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
Standard Edition on Windows 20003 Standard Edition. If you have an Open or
Select license you can download the correct version, otherwise you will
probably have to contact Microsoft directly for a media refresh. SQL 2000a
is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
patched DLL and allow you to install correectly. YOu will still have to
install SP3a, but you should at least get past where you are stuck now.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Geoff/Morgan
> The SQL installation fails at the server configuration. No SQL instance is
> present and SP3 will not install because it doesn't find the server. When
I[vbcol=seagreen]
> searched the KBs I did find one that said if the server name is small or
> mixed letters it could fail. I renamed the server all caps but the problem
> is still the same.
> Claus
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
2003[vbcol=seagreen]
may[vbcol=seagreen]
to[vbcol=seagreen]
> 2003
> SP3
We[vbcol=seagreen]
and
>
|||Thanks,
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kGzetHaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
> Standard Edition on Windows 20003 Standard Edition. If you have an Open
or
> Select license you can download the correct version, otherwise you will
> probably have to contact Microsoft directly for a media refresh. SQL
2000a[vbcol=seagreen]
> is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
> patched DLL and allow you to install correectly. YOu will still have to
> install SP3a, but you should at least get past where you are stuck now.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
is[vbcol=seagreen]
When[vbcol=seagreen]
> I
problem[vbcol=seagreen]
> 2003
and[vbcol=seagreen]
then[vbcol=seagreen]
> may
2003[vbcol=seagreen]
> to
below[vbcol=seagreen]
> We
install
> and
>
Catch22
Hi all,
Our SQL server hardware died and we bought a new server with Windows 2003
server. We have the SQL 2000 CD and the CD with service pack 3a.
When we try to install SQL 2000 we get the warning that anything below SP3
is not supported on W2003 and the installation fails at the server
configuration. We can start the server but starting the Agent fails. We
thought that we might win and tried to run SP3 anyhow but the install stops
with the message that there is no SQL installed.
Does anybody have an idea how we get around this? We searched the KB and
didn't come up with anything.
Thanks for your help
ClausYou will need to download and apply SP3a in order for SQL Server 2000 to
work properly.
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>|||Sorry.. short read your message. Try uninstalling SQL Server, reboot,
re-install SQL Server, apply SP3 -before- restarting again.
"Morgan" <abcd@.senditon.com> wrote in message
news:ubUybFHaEHA.2488@.tk2msftngp13.phx.gbl...
> You will need to download and apply SP3a in order for SQL Server 2000 to
> work properly.
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
2003[vbcol=seagreen]
SP3[vbcol=seagreen]
> stops
>|||You can install past the warning. SQL agent will fail since Windows 2003
disables the network libraries on any installation below SP3. Start and
stop the SQL server instance once after the base install. You can then
install SP3a. Once SP3a is installed, everything should be fine. You may
have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
work correctly.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>|||Geoff/Morgan
The SQL installation fails at the server configuration. No SQL instance is
present and SP3 will not install because it doesn't find the server. When I
searched the KBs I did find one that said if the server name is small or
mixed letters it could fail. I renamed the server all caps but the problem
is still the same.
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> You can install past the warning. SQL agent will fail since Windows 2003
> disables the network libraries on any installation below SP3. Start and
> stop the SQL server instance once after the base install. You can then
> install SP3a. Once SP3a is installed, everything should be fine. You may
> have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
> work correctly.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
2003[vbcol=seagreen]
SP3[vbcol=seagreen]
> stops
>|||Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
Standard Edition on Windows 20003 Standard Edition. If you have an Open or
Select license you can download the correct version, otherwise you will
probably have to contact Microsoft directly for a media refresh. SQL 2000a
is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
patched DLL and allow you to install correectly. YOu will still have to
install SP3a, but you should at least get past where you are stuck now.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Geoff/Morgan
> The SQL installation fails at the server configuration. No SQL instance is
> present and SP3 will not install because it doesn't find the server. When
I
> searched the KBs I did find one that said if the server name is small or
> mixed letters it could fail. I renamed the server all caps but the problem
> is still the same.
> Claus
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
2003[vbcol=seagreen]
may[vbcol=seagreen]
to[vbcol=seagreen]
> 2003
> SP3
We[vbcol=seagreen]
and[vbcol=seagreen]
>|||Thanks,
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kGzetHaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
> Standard Edition on Windows 20003 Standard Edition. If you have an Open
or
> Select license you can download the correct version, otherwise you will
> probably have to contact Microsoft directly for a media refresh. SQL
2000a
> is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
> patched DLL and allow you to install correectly. YOu will still have to
> install SP3a, but you should at least get past where you are stuck now.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
is[vbcol=seagreen]
When[vbcol=seagreen]
> I
problem[vbcol=seagreen]
> 2003
and[vbcol=seagreen]
then[vbcol=seagreen]
> may
2003[vbcol=seagreen]
> to
below[vbcol=seagreen]
> We
install[vbcol=seagreen]
> and
>
Our SQL server hardware died and we bought a new server with Windows 2003
server. We have the SQL 2000 CD and the CD with service pack 3a.
When we try to install SQL 2000 we get the warning that anything below SP3
is not supported on W2003 and the installation fails at the server
configuration. We can start the server but starting the Agent fails. We
thought that we might win and tried to run SP3 anyhow but the install stops
with the message that there is no SQL installed.
Does anybody have an idea how we get around this? We searched the KB and
didn't come up with anything.
Thanks for your help
ClausYou will need to download and apply SP3a in order for SQL Server 2000 to
work properly.
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>|||Sorry.. short read your message. Try uninstalling SQL Server, reboot,
re-install SQL Server, apply SP3 -before- restarting again.
"Morgan" <abcd@.senditon.com> wrote in message
news:ubUybFHaEHA.2488@.tk2msftngp13.phx.gbl...
> You will need to download and apply SP3a in order for SQL Server 2000 to
> work properly.
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
2003[vbcol=seagreen]
SP3[vbcol=seagreen]
> stops
>|||You can install past the warning. SQL agent will fail since Windows 2003
disables the network libraries on any installation below SP3. Start and
stop the SQL server instance once after the base install. You can then
install SP3a. Once SP3a is installed, everything should be fine. You may
have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
work correctly.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
> Hi all,
> Our SQL server hardware died and we bought a new server with Windows 2003
> server. We have the SQL 2000 CD and the CD with service pack 3a.
> When we try to install SQL 2000 we get the warning that anything below SP3
> is not supported on W2003 and the installation fails at the server
> configuration. We can start the server but starting the Agent fails. We
> thought that we might win and tried to run SP3 anyhow but the install
stops
> with the message that there is no SQL installed.
> Does anybody have an idea how we get around this? We searched the KB and
> didn't come up with anything.
> Thanks for your help
> Claus
>|||Geoff/Morgan
The SQL installation fails at the server configuration. No SQL instance is
present and SP3 will not install because it doesn't find the server. When I
searched the KBs I did find one that said if the server name is small or
mixed letters it could fail. I renamed the server all caps but the problem
is still the same.
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
> You can install past the warning. SQL agent will fail since Windows 2003
> disables the network libraries on any installation below SP3. Start and
> stop the SQL server instance once after the base install. You can then
> install SP3a. Once SP3a is installed, everything should be fine. You may
> have to get refreshed media (SQL 2000a) for the install on Windows 2003 to
> work correctly.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:OMUxbvFaEHA.2908@.TK2MSFTNGP10.phx.gbl...
2003[vbcol=seagreen]
SP3[vbcol=seagreen]
> stops
>|||Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
Standard Edition on Windows 20003 Standard Edition. If you have an Open or
Select license you can download the correct version, otherwise you will
probably have to contact Microsoft directly for a media refresh. SQL 2000a
is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
patched DLL and allow you to install correectly. YOu will still have to
install SP3a, but you should at least get past where you are stuck now.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"cjobes" <cjobes@.nova-tech.org> wrote in message
news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
> Geoff/Morgan
> The SQL installation fails at the server configuration. No SQL instance is
> present and SP3 will not install because it doesn't find the server. When
I
> searched the KBs I did find one that said if the server name is small or
> mixed letters it could fail. I renamed the server all caps but the problem
> is still the same.
> Claus
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uUXS3jHaEHA.3420@.TK2MSFTNGP12.phx.gbl...
2003[vbcol=seagreen]
may[vbcol=seagreen]
to[vbcol=seagreen]
> 2003
> SP3
We[vbcol=seagreen]
and[vbcol=seagreen]
>|||Thanks,
Claus
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23kGzetHaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Try getting a copy of SQL 2000a. I had similar problems with SQL 2000
> Standard Edition on Windows 20003 Standard Edition. If you have an Open
or
> Select license you can download the correct version, otherwise you will
> probably have to contact Microsoft directly for a media refresh. SQL
2000a
> is SQL 2000 with the Slammer work patch. Windows 2003 will recognize the
> patched DLL and allow you to install correectly. YOu will still have to
> install SP3a, but you should at least get past where you are stuck now.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "cjobes" <cjobes@.nova-tech.org> wrote in message
> news:eIzMqqHaEHA.1652@.TK2MSFTNGP09.phx.gbl...
is[vbcol=seagreen]
When[vbcol=seagreen]
> I
problem[vbcol=seagreen]
> 2003
and[vbcol=seagreen]
then[vbcol=seagreen]
> may
2003[vbcol=seagreen]
> to
below[vbcol=seagreen]
> We
install[vbcol=seagreen]
> and
>
Subscribe to:
Posts (Atom)