Clustered SQL Server 2000 is not seen by fn_virtualservernodes()

Hello,
Firstly I will provide some background. Few weeks before I started
work as database administrator but without cluster experience, and few
days ago I got a project to add sql serve pasive node to Windows 2003
cluster, I looked the internet but no serious sollutions wasn't find.
Nobody in company has idea how SQL Server was installed on this
cluster. Cluster consist of two machines with cluster services and
storage resurces installed, one has sql insatlled second, added later,
is waiting for my instalation. Cluster resuorces directing on active
SQL instance.
Before adding node quest I did some checks and found out that existing
sql node isn't recognize by fn_virtualservernodes() function. When I
wanted to add node according to Microsoft
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
I got error "Another Virtual Server of the same name exists on the
network error".
And finally my questions do have idea how to add second SQL node to
this configuration?
Or do I have to uninstall active sql serevr and start standard sql
serevr instalation on cluster?
Any help appreciate.
Regards,
BartekBartolo wrote:
> Hello,
> Firstly I will provide some background. Few weeks before I started
> work as database administrator but without cluster experience, and few
> days ago I got a project to add sql serve pasive node to Windows 2003
> cluster, I looked the internet but no serious sollutions wasn't find.
> Nobody in company has idea how SQL Server was installed on this
> cluster. Cluster consist of two machines with cluster services and
> storage resurces installed, one has sql insatlled second, added later,
> is waiting for my instalation. Cluster resuorces directing on active
> SQL instance.
> Before adding node quest I did some checks and found out that existing
> sql node isn't recognize by fn_virtualservernodes() function. When I
> wanted to add node according to Microsoft
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
> I got error "Another Virtual Server of the same name exists on the
> network error".
> And finally my questions do have idea how to add second SQL node to
> this configuration?
> Or do I have to uninstall active sql serevr and start standard sql
> serevr instalation on cluster?
> Any help appreciate.
> Regards,
> Bartek
hi Bartek,
I have few years of experience with MSCS and MSSQL. I setup SQL on MSCS
several times but never tried to add node later. AFAIK you need to
uninstall sql server and then install it again. This is not hard to do.
good luck and hth|||Thanks a lot Zarko!
It seems I have to take into account uninstallation and installation
from the very begining.
Best regards,
Bartek
On 7 Lut, 11:39, Zarko Jovanovic <mind_lessIsHsAsTsEsSsPsA...@.inet.hr>
wrote:
> Bartolo wrote:
> > Hello,
> > Firstly I will provide some background. Few weeks before I started
> > work as database administrator but without cluster experience, and few
> > days ago I got a project to add sql serve pasive node to Windows 2003
> > cluster, I looked the internet but no serious sollutions wasn't find.
> > Nobody in company has idea how SQL Server was installed on this
> > cluster. Cluster consist of two machines with cluster services and
> > storage resurces installed, one has sql insatlled second, added later,
> > is waiting for my instalation. Cluster resuorces directing on active
> > SQL instance.
> > Before adding node quest I did some checks and found out that existing
> > sql node isn't recognize by fn_virtualservernodes() function. When I
> > wanted to add node according to Microsoft
> >http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failcl...
> > I got error "Another Virtual Server of the same name exists on the
> > network error".
> > And finally my questions do have idea how to add second SQL node to
> > this configuration?
> > Or do I have to uninstall active sql serevr and start standard sql
> > serevr instalation on cluster?
> > Any help appreciate.
> > Regards,
> > Bartek
> hi Bartek,
> I have few years of experience with MSCS and MSSQL. I setup SQL on MSCS
> several times but never tried to add node later. AFAIK you need to
> uninstall sql server and then install it again. This is not hard to do.
> good luck and hth