I CANT INSTAL a Virtual Server of SQL 2000 Enterprise in Win2k3 Enterprise

I have a Cluster of Windows 2003 Enterprise Edition, When I try to install a
SQL 2000 Enterprise Edition the setup option of Virtual Server appear
unavailable I only choose between Local Install or Remote.
Thanks for your help
Hi Alejandro,
Here are few things I would try:
1) Make sure that you are using SQL Server 2000 Enterprise Edition setup CD
2) Make sure that there are no mdf, ldf or ndf files on your local disks on both nodes
3) Make sure that you do not have another "default" instance of SQL Server/MSDE on the other node.
After taking care of the above things, try the upgrade. If it fails, then cut and paste the sqlstp.log to your post.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hi,
1) Yes its SQL Server 2003 Enterprise Edition
2) There are not any MDF, NDF and LDF files (Just to be shure, this files
are SQL Files?)
3) I haven't any SQL Installed on the server
I follow this Steps but when I ran the setup the Virtual Server appear
dissable (Thanks for your help)
No.
Activity
Purpose
Expected Results
Results
1.
Reboot both nodes
They should come up with no error messages
2.
Check Event Viewer on each node and make sure there are no errors that
might interfere with the installation
3.
Check account permissions for the cluster account
Should be part of the Local Administrator group
4.
On each node, on the Start menu, click Run, and then type cmd in the
text box. Click OK.
Ping the Cluster IP Address from all nodes in the cluster; repeat for
each node
To verify that the private and public networks are communicating
properly
They should replay back
5.
Ping the cluster IP address from a computer not in the cluster
They should replay back
6.
Ping the Cluster Network Name from all nodes in the cluster
They should replay back
7.
Ping the Cluster Network Name from a computer not in the cluster
They should replay back
8.
Ping all Heartbead IP Addresses from all cluster nodes
They should replay back
9.
A domain account is available for SQL Server; check permissions for the
account; also the cluster administrator account must be created at the
domain level and must be an administrator of all nodes in the cluster
10.
All nodes have access to the installation path - we recommend to copy
the installation files locally on each node, especially for the services
pack and hotfix;
11.
In Cluster Administrator, for a two SQL Server instance installation,
create 4 groups and assign the correspondent resources to each group (such
as disk resources):
1.. MSDTC Group
2.. Cluster Group
3.. SQLServer Group1
4.. SQLServer Group2
12.
Using Cluster Administrator, test moving each group back and forth
between the two Nodes - check the owner
The owner should change
13.
While one Node owns all the groups, restart the other Node and check if
resource ownership was transferred to the other Node
The owner should change
14.
Check what resources belong to the Cluster Group
It should be: Cluster IP Address, Cluster Name, and Quorum Disk
15.
MSDTC Group
MS DTC should be in its own group; follow the following article to
configure MSDTC: 301600 - How to configure Microsoft Distributed Transaction
Coordinator on a Windows Server 2003 Cluster detailed in Appendix B
Regards, Alex
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:kOTjX3ZnEHA.2640@.cpmsftngxa06.phx.gbl...
> Hi Alejandro,
> Here are few things I would try:
> 1) Make sure that you are using SQL Server 2000 Enterprise Edition setup
> CD
> 2) Make sure that there are no mdf, ldf or ndf files on your local disks
> on both nodes
> 3) Make sure that you do not have another "default" instance of SQL
> Server/MSDE on the other node.
> After taking care of the above things, try the upgrade. If it fails, then
> cut and paste the sqlstp.log to your post.
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||Hi Alejandro,
Please cut and paste sqlstp.log file (search for this file on the node where you ran sql server setup).
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||OK, I'm not in the office right now, but on monday I'm gona to attach this
log.
But first answere me something, If I never ran the setup completely, because
I never found the option of virtual Server available, which log I'm going to
cut an paste here? or If you just run the setup program click in the first
NEXT and then Cancel It (because the option virtual server is unavailable is
in gray) the sqlstp.log is generated?
Regards, Alex
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:nGonUGdnEHA.2932@.cpmsftngxa06.phx.gbl...
> Hi Alejandro,
> Please cut and paste sqlstp.log file (search for this file on the node
> where you ran sql server setup).
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||Yes, it will create sqlstp.log file.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||please correct me if i'm wrong. I believe you have to create a name pipe, in
order for you to install sql on a virtual address. go to run and type in
cliconfg, click on alias and create.
Calvin
"Alejandro Garreta" <alejandro_garreta@.hotmail.com> wrote in message
news:eCmFPRbnEHA.392@.tk2msftngp13.phx.gbl...
> Hi,
> 1) Yes its SQL Server 2003 Enterprise Edition
> 2) There are not any MDF, NDF and LDF files (Just to be shure, this files
> are SQL Files?)
> 3) I haven't any SQL Installed on the server
> I follow this Steps but when I ran the setup the Virtual Server appear
> dissable (Thanks for your help)
>
> No.
> Activity
> Purpose
> Expected Results
> Results
> 1.
> Reboot both nodes
> They should come up with no error messages
>
> 2.
> Check Event Viewer on each node and make sure there are no errors
that
> might interfere with the installation
>
>
> 3.
> Check account permissions for the cluster account
> Should be part of the Local Administrator group
>
> 4.
> On each node, on the Start menu, click Run, and then type cmd in the
> text box. Click OK.
> Ping the Cluster IP Address from all nodes in the cluster; repeat
for
> each node
> To verify that the private and public networks are communicating
> properly
> They should replay back
>
> 5.
> Ping the cluster IP address from a computer not in the cluster
> They should replay back
>
> 6.
> Ping the Cluster Network Name from all nodes in the cluster
> They should replay back
>
> 7.
> Ping the Cluster Network Name from a computer not in the cluster
> They should replay back
>
> 8.
> Ping all Heartbead IP Addresses from all cluster nodes
> They should replay back
>
> 9.
> A domain account is available for SQL Server; check permissions for
the
> account; also the cluster administrator account must be created at the
> domain level and must be an administrator of all nodes in the cluster
>
>
> 10.
> All nodes have access to the installation path - we recommend to copy
> the installation files locally on each node, especially for the services
> pack and hotfix;
>
>
> 11.
> In Cluster Administrator, for a two SQL Server instance installation,
> create 4 groups and assign the correspondent resources to each group (such
> as disk resources):
> 1.. MSDTC Group
> 2.. Cluster Group
> 3.. SQLServer Group1
> 4.. SQLServer Group2
>
>
> 12.
> Using Cluster Administrator, test moving each group back and forth
> between the two Nodes - check the owner
>
> The owner should change
>
> 13.
> While one Node owns all the groups, restart the other Node and check
if
> resource ownership was transferred to the other Node
> The owner should change
>
> 14.
> Check what resources belong to the Cluster Group
> It should be: Cluster IP Address, Cluster Name, and Quorum Disk
>
> 15.
> MSDTC Group
> MS DTC should be in its own group; follow the following article to
> configure MSDTC: 301600 - How to configure Microsoft Distributed
Transaction[vbcol=seagreen]
> Coordinator on a Windows Server 2003 Cluster detailed in Appendix B
>
>
> Regards, Alex
> "Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
> news:kOTjX3ZnEHA.2640@.cpmsftngxa06.phx.gbl...
then[vbcol=seagreen]
Protection
>
|||Hello Calvin,
You need to create the named pipe alias only if you are installing a Named instance of SQL Server 2000 virtual server on Windows 2000 MSCS. For default instance, you
do not need to create the alias.
Here is the related Microsoft KB
Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
http://support.microssoft.com/?id=815431
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Here is the LOG !!
10:52:09 Begin Setup
10:52:09 8.00.194
10:52:09 Mode = Normal
10:52:09 ModeType = NORMAL
10:52:09 GetDefinitionEx returned: 0, Extended: 0x0
10:52:09 ValueFTS returned: 1
10:52:09 ValuePID returned: 1
10:52:09 ValueLic returned: 0
10:52:09 System: Windows NT Enterprise Server
10:52:09 SQL Server ProductType: Personal Edition [0x2]
10:52:09 IsNTCluster returned: 1
10:52:09 Begin Action: SetupInitialize
10:52:09 End Action SetupInitialize
10:52:09 Begin Action: SetupInstall
10:52:09 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
...
10:52:09 CommonFilesDir=C:\Program Files\Common Files
10:52:09 Windows Directory=C:\WINDOWS\
10:52:09 Program Files=C:\Program Files\
10:52:09 TEMPDIR=C:\DOCUME~1\219701\LOCALS~1\Temp\2\
10:52:09 Begin Action: SetupInstall
10:52:09 digpid size : 256
10:52:09 digpid size : 164
10:52:09 Begin Action: CheckFixedRequirements
10:52:09 Platform ID: 0xf00000
10:52:09 Version: 5.2.3790
10:52:09 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.118
10:52:09 End Action: CheckFixedRequirements
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:6xtrCOfnEHA.3312@.cpmsftngxa06.phx.gbl...
> Yes, it will create sqlstp.log file.
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||I'm not installing a named instance !!!
"Calvin Do" <calvin@.spinsonic.com> wrote in message
news:OeQAZH1nEHA.536@.TK2MSFTNGP11.phx.gbl...
> please correct me if i'm wrong. I believe you have to create a name pipe,
> in
> order for you to install sql on a virtual address. go to run and type in
> cliconfg, click on alias and create.
> Calvin
>
> "Alejandro Garreta" <alejandro_garreta@.hotmail.com> wrote in message
> news:eCmFPRbnEHA.392@.tk2msftngp13.phx.gbl...
> that
> for
> the
> if
> Transaction
> then
> Protection
>

Hyperthreading SQL Server 7 - HELP!

Could you clarify the following.
We are looking to buy a quad xeon box (ie 8 virtual processors). From
reading MS documentation it looks like W2K Server won't cut it - we
will need to move to W2K Advanced Server, correct?
Secondly, will Sql Server 7 support 8 virtual processors under such a
scenario?
Thirdly, based on our proposed box 4 x 2.0 GHz Xeon + 2 Gb RAM - for
more performance would you increase the processor speed (eg to 2.5GHz)
or add more RAM (eg to 4 Gb, or more)?
Many Thanks,
StewartI think win2k server ONLY supports 2 physical procs, so you'll neet Advanced
Server...I think you'll also need sql 7 Enterprise to support 4 procs...
Please make sure SQL 7 Enterprise will run on W2k Advanced Server... ( I
think it will, but be safe and double check..)
"Stewart" <windsurfin_stew@.yahoo.com.au> wrote in message
news:9373ee00.0308112138.1cb2f916@.posting.google.com...
> Could you clarify the following.
> We are looking to buy a quad xeon box (ie 8 virtual processors). From
> reading MS documentation it looks like W2K Server won't cut it - we
> will need to move to W2K Advanced Server, correct?
> Secondly, will Sql Server 7 support 8 virtual processors under such a
> scenario?
> Thirdly, based on our proposed box 4 x 2.0 GHz Xeon + 2 Gb RAM - for
> more performance would you increase the processor speed (eg to 2.5GHz)
> or add more RAM (eg to 4 Gb, or more)?
> Many Thanks,
> Stewart|||Win 2K server supports 4 Procs.
Here is a good doc on Microsoft , Win2K and hyperthreading
http://www.microsoft.com/windows2000/docs/hyperthreading.doc
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:ue9wXLLYDHA.1640@.TK2MSFTNGP10.phx.gbl...
> I think win2k server ONLY supports 2 physical procs, so you'll neet
Advanced
> Server...I think you'll also need sql 7 Enterprise to support 4 procs...
> Please make sure SQL 7 Enterprise will run on W2k Advanced Server... ( I
> think it will, but be safe and double check..)
> "Stewart" <windsurfin_stew@.yahoo.com.au> wrote in message
> news:9373ee00.0308112138.1cb2f916@.posting.google.com...
> > Could you clarify the following.
> >
> > We are looking to buy a quad xeon box (ie 8 virtual processors). From
> > reading MS documentation it looks like W2K Server won't cut it - we
> > will need to move to W2K Advanced Server, correct?
> >
> > Secondly, will Sql Server 7 support 8 virtual processors under such a
> > scenario?
> >
> > Thirdly, based on our proposed box 4 x 2.0 GHz Xeon + 2 Gb RAM - for
> > more performance would you increase the processor speed (eg to 2.5GHz)
> > or add more RAM (eg to 4 Gb, or more)?
> >
> > Many Thanks,
> >
> > Stewart
>|||As for your performance question. You will definitely buy more power by
adding memory instead of CPU here. Go with 4GB RAM.
"Allan Mitchell" <allan@.no-spam.sqldts.com> wrote in message
news:e3GbgjLYDHA.1280@.tk2msftngp13.phx.gbl...
> Win 2K server supports 4 Procs.
> Here is a good doc on Microsoft , Win2K and hyperthreading
> http://www.microsoft.com/windows2000/docs/hyperthreading.doc
> --
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> "Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
> news:ue9wXLLYDHA.1640@.TK2MSFTNGP10.phx.gbl...
> > I think win2k server ONLY supports 2 physical procs, so you'll neet
> Advanced
> > Server...I think you'll also need sql 7 Enterprise to support 4
procs...
> > Please make sure SQL 7 Enterprise will run on W2k Advanced Server... ( I
> > think it will, but be safe and double check..)
> > "Stewart" <windsurfin_stew@.yahoo.com.au> wrote in message
> > news:9373ee00.0308112138.1cb2f916@.posting.google.com...
> > > Could you clarify the following.
> > >
> > > We are looking to buy a quad xeon box (ie 8 virtual processors). From
> > > reading MS documentation it looks like W2K Server won't cut it - we
> > > will need to move to W2K Advanced Server, correct?
> > >
> > > Secondly, will Sql Server 7 support 8 virtual processors under such a
> > > scenario?
> > >
> > > Thirdly, based on our proposed box 4 x 2.0 GHz Xeon + 2 Gb RAM - for
> > > more performance would you increase the processor speed (eg to 2.5GHz)
> > > or add more RAM (eg to 4 Gb, or more)?
> > >
> > > Many Thanks,
> > >
> > > Stewart
> >
> >
>|||SQL Server 7.0 Standard Edition will only support 4 processors, and it can't
tell the difference between physical and logical processors. So, if you
want it to use all 8 logical processors on your proposed configuration
you'll want to purchase Enterprise Edition. In addition, 2GB of memory is
marginal for this sized configuration if you are really worried about
maximum performance. So you'll want more memory and Enterprise Edition to
support that additional memory. With 7.0 the best you can do for memory is
the /3GB switch. So the maximum useful memory on the system is going to be
4GB.
An alternative is to stick with Standard Edition and just have it use one
logical processor on each physical processor. Background tasks (Windows
processes, SQL Agent, etc.) will make some use of the additional logical
processors. Keep in mind that the additional logical processors don't
double system performance anyway, most of the data I've heard suggests
they'll give you about a 20% boost. And if you make heavy use of parallel
query then they might actually lead to some pathological conditions that
degrade performance. Finally, with Standard Edition you'd still be limited
to 2GB of memory, which in the long run is your most likely bottleneck.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Stewart" <windsurfin_stew@.yahoo.com.au> wrote in message
news:9373ee00.0308112138.1cb2f916@.posting.google.com...
> Could you clarify the following.
> We are looking to buy a quad xeon box (ie 8 virtual processors). From
> reading MS documentation it looks like W2K Server won't cut it - we
> will need to move to W2K Advanced Server, correct?
> Secondly, will Sql Server 7 support 8 virtual processors under such a
> scenario?
> Thirdly, based on our proposed box 4 x 2.0 GHz Xeon + 2 Gb RAM - for
> more performance would you increase the processor speed (eg to 2.5GHz)
> or add more RAM (eg to 4 Gb, or more)?
> Many Thanks,
> Stewart