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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment