Cluster Issue

Hello,
I have a Wndows 2003 Sql 2005 Cluster consisting of two servers, on Failover
from node2 to node1 the application user is unable to login until the sql
server is restarted, on failover all the resourses come online but the user
is unable to access the database and if I look in SQl Server management
studio I am unable to see the properties of the DB, if I initiate a failure
of SQL server in the cluster I am still unable to access the DB but if I
restart SQL server in management studio the database comes online.
Also when I do a failover to node2, it shows all resourses are online but
the application cannot access the DB like it is not there, but I can access
the Quorum and the shared DB drive.
Thanks in advance,
Bob Smith
Definitely a problem. Check the Application log on either node (Event
logging on a cluster is cluster-wide to each node) to see if SQL is
complaining about starting up.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
news:F586AE13-D88E-4893-A6A3-0465392C13F2@.microsoft.com...
> Hello,
> I have a Wndows 2003 Sql 2005 Cluster consisting of two servers, on
> Failover
> from node2 to node1 the application user is unable to login until the sql
> server is restarted, on failover all the resourses come online but the
> user
> is unable to access the database and if I look in SQl Server management
> studio I am unable to see the properties of the DB, if I initiate a
> failure
> of SQL server in the cluster I am still unable to access the DB but if I
> restart SQL server in management studio the database comes online.
> Also when I do a failover to node2, it shows all resourses are online but
> the application cannot access the DB like it is not there, but I can
> access
> the Quorum and the shared DB drive.
> Thanks in advance,
> Bob Smith
|||Hi Geoff,
Thanks for the reply, the only thing I can see is logwriter errors, which I
googled and found more questions than answers, let me ask this: Can the
Quroum and the physical disk be in different groups or should the be in the
same, mine is set the the Quorum is in the Cluster group and the Physical
disk is in group 0. By the way I see these errors on both nodes. What is best
practice for the cluster group, what resourses should exist in it: Cluster
IP, Cluster Name, MSDTC -?, Quorum -?
Thanks again,
Bob Smith
"Geoff N. Hiten" wrote:

> Definitely a problem. Check the Application log on either node (Event
> logging on a cluster is cluster-wide to each node) to see if SQL is
> complaining about starting up.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
> news:F586AE13-D88E-4893-A6A3-0465392C13F2@.microsoft.com...
>
|||Quorum must be in the cluster group. It is the reason the group exists.
The Quorum disk prevents split-brain problems. The Cluster group should
also have an IP Address and a Network Name Resource.
You can put the MSDTC resource in there too, but it can cause problems on
some very high volume systems.
All SQL resources should be in a different group. Note that disks are
physical resources. Logical OS partitions of the same disk cannot be split
into multiple groups.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
news:1BD77D34-DC9D-4CB6-8325-9D32F50C9B58@.microsoft.com...[vbcol=seagreen]
> Hi Geoff,
> Thanks for the reply, the only thing I can see is logwriter errors, which
> I
> googled and found more questions than answers, let me ask this: Can the
> Quroum and the physical disk be in different groups or should the be in
> the
> same, mine is set the the Quorum is in the Cluster group and the Physical
> disk is in group 0. By the way I see these errors on both nodes. What is
> best
> practice for the cluster group, what resourses should exist in it: Cluster
> IP, Cluster Name, MSDTC -?, Quorum -?
> Thanks again,
> Bob Smith
> "Geoff N. Hiten" wrote:
|||Geoff,
Thanks, that is how it is setup Cluster group (Cluster IP, Cluster Name,
Disk Q and MSDTC) all other resourses are in another group, I am still
confused as too why SQL says it is online but the user/app cannot connect,
by restarting SQL server in studion management it comes online.
Thanks again,
Bob Smith
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:%23VBACR5VIHA.4140@.TK2MSFTNGP04.phx.gbl...
> Quorum must be in the cluster group. It is the reason the group exists.
> The Quorum disk prevents split-brain problems. The Cluster group should
> also have an IP Address and a Network Name Resource.
> You can put the MSDTC resource in there too, but it can cause problems on
> some very high volume systems.
> All SQL resources should be in a different group. Note that disks are
> physical resources. Logical OS partitions of the same disk cannot be
> split into multiple groups.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Bob Smith" <BobSmith@.discussions.microsoft.com> wrote in message
> news:1BD77D34-DC9D-4CB6-8325-9D32F50C9B58@.microsoft.com...
>
|||Maybe an IP address conflict or a dependency error. Again, the application
log should say something.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Bob Smith" <bob@.neconsulting.net> wrote in message
news:4E7A31CB-2900-4ED3-A7A9-1B0800B2128C@.microsoft.com...
> Geoff,
> Thanks, that is how it is setup Cluster group (Cluster IP, Cluster Name,
> Disk Q and MSDTC) all other resourses are in another group, I am still
> confused as too why SQL says it is online but the user/app cannot connect,
> by restarting SQL server in studion management it comes online.
> Thanks again,
> Bob Smith
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:%23VBACR5VIHA.4140@.TK2MSFTNGP04.phx.gbl...
>

Cluster @#$ked

I inherited an MS Cluster (2 node) that needs some help. As long as node1 i
s live, it works fine, but when if fails over, the web server pointed to the
virtual server gets nothing back. As far as the cluster is concerned, ever
ything works fine and node2
can even send data to/from the SQL Server. Anyone have any ideas what is ha
ppening? If not, is there some way for me to find out if the server was ins
talled out of order or wrong?
Thanks
--
Johnnie O.
Computer Handyman
Amateur Superhero1. Can anyone connect to the SQL server when it is failed over?... If so,
that means that the SQL is working..
2. Then ensure that the Web server is truly pointing to the virtual server,
and that the web server is running..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"JohnnieO" <JohnnieO@.discussions.microsoft.com> wrote in message
news:663C67E7-5F10-4BC3-AD89-FE6C9AECC6C7@.microsoft.com...
> I inherited an MS Cluster (2 node) that needs some help. As long as node1
is live, it works fine, but when if fails over, the web server pointed to
the virtual server gets nothing back. As far as the cluster is concerned,
everything works fine and node2 can even send data to/from the SQL Server.
Anyone have any ideas what is happening? If not, is there some way for me
to find out if the server was installed out of order or wrong?
> Thanks
> --
> Johnnie O.
> Computer Handyman
> Amateur Superhero|||We verified that the web server is pointed to the virtual server, but we can
not connect to the SQL Server. Cluster Manager reports that everything is w
orking fine, and there was nothing in the cluster.log that indicated a probl
em. Is there any way to ch
eck that the SQL Server was set-up correctly during installation?
--
Johnnie O.
Computer Handyman
Amateur Superhero
"Wayne Snyder" wrote:

> 1. Can anyone connect to the SQL server when it is failed over?... If so,
> that means that the SQL is working..
> 2. Then ensure that the Web server is truly pointing to the virtual server
,
> and that the web server is running..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org|||It sounds like the app has an IP address hard coded in there somewhere. Are
you 100% sure it is using the Virtual server's name and not an IP address?
Andrew J. Kelly SQL MVP
"JohnnieO" <JohnnieO@.discussions.microsoft.com> wrote in message
news:D5A6C302-9E2C-4A4F-B16E-105651B602C8@.microsoft.com...
> We verified that the web server is pointed to the virtual server, but we
cannot connect to the SQL Server. Cluster Manager reports that everything
is working fine, and there was nothing in the cluster.log that indicated a
problem. Is there any way to check that the SQL Server was set-up correctly
during installation?
> --
> Johnnie O.
> Computer Handyman
> Amateur Superhero
>
> "Wayne Snyder" wrote:
>
so,[vbcol=seagreen]
server,[vbcol=seagreen]
>sqlsql

Cluster @#$ked

I inherited an MS Cluster (2 node) that needs some help. As long as node1 is live, it works fine, but when if fails over, the web server pointed to the virtual server gets nothing back. As far as the cluster is concerned, everything works fine and node2 can even send data to/from the SQL Server. Anyone have any ideas what is happening? If not, is there some way for me to find out if the server was installed out of order or wrong?
Thanks
--
Johnnie O.
Computer Handyman
Amateur Superhero1. Can anyone connect to the SQL server when it is failed over?... If so,
that means that the SQL is working..
2. Then ensure that the Web server is truly pointing to the virtual server,
and that the web server is running..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"JohnnieO" <JohnnieO@.discussions.microsoft.com> wrote in message
news:663C67E7-5F10-4BC3-AD89-FE6C9AECC6C7@.microsoft.com...
> I inherited an MS Cluster (2 node) that needs some help. As long as node1
is live, it works fine, but when if fails over, the web server pointed to
the virtual server gets nothing back. As far as the cluster is concerned,
everything works fine and node2 can even send data to/from the SQL Server.
Anyone have any ideas what is happening? If not, is there some way for me
to find out if the server was installed out of order or wrong?
> Thanks
> --
> Johnnie O.
> Computer Handyman
> Amateur Superhero|||It sounds like the app has an IP address hard coded in there somewhere. Are
you 100% sure it is using the Virtual server's name and not an IP address?
--
Andrew J. Kelly SQL MVP
"JohnnieO" <JohnnieO@.discussions.microsoft.com> wrote in message
news:D5A6C302-9E2C-4A4F-B16E-105651B602C8@.microsoft.com...
> We verified that the web server is pointed to the virtual server, but we
cannot connect to the SQL Server. Cluster Manager reports that everything
is working fine, and there was nothing in the cluster.log that indicated a
problem. Is there any way to check that the SQL Server was set-up correctly
during installation?
> --
> Johnnie O.
> Computer Handyman
> Amateur Superhero
>
> "Wayne Snyder" wrote:
> > 1. Can anyone connect to the SQL server when it is failed over?... If
so,
> > that means that the SQL is working..
> > 2. Then ensure that the Web server is truly pointing to the virtual
server,
> > and that the web server is running..
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
>

Cluster @#$ked

I inherited an MS Cluster (2 node) that needs some help. As long as node1 is live, it works fine, but when if fails over, the web server pointed to the virtual server gets nothing back. As far as the cluster is concerned, everything works fine and node2
can even send data to/from the SQL Server. Anyone have any ideas what is happening? If not, is there some way for me to find out if the server was installed out of order or wrong?
Thanks
Johnnie O.
Computer Handyman
Amateur Superhero
1. Can anyone connect to the SQL server when it is failed over?... If so,
that means that the SQL is working..
2. Then ensure that the Web server is truly pointing to the virtual server,
and that the web server is running..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"JohnnieO" <JohnnieO@.discussions.microsoft.com> wrote in message
news:663C67E7-5F10-4BC3-AD89-FE6C9AECC6C7@.microsoft.com...
> I inherited an MS Cluster (2 node) that needs some help. As long as node1
is live, it works fine, but when if fails over, the web server pointed to
the virtual server gets nothing back. As far as the cluster is concerned,
everything works fine and node2 can even send data to/from the SQL Server.
Anyone have any ideas what is happening? If not, is there some way for me
to find out if the server was installed out of order or wrong?
> Thanks
> --
> Johnnie O.
> Computer Handyman
> Amateur Superhero
|||We verified that the web server is pointed to the virtual server, but we cannot connect to the SQL Server. Cluster Manager reports that everything is working fine, and there was nothing in the cluster.log that indicated a problem. Is there any way to ch
eck that the SQL Server was set-up correctly during installation?
Johnnie O.
Computer Handyman
Amateur Superhero
"Wayne Snyder" wrote:

> 1. Can anyone connect to the SQL server when it is failed over?... If so,
> that means that the SQL is working..
> 2. Then ensure that the Web server is truly pointing to the virtual server,
> and that the web server is running..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
|||It sounds like the app has an IP address hard coded in there somewhere. Are
you 100% sure it is using the Virtual server's name and not an IP address?
Andrew J. Kelly SQL MVP
"JohnnieO" <JohnnieO@.discussions.microsoft.com> wrote in message
news:D5A6C302-9E2C-4A4F-B16E-105651B602C8@.microsoft.com...
> We verified that the web server is pointed to the virtual server, but we
cannot connect to the SQL Server. Cluster Manager reports that everything
is working fine, and there was nothing in the cluster.log that indicated a
problem. Is there any way to check that the SQL Server was set-up correctly
during installation?[vbcol=seagreen]
> --
> Johnnie O.
> Computer Handyman
> Amateur Superhero
>
> "Wayne Snyder" wrote:
so,[vbcol=seagreen]
server,
>