MSDE 2000 on a Windows 2000 machine

After I install MSDE on a windows 2000 machine I enable the network
protocols stop and start the server and everything works fine. When I
try to disable the network protocols I stop and start the server and it
doesn't work. I have to run SVRNETCN to see that the TCP/IP and Named
Pipes are disabled. I click ok and it tells me that the server has to
stopped and started for the changes to take effect. I stop and start
the server and the changes are in effect. Any way that I can set the
changes without having to run SVRNETCN
Thanks
hi,
johndoe17@.verizon.net wrote:
> After I install MSDE on a windows 2000 machine I enable the network
> protocols stop and start the server and everything works fine. When I
> try to disable the network protocols I stop and start the server and
> it doesn't work. I have to run SVRNETCN to see that the TCP/IP and
> Named Pipes are disabled. I click ok and it tells me that the server
> has to stopped and started for the changes to take effect. I stop
> and start the server and the changes are in effect. Any way that I
> can set the changes without having to run SVRNETCN
AFAIK the Server Network Utility writes all the necessary registry entries
to perform the network protocols changes.. you should be able to do the same
"simply" assigning the
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Su perSocketNetLib
ProtocolList = ....
registry value, but this does not seems to work, so I do think svrnetcn.exe
performs further writes...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Is there a command line option I can use to run svrnetcn without the
user interface, so that I can tell it which server to set the protocols
for?
|||hi,
johndoe17@.verizon.net wrote:
> Is there a command line option I can use to run svrnetcn without the
> user interface, so that I can tell it which server to set the
> protocols for?
perhaps via WMI, but never tried it out...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for all your help. I was able to change the value in the
registry key
"HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\S uperSocketNetLib
ProtocolList = " to 0 and everything seems to be disabled.
Thanks again.
sql

MSDE 2000 install problem - Setup failed to configure the server

Hi,
I keep getting a "Setup failed to configure the server" message everytime i
try to install MSDE 2000. I have entered a strong pasword, as that was
required, removed any instances of previous msde installations and it makes
no difference.
I have read and followed instructions from various web sites and still no
installation.
Any help/advice appreciated.
Thanks
Jen
P.S. I am running XP SP2
Hello,
When you say that you removed every msde instance, did you remove the
Microsoft SQL Server directory?
My custommers have problems when they uninstall msde and they don't delete
the directory by hand after
Marc Allard
Allcomp
"JenC" <JenC@.discussions.microsoft.com> a crit dans le message de news:
EB81AD99-9F73-4731-B15F-BA1624075E9A@.microsoft.com...
> Hi,
> I keep getting a "Setup failed to configure the server" message everytime
> i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it
> makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
|||If you setup is failing, specify a command line parameter DISABLEROLLBACK =
1, this would stop MSDE Installer from rolling back in case of failure.
Also specify /L*v <log file patch with name>. This would enable setup to
write logs into the specified file. Try to search "return value 3" and
check where did it fail.
Once we know where it is failing we can help better. Also add the logfile
when you reply next.
|||Try changing the parameters you use for setup.exe. For example, I removed the
DISABLENETWORKPROTOCOLS =1 and INSTANCENAME=MSDE2 parameters and it worked
fine after that.
Good luck.
"JenC" wrote:

> Hi,
> I keep getting a "Setup failed to configure the server" message everytime i
> try to install MSDE 2000. I have entered a strong pasword, as that was
> required, removed any instances of previous msde installations and it makes
> no difference.
> I have read and followed instructions from various web sites and still no
> installation.
> Any help/advice appreciated.
> Thanks
> Jen
> P.S. I am running XP SP2
sql

MSDCT Volumes not available for SQL Install

There on and accessable through Explorer and Disk Management. However when I
try to install SQL as a new virtual instance I only have access to my Quorum
Resources.
Installing Sql2000 on 2003 server Active /Passive.
One instance is already installed and running. Has been for several months.
If I remember right for each SQL Instance you would need new spindles as
they cannot be shared between SQL Instances on a MSCS.
"dibblm" <dibblm@.hotmail.com> wrote in message
news:u1cRduCIFHA.2456@.TK2MSFTNGP09.phx.gbl...
> There on and accessable through Explorer and Disk Management. However when
> I try to install SQL as a new virtual instance I only have access to my
> Quorum Resources.
> Installing Sql2000 on 2003 server Active /Passive.
> One instance is already installed and running. Has been for several
> months.
>
|||Correct.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"wasonce" <mike@.ntadmins.org> wrote in message
news:OzISmIQIFHA.576@.TK2MSFTNGP15.phx.gbl...
> If I remember right for each SQL Instance you would need new spindles as
> they cannot be shared between SQL Instances on a MSCS.
> "dibblm" <dibblm@.hotmail.com> wrote in message
> news:u1cRduCIFHA.2456@.TK2MSFTNGP09.phx.gbl...
>
|||I dont understand what you mean as far as new spindles.
I have 3 columes in a 6TB SAN. I have SQL installed to one. With the datbase
on another and the log files on another. Thus utilizing 3 seperate volumes
for disaster management and recovery. What do you mean as far as needing a
new spindle?
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:ekNy3YQIFHA.3364@.TK2MSFTNGP10.phx.gbl...
> Correct.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "wasonce" <mike@.ntadmins.org> wrote in message
> news:OzISmIQIFHA.576@.TK2MSFTNGP15.phx.gbl...
>
|||This article
http://www.sqlservercentral.com/colu...youbuyasan.asp
gives you great examples. More disks, more spindles.
Here is a pretty explanation of what a spindle is
http://www.webopedia.com/TERM/s/spindle.html.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"dibblm" <dibblm@.hotmail.com> wrote in message
news:eSgSrfzIFHA.588@.TK2MSFTNGP15.phx.gbl...
>I dont understand what you mean as far as new spindles.
> I have 3 columes in a 6TB SAN. I have SQL installed to one. With the
> datbase on another and the log files on another. Thus utilizing 3 seperate
> volumes for disaster management and recovery. What do you mean as far as
> needing a new spindle?
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:ekNy3YQIFHA.3364@.TK2MSFTNGP10.phx.gbl...
>
|||I personally think this isn't my issues. I have 42 Drives (Or spindles) I
have plenty of room. The problem is with Sql itself on the install.
Something is hosed in the os where the SQL install doesnt even see the
resources.
Let me get you a little closer to the problem.
You state the sql setup.
You can shoose either local, remote or virtual. ( I choose virtual)
then you have to assign ip's and so on
once you get to the area where you pick where you want to install the
instance to.......... My only resource is the Quorum resource itself. I
do not even see my other resources that contain other volumes.
My initial install showed as follows
<Quorum>
<<<<<Q:
<<<<<F: ( left over storage that wasnt needed)
<MSDTC>
<<<<<G: ( About 2 TB of storage)
<<<<<H: (About 2 TB of storage)
<<<<<I: (About 2 TB of storage)
<WEB IP's>
<<<<<Resource of a list of clustered IP;s I use for internal web
addreses
Now when I re-intall or try to install a new instance...
I only see my Quorum resource. My other 2 resources arent even showing.. Yes
they are running , Yes they are on the same node in which I am installing
from. No I cannot see them from the other node when I move them and try to
install from the 2nd node ( as a test)
Everything works normal, I have a 1.5 TB Database that is growing daily that
works great, Clustered resources work and failover as planned.
Now after further explination. Do you still think that this is a spindle
issue when I have plenty of room to work with still?
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:OVLes8zIFHA.1280@.TK2MSFTNGP09.phx.gbl...
> This article
> http://www.sqlservercentral.com/colu...youbuyasan.asp
> gives you great examples. More disks, more spindles.
> Here is a pretty explanation of what a spindle is
> http://www.webopedia.com/TERM/s/spindle.html.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "dibblm" <dibblm@.hotmail.com> wrote in message
> news:eSgSrfzIFHA.588@.TK2MSFTNGP15.phx.gbl...
>
|||It sounds like you have configured the SAN as one drive to the OS, but with
multiple partitions. Clustering can only talk to drives, all parturitions
are treated as the same thing. Is this the case?
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"dibblm" <dibblm@.hotmail.com> wrote in message
news:uS2K8L$IFHA.2784@.TK2MSFTNGP09.phx.gbl...
> I personally think this isn't my issues. I have 42 Drives (Or spindles) I
> have plenty of room. The problem is with Sql itself on the install.
> Something is hosed in the os where the SQL install doesnt even see the
> resources.
> Let me get you a little closer to the problem.
> You state the sql setup.
> You can shoose either local, remote or virtual. ( I choose virtual)
> then you have to assign ip's and so on
> once you get to the area where you pick where you want to install the
> instance to.......... My only resource is the Quorum resource itself. I
> do not even see my other resources that contain other volumes.
> My initial install showed as follows
> <Quorum>
> <<<<<Q:
> <<<<<F: ( left over storage that wasnt needed)
> <MSDTC>
> <<<<<G: ( About 2 TB of storage)
> <<<<<H: (About 2 TB of storage)
> <<<<<I: (About 2 TB of storage)
> <WEB IP's>
> <<<<<Resource of a list of clustered IP;s I use for internal web
> addreses
> Now when I re-intall or try to install a new instance...
> I only see my Quorum resource. My other 2 resources arent even showing..
> Yes they are running , Yes they are on the same node in which I am
> installing from. No I cannot see them from the other node when I move them
> and try to install from the 2nd node ( as a test)
> Everything works normal, I have a 1.5 TB Database that is growing daily
> that works great, Clustered resources work and failover as planned.
> Now after further explination. Do you still think that this is a spindle
> issue when I have plenty of room to work with still?
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:OVLes8zIFHA.1280@.TK2MSFTNGP09.phx.gbl...
>
|||Not at all.
I have 6 mounted volumes.
C: (2 - 36 gig drives in a mirror 0+1 (Operating System))
D: CD Rom
F: (See quorum)
G: (14 - 146 Gig DRives. raid 5 with 1 HOT online spare( 2 TB))
H: (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
I : (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
QQuorum Drive - 2 36 Gig Drives 0+1 Mirror. 2 partitions. Q for Quorum 10
Gig - F for left over.)
SQL Was originally Installed to G Holding the data with H holding the log
files and I holding the backups.
Again,, When I install now to create a new virtual instance, I dont even see
the G, H, and I drives that are in the MSDTC Resource. I dont even see the
Resource. I will do another install today and priovide a screen capture of
my scenario. I will also Provide a screen capture of the mounted Volu mes.
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:O6qswCAJFHA.3788@.tk2msftngp13.phx.gbl...
> It sounds like you have configured the SAN as one drive to the OS, but
> with multiple partitions. Clustering can only talk to drives, all
> parturitions are treated as the same thing. Is this the case?
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "dibblm" <dibblm@.hotmail.com> wrote in message
> news:uS2K8L$IFHA.2784@.TK2MSFTNGP09.phx.gbl...
>
|||Ok, cause its just not adding up yet.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"dibblm" <dibblm@.hotmail.com> wrote in message
news:esFdXNXJFHA.2772@.TK2MSFTNGP14.phx.gbl...
> Not at all.
> I have 6 mounted volumes.
> C: (2 - 36 gig drives in a mirror 0+1 (Operating System))
> D: CD Rom
> F: (See quorum)
> G: (14 - 146 Gig DRives. raid 5 with 1 HOT online spare( 2 TB))
> H: (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
> I : (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
> QQuorum Drive - 2 36 Gig Drives 0+1 Mirror. 2 partitions. Q for Quorum
> 10 Gig - F for left over.)
> SQL Was originally Installed to G Holding the data with H holding the log
> files and I holding the backups.
> Again,, When I install now to create a new virtual instance, I dont even
> see the G, H, and I drives that are in the MSDTC Resource. I dont even see
> the Resource. I will do another install today and priovide a screen
> capture of my scenario. I will also Provide a screen capture of the
> mounted Volu mes.
>
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:O6qswCAJFHA.3788@.tk2msftngp13.phx.gbl...
>
|||Just to clarify you have what appears to your cluster as six physical disks
C: (2 - 36 gig drives in a mirror 0+1 (Operating System))
D: CD Rom
F: (See quorum)
G: (14 - 146 Gig DRives. raid 5 with 1 HOT online spare( 2 TB))
H: (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
I : (14 - 146 Gig DRives raid 5 with 1 HOT online spare( 2 TB))
QQuorum Drive - 2 36 Gig Drives 0+1 Mirror. 2 partitions. Q for Quorum 10
Gig - F for left over.)
Based on this that would allow you to use disks G:, H: and I: as possible
SQL Server disks
you stated that "SQL Was originally Installed to G Holding the data with H
holding the log
files and I holding the backups."
That would leave you with only the Quorum drives Q:, F: as possible disks
Once you added the H: and I: drives to the existing SQL Server they are no
longer available for use with another instance of SQL Server.
Each SQL Server instance will require its own group, name, IP address and
phyiscal disk
Simple way to look at this is any disk in the group with an existing
instance of SQL Server will not be available and sharing of resources in a
group between multiple groups is not possible.
Dave Whitney
SQL Support