Can't start SQL on 2005 Cluster

The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compre
ss the files on the drive that your instance is running on - not to be recom
mended as a rule.
When you attempt to start the instance the System event log gives the servic
e specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Progr
am Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed b
ut does not reside in a read-only database or filegroup. The file must be de
compressed."
I decompressed the files and the service started fine - something to conside
r.
Mark
From http://www.developmentnow.com/g/118...>
-Cluster.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Can't start SQL on 2005 Cluster

The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...Check out:
http://msdn2.microsoft.com/en-us/library/aa337262.aspx
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:185F94E0-9E8E-4048-A25B-7311CCDC9D96@.microsoft.com...
The SQL Server (MSSQLSERVER) service terminated with service-specific error
3417 (0xD59).
This is what I get on my 2005 Cluster when I try to start SQL on one of the
nodes. Another node is running fine, no problems what so ever.
Please help...|||I've found that a good way to inadvertently generate this error is to compress the files on the drive that your instance is running on - not to be recommended as a rule.
When you attempt to start the instance the System event log gives the service specific error 3417 as you've seen.
The Application event log was a bit more useful for me - "The file "D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed."
I decompressed the files and the service started fine - something to consider.
Mar
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||thanks for upstai
From http://www.developmentnow.com/g/118_2006_10_0_0_840331/Cant-start-SQL-on-2005-Cluster.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Can't start Query Analyzer on SQL Cluster

Have you experienced such problem in a Windows Cluster environment :
Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
Error : The Query Analyzer could not be started on the first node :
ISQLW.EXE - Entry Point Not Found
The procedure entry point ''? could not be located in the dynamic
link library SQLGUI.dll.>
> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise
Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ''? could not be located in the dynamic
> link library SQLGUI.dll.
--
It's possible the SQLGUI.DLL is corrupt. Rename the file in the cluster and
copy from a machine which works.
Hope this helps,
--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.|||> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ''? could not be located in the dynamic
> link library SQLGUI.dll.
>
>
How did you solve this problem?
User submitted from AEWNET (http://www.aewnet.com/)|||> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ''? could not be located in the dynamic
> link library SQLGUI.dll.
>
>
How did you solve this problem?
User submitted from AEWNET (http://www.aewnet.com/)

Can't start Query Analyzer on SQL Cluster

Have you experienced such problem in a Windows Cluster environment :
Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
Error : The Query Analyzer could not be started on the first node :
ISQLW.EXE - Entry Point Not Found
The procedure entry point ??? could not be located in the dynamic
link library SQLGUI.dll.
>
> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise
Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ??? could not be located in the dynamic
> link library SQLGUI.dll.
It's possible the SQLGUI.DLL is corrupt. Rename the file in the cluster and
copy from a machine which works.
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
|||
> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ??? could not be located in the dynamic
> link library SQLGUI.dll.
>
>
How did you solve this problem?
User submitted from AEWNET (http://www.aewnet.com/)
|||
> Have you experienced such problem in a Windows Cluster environment :
> Windows 2000 Advanced Server, SQL Cluster with MS SQL 7.0 Enterprise Edition
> Error : The Query Analyzer could not be started on the first node :
> ISQLW.EXE - Entry Point Not Found
> The procedure entry point ??? could not be located in the dynamic
> link library SQLGUI.dll.
>
>
How did you solve this problem?
User submitted from AEWNET (http://www.aewnet.com/)

Can't start engine

SQL Server 2000 cluster
While trying to move the master, model, etc db's I put trace flags into the
startup according to the instruction in:
http://support.microsoft.com/kb/224071
When that didn't work, I tried splitting the 3 args into 3 seperate options.
Now, I can't get in to change it back, the engine refuses to let me in:
Error:
A connection could not be established to _SERVER_
Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
in single user mode. Only one administrator can connect at a time.
I did get into the configuration settings once, though I'm not sure how, and
I thought I removed the options.How about removing "-m" from the startup parameters of your SQL Server
service?
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
"Jay" <nospan@.nospam.org> wrote in message
news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> SQL Server 2000 cluster
> While trying to move the master, model, etc db's I put trace flags into
> the startup according to the instruction in:
> http://support.microsoft.com/kb/224071
> When that didn't work, I tried splitting the 3 args into 3 seperate
> options. Now, I can't get in to change it back, the engine refuses to let
> me in:
> Error:
> A connection could not be established to _SERVER_
> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
> in single user mode. Only one administrator can connect at a time.
>
> I did get into the configuration settings once, though I'm not sure how,
> and I thought I removed the options.
>|||I can't get in!
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:FEC71DAB-8E4D-49B8-97B8-386038797D8A@.microsoft.com...
> How about removing "-m" from the startup parameters of your SQL Server
> service?
> --
> Ekrem Önsoy
> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
> MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to let
>> me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how,
>> and I thought I removed the options.
>|||I think I found the startup parameters in the registry (both nodes of the
cluster) in:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\parameters
But I know better than to do more than look in regedit.
"Jay" <nospan@.nospam.org> wrote in message
news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> SQL Server 2000 cluster
> While trying to move the master, model, etc db's I put trace flags into
> the startup according to the instruction in:
> http://support.microsoft.com/kb/224071
> When that didn't work, I tried splitting the 3 args into 3 seperate
> options. Now, I can't get in to change it back, the engine refuses to let
> me in:
> Error:
> A connection could not be established to _SERVER_
> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
> in single user mode. Only one administrator can connect at a time.
>
> I did get into the configuration settings once, though I'm not sure how,
> and I thought I removed the options.
>|||With the Windows admin, I tried to remove the -c -m -T3608 from the
registry. The primary node in the cluster refused to let me remove the
parameter and the secondary allowed the delete. When we restarted the
server, it was still in single user and a refresh in regedit on the
secondary showed the deleted options were back.
"Jay" <nospan@.nospam.org> wrote in message
news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> SQL Server 2000 cluster
> While trying to move the master, model, etc db's I put trace flags into
> the startup according to the instruction in:
> http://support.microsoft.com/kb/224071
> When that didn't work, I tried splitting the 3 args into 3 seperate
> options. Now, I can't get in to change it back, the engine refuses to let
> me in:
> Error:
> A connection could not be established to _SERVER_
> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
> in single user mode. Only one administrator can connect at a time.
>
> I did get into the configuration settings once, though I'm not sure how,
> and I thought I removed the options.
>|||Stop other services which connect to SQL Server. SQL Server Agent for
example...
Then you'd be the one who connects to SQL Server and then you'd be able to
change the setting?
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
"Jay" <nospan@.nospam.org> wrote in message
news:OowRKaaHIHA.4808@.TK2MSFTNGP05.phx.gbl...
>I can't get in!
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:FEC71DAB-8E4D-49B8-97B8-386038797D8A@.microsoft.com...
>> How about removing "-m" from the startup parameters of your SQL Server
>> service?
>> --
>> Ekrem Önsoy
>> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
>> MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
>>
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how,
>> and I thought I removed the options.
>>
>|||I did stop everything else. listed in the SQL Server Service Manager: SQL
agent, DTC, Full Text search and sonething else I don't recall right now.
Unless it's got something to do with the Cluster manager? I know that
sub-system has some control over SQL Server, but I'm really unfamilar with
it, the Windows admin set it up.
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:E4CA655D-3777-4AAA-BB8F-F305A064816B@.microsoft.com...
> Stop other services which connect to SQL Server. SQL Server Agent for
> example...
> Then you'd be the one who connects to SQL Server and then you'd be able to
> change the setting?
> --
> Ekrem Önsoy
> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
> MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:OowRKaaHIHA.4808@.TK2MSFTNGP05.phx.gbl...
>>I can't get in!
>> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> news:FEC71DAB-8E4D-49B8-97B8-386038797D8A@.microsoft.com...
>> How about removing "-m" from the startup parameters of your SQL Server
>> service?
>> --
>> Ekrem Önsoy
>> http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
>> MCBDA, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT
>>
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure
>> how, and I thought I removed the options.
>>
>>
>|||Still in need of help.
"Jay" <nospan@.nospam.org> wrote in message
news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> SQL Server 2000 cluster
> While trying to move the master, model, etc db's I put trace flags into
> the startup according to the instruction in:
> http://support.microsoft.com/kb/224071
> When that didn't work, I tried splitting the 3 args into 3 seperate
> options. Now, I can't get in to change it back, the engine refuses to let
> me in:
> Error:
> A connection could not be established to _SERVER_
> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
> in single user mode. Only one administrator can connect at a time.
>
> I did get into the configuration settings once, though I'm not sure how,
> and I thought I removed the options.
>|||Single user mode is the -m startup switch. Perhaps you removed that option in the registry from one
of the nodes but no the other. I would connect using regedit and verify the setting for all nodes...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospan@.nospam.org> wrote in message news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
> Still in need of help.
> "Jay" <nospan@.nospam.org> wrote in message news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into the startup according to
>> the instruction in: http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate options. Now, I can't get in
>> to change it back, the engine refuses to let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how, and I thought I removed
>> the options.
>|||If regedit allows me to change it, am I changing the registry in the correct
localtion? Sounds like it.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
> Single user mode is the -m startup switch. Perhaps you removed that option
> in the registry from one of the nodes but no the other. I would connect
> using regedit and verify the setting for all nodes...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how,
>> and I thought I removed the options.
>>
>|||I'm not sure you want to *change* it using regedit. My gut feeling was to check using regedit to
verify if this was the issue. I would assume that Enterprise Manager would change it for you on all
nodes. Or possibly the cluster support in Windows will take care of that for you (regardless of what
tool you use to make that change). I'd try EM first, and if that doesn't help, use regedit, and
verify all nodes...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospan@.nospam.org> wrote in message news:OqUUt58HIHA.4712@.TK2MSFTNGP04.phx.gbl...
> If regedit allows me to change it, am I changing the registry in the correct localtion? Sounds
> like it.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
>> Single user mode is the -m startup switch. Perhaps you removed that option in the registry from
>> one of the nodes but no the other. I would connect using regedit and verify the setting for all
>> nodes...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Jay" <nospan@.nospam.org> wrote in message news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into the startup according
>> to the instruction in: http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate options. Now, I can't get
>> in to change it back, the engine refuses to let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how, and I thought I
>> removed the options.
>>
>>
>|||OK Tibor, regedit did allow me to remove just the -m flag. I was then able
to get into properties and remove the other two. The genesis of my issue was
that I could not get into the properties in the first place. I would guess
that this is VERY unusual as both you and Ekrem continue to suggest I change
the options via properties\startup options, despite my continuing to repeat
that I couldn't get in.
I'm OK now, thanks Tibor and Ekrem. I suppose I can be a bit of a pill when
stressed.
The part that is very disturbing is that upon researching the command line
options provided and the experience applying them, there are three mistakes
in the Microsoft kb article.
1) The arguments are presented as if you put them all in, one entry when you
need to do each one separately.
2) -T3608 should be /T3608
3) -m is not necessary in SQL Server 2000 (and is what caused so much of the
problem)
The other two Admins (and our manager, who used to be an Admin) got a good
laugh at me for the faith I had in the Microsoft kb article. It seems that
they have gotten bad instructions many times before.
Last, kicking and screaming, I've now learned a little about the Windows
registry.
Thanks,
Jay
PS. I have now moved the model database and will do the others shortly.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
> Single user mode is the -m startup switch. Perhaps you removed that option
> in the registry from one of the nodes but no the other. I would connect
> using regedit and verify the setting for all nodes...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into
>> the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how,
>> and I thought I removed the options.
>>
>|||> I would guess that this is VERY unusual as both you and Ekrem continue to suggest I change the
> options via properties\startup options, despite my continuing to repeat that I couldn't get in.
Sorry, I missed that part...
> The part that is very disturbing is that upon researching the command line options provided and
> the experience applying them, there are three mistakes in the Microsoft kb article.
Was it KB 224071?
> 1) The arguments are presented as if you put them all in, one entry when you need to do each one
> separately.
Perhaps the article assumes that you use EM and EM represents the arguments as one on each line,
while you modified the registry directly which represents the information differently? I guess the
KB could have a few words about the difference between EM's representation and how it looks like in
regedit...
> 2) -T3608 should be /T3608
My experience is that dash or slash makes no difference for the various SQL Server exe files that
reads command line options...
A tip: Make sure that you managed to get the proper dbid for model (check sysdatabases). I believe
it need to be 3. As I remember, SQL Server uses the dbid for the model database, not the name of the
database. Which means that you will get whacky behavior when you create new databases if model isn't
3...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospan@.nospam.org> wrote in message news:eulAKH9HIHA.4296@.TK2MSFTNGP04.phx.gbl...
> OK Tibor, regedit did allow me to remove just the -m flag. I was then able to get into properties
> and remove the other two. The genesis of my issue was that I could not get into the properties in
> the first place. I would guess that this is VERY unusual as both you and Ekrem continue to suggest
> I change the options via properties\startup options, despite my continuing to repeat that I
> couldn't get in.
> I'm OK now, thanks Tibor and Ekrem. I suppose I can be a bit of a pill when stressed.
> The part that is very disturbing is that upon researching the command line options provided and
> the experience applying them, there are three mistakes in the Microsoft kb article.
> 1) The arguments are presented as if you put them all in, one entry when you need to do each one
> separately.
> 2) -T3608 should be /T3608
> 3) -m is not necessary in SQL Server 2000 (and is what caused so much of the problem)
> The other two Admins (and our manager, who used to be an Admin) got a good laugh at me for the
> faith I had in the Microsoft kb article. It seems that they have gotten bad instructions many
> times before.
> Last, kicking and screaming, I've now learned a little about the Windows registry.
> Thanks,
> Jay
> PS. I have now moved the model database and will do the others shortly.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
>> Single user mode is the -m startup switch. Perhaps you removed that option in the registry from
>> one of the nodes but no the other. I would connect using regedit and verify the setting for all
>> nodes...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Jay" <nospan@.nospam.org> wrote in message news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags into the startup according
>> to the instruction in: http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate options. Now, I can't get
>> in to change it back, the engine refuses to let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure how, and I thought I
>> removed the options.
>>
>>
>|||> Was it KB 224071?
yes.
...
> A tip: Make sure that you managed to get the proper dbid for model (check
> sysdatabases). I believe it need to be 3. As I remember, SQL Server uses
> the dbid for the model database, not the name of the database. Which means
> that you will get whacky behavior when you create new databases if model
> isn't 3...
Yes, model is dbid 3.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospan@.nospam.org> wrote in message
> news:eulAKH9HIHA.4296@.TK2MSFTNGP04.phx.gbl...
>> OK Tibor, regedit did allow me to remove just the -m flag. I was then
>> able to get into properties and remove the other two. The genesis of my
>> issue was that I could not get into the properties in the first place. I
>> would guess that this is VERY unusual as both you and Ekrem continue to
>> suggest I change the options via properties\startup options, despite my
>> continuing to repeat that I couldn't get in.
>> I'm OK now, thanks Tibor and Ekrem. I suppose I can be a bit of a pill
>> when stressed.
>> The part that is very disturbing is that upon researching the command
>> line options provided and the experience applying them, there are three
>> mistakes in the Microsoft kb article.
>> 1) The arguments are presented as if you put them all in, one entry when
>> you need to do each one separately.
>> 2) -T3608 should be /T3608
>> 3) -m is not necessary in SQL Server 2000 (and is what caused so much of
>> the problem)
>> The other two Admins (and our manager, who used to be an Admin) got a
>> good laugh at me for the faith I had in the Microsoft kb article. It
>> seems that they have gotten bad instructions many times before.
>> Last, kicking and screaming, I've now learned a little about the Windows
>> registry.
>> Thanks,
>> Jay
>> PS. I have now moved the model database and will do the others shortly.
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
>> Single user mode is the -m startup switch. Perhaps you removed that
>> option in the registry from one of the nodes but no the other. I would
>> connect using regedit and verify the setting for all nodes...
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
>> Still in need of help.
>> "Jay" <nospan@.nospam.org> wrote in message
>> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
>> SQL Server 2000 cluster
>> While trying to move the master, model, etc db's I put trace flags
>> into the startup according to the instruction in:
>> http://support.microsoft.com/kb/224071
>> When that didn't work, I tried splitting the 3 args into 3 seperate
>> options. Now, I can't get in to change it back, the engine refuses to
>> let me in:
>> Error:
>> A connection could not be established to _SERVER_
>> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
>> is
>> in single user mode. Only one administrator can connect at a time.
>>
>> I did get into the configuration settings once, though I'm not sure
>> how, and I thought I removed the options.
>>
>>
>>
>|||Just wanted to say thanks to all who contributed to this thread. I ran into
this exact same issue today and was able to fix it the same way Jay
ultimately did. You've saved me potentially countless hours of trial and
error. Many thanks!
"Jay" wrote:
> > Was it KB 224071?
> yes.
> ...
> >
> > A tip: Make sure that you managed to get the proper dbid for model (check
> > sysdatabases). I believe it need to be 3. As I remember, SQL Server uses
> > the dbid for the model database, not the name of the database. Which means
> > that you will get whacky behavior when you create new databases if model
> > isn't 3...
> Yes, model is dbid 3.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://sqlblog.com/blogs/tibor_karaszi
> >
> >
> > "Jay" <nospan@.nospam.org> wrote in message
> > news:eulAKH9HIHA.4296@.TK2MSFTNGP04.phx.gbl...
> >> OK Tibor, regedit did allow me to remove just the -m flag. I was then
> >> able to get into properties and remove the other two. The genesis of my
> >> issue was that I could not get into the properties in the first place. I
> >> would guess that this is VERY unusual as both you and Ekrem continue to
> >> suggest I change the options via properties\startup options, despite my
> >> continuing to repeat that I couldn't get in.
> >>
> >> I'm OK now, thanks Tibor and Ekrem. I suppose I can be a bit of a pill
> >> when stressed.
> >>
> >> The part that is very disturbing is that upon researching the command
> >> line options provided and the experience applying them, there are three
> >> mistakes in the Microsoft kb article.
> >>
> >> 1) The arguments are presented as if you put them all in, one entry when
> >> you need to do each one separately.
> >> 2) -T3608 should be /T3608
> >> 3) -m is not necessary in SQL Server 2000 (and is what caused so much of
> >> the problem)
> >>
> >> The other two Admins (and our manager, who used to be an Admin) got a
> >> good laugh at me for the faith I had in the Microsoft kb article. It
> >> seems that they have gotten bad instructions many times before.
> >>
> >> Last, kicking and screaming, I've now learned a little about the Windows
> >> registry.
> >>
> >> Thanks,
> >> Jay
> >>
> >> PS. I have now moved the model database and will do the others shortly.
> >>
> >> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> >> in message news:3F379085-1621-4BE3-BC32-93A3A921566D@.microsoft.com...
> >> Single user mode is the -m startup switch. Perhaps you removed that
> >> option in the registry from one of the nodes but no the other. I would
> >> connect using regedit and verify the setting for all nodes...
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "Jay" <nospan@.nospam.org> wrote in message
> >> news:%23ZIDnu8HIHA.3956@.TK2MSFTNGP04.phx.gbl...
> >> Still in need of help.
> >>
> >> "Jay" <nospan@.nospam.org> wrote in message
> >> news:uvHnERaHIHA.4956@.TK2MSFTNGP06.phx.gbl...
> >> SQL Server 2000 cluster
> >>
> >> While trying to move the master, model, etc db's I put trace flags
> >> into the startup according to the instruction in:
> >> http://support.microsoft.com/kb/224071
> >>
> >> When that didn't work, I tried splitting the 3 args into 3 seperate
> >> options. Now, I can't get in to change it back, the engine refuses to
> >> let me in:
> >>
> >> Error:
> >>
> >> A connection could not be established to _SERVER_
> >> Reason: Login failed for user 'DOMAIN\USERNAME'. Reason: Server
> >> is
> >> in single user mode. Only one administrator can connect at a time.
> >>
> >>
> >> I did get into the configuration settings once, though I'm not sure
> >> how, and I thought I removed the options.
> >>
> >>
> >>
> >>
> >>
> >>
> >
>
>

Can't setup replication: Encryption error using CryptProtectData?

I am trying to setup replication but am having the following issues
Publisher:
SQL 2005 SP1 Enterprise Cluster (Active, Passive)
Subscriber:
SQL 2005 SP1 Enterprise


When trying to create a publication or subsubscription running under a Windows Domain account the following error message appears:

Replication-Replication Distribution Subsystem: agent ECHO\ECHO-InsDB-INS_CMS_PUB-HARPO-58 failed. Unable to start execution of step 2 (reason: Error authenticating proxy DETINI\srvRep_user, system error: Logon failure: unknown user name or bad password.). The step failed.

Further in the SQL logs we find that the above message is due to:

[298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]

It appears that when Credentials for the agent proxy are being created that this message occurs. So when the SP that tries to run the agent (snapshot or distrobution) is called it always returns incorrect password details.

The Credentials do appear to be created, they are visible via SQL Studio, but you can't see the password. Changing the password via SQL Studio does not work as the Credentials are recreated every time.

I have checked the following:

MSDTC is running correctly
The Domain Account has the correct privileges to run these services
Regenerated the Service Master Key
Created Master Keys in each database effected by replication
Ensure SQL Service accounts have access to decrypt the Service Master Key
I can create a Publication and Subscription using the local system account on the cluster

Does anyone have any idea ?

Chris

Chirs,

My testing environment is the same as yours - the publisher/distributer is clustered SQL2005 enterprise with SP1 on windows 2003, and the subscriber is SQL2005 enterprise on 2003 server, and I have got the same error when I was trying to run the creating snapshot job. The only workaround I found was to put the distributor on the same server as the publisher, and use a local directory for shapshot folder, which was not ideal, but at least I could continue with my test. Then I had the same error again when I ran the push distribution job using a domain ammount. I had to change the security to use SQL agent account, which is a domain admin account.

I would like to know how to avoid the error too, since I want the distributor to be on a different machine than the publisher, and limit the rights of the credentials on the production environments.

Ying

sql

Can't setup replication: Encryption error using CryptProtectData?

I am trying to setup replication but am having the following issues
Publisher:
SQL 2005 SP1 Enterprise Cluster (Active, Passive)
Subscriber:
SQL 2005 SP1 Enterprise


When trying to create a publication or subsubscription running under a Windows Domain account the following error message appears:

Replication-Replication Distribution Subsystem: agent ECHO\ECHO-InsDB-INS_CMS_PUB-HARPO-58 failed. Unable to start execution of step 2 (reason: Error authenticating proxy DETINI\srvRep_user, system error: Logon failure: unknown user name or bad password.). The step failed.

Further in the SQL logs we find that the above message is due to:

[298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]

It appears that when Credentials for the agent proxy are being created that this message occurs. So when the SP that tries to run the agent (snapshot or distrobution) is called it always returns incorrect password details.

The Credentials do appear to be created, they are visible via SQL Studio, but you can't see the password. Changing the password via SQL Studio does not work as the Credentials are recreated every time.

I have checked the following:

MSDTC is running correctly
The Domain Account has the correct privileges to run these services
Regenerated the Service Master Key
Created Master Keys in each database effected by replication
Ensure SQL Service accounts have access to decrypt the Service Master Key
I can create a Publication and Subscription using the local system account on the cluster

Does anyone have any idea ?

Chris

Chirs,

My testing environment is the same as yours - the publisher/distributer is clustered SQL2005 enterprise with SP1 on windows 2003, and the subscriber is SQL2005 enterprise on 2003 server, and I have got the same error when I was trying to run the creating snapshot job. The only workaround I found was to put the distributor on the same server as the publisher, and use a local directory for shapshot folder, which was not ideal, but at least I could continue with my test. Then I had the same error again when I ran the push distribution job using a domain ammount. I had to change the security to use SQL agent account, which is a domain admin account.

I would like to know how to avoid the error too, since I want the distributor to be on a different machine than the publisher, and limit the rights of the credentials on the production environments.

Ying

Can't see all drives in a cluster within Enterprise manager

When I am in Enterprise Manager to create a new database, I click on the location of the data and log file, I only see 1 drive where SQL Server was installed...How do I get SQL Server to display all the other drives the node owns in the cluster? I can view them under My Computer and within the Cluster Administrator. Each node owns it's own drives. But I should be able to see all drives owned by the node when browsing to create a new database so I can assign different drives for the Data and Log files.
Any ideas would be helpful
Thanks
WarrenPerhaps you have to restart SQL Server?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:B873E1EB-030A-41F4-910A-1F15FE1A2D7B@.microsoft.com...
> When I am in Enterprise Manager to create a new database, I click on the location of the data and
log file, I only see 1 drive where SQL Server was installed...How do I get SQL Server to display all
the other drives the node owns in the cluster? I can view them under My Computer and within the
Cluster Administrator. Each node owns it's own drives. But I should be able to see all drives
owned by the node when browsing to create a new database so I can assign different drives for the
Data and Log files..
> Any ideas would be helpful,
> Thanks,
> Warren|||Dear Tibor
I will try it and let you know
Thanks
Warren|||Dear Tibor,
Same result. Still can't see all the drives?|||Sorry, that was just a wild guess...
Re-reading your original post, you say that you only see the drive where SQL Server was installed.
Do you mean the local drive? That would imply, methinks, that you didn't install the SQL Server as a
clustered SQL Server. SQL Server should not show the local drives when creating databases etc, it
should only show the "shared" drives.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:7B544C67-CF57-4D8B-B726-3C259486A975@.microsoft.com...
> Dear Tibor,
> Same result. Still can't see all the drives?|||I found the answer. After a successful install of SQL Server on the cluster and testing fail-over. You have to take one node off-line and add dependencies (IE. the other drives) to the SQl Server , bring that node back on-line and repeat for the other node. This should be your last step then, re-test failover and moving the cluster between nodes
Whew
Thanks
Warren

Can't see all drives in a cluster within Enterprise manager

When I am in Enterprise Manager to create a new database, I click on the loc
ation of the data and log file, I only see 1 drive where SQL Server was inst
alled...How do I get SQL Server to display all the other drives the node own
s in the cluster? I can vi
ew them under My Computer and within the Cluster Administrator. Each node o
wns it's own drives. But I should be able to see all drives owned by the no
de when browsing to create a new database so I can assign different drives f
or the Data and Log files..
Any ideas would be helpful,
Thanks,
WarrenPerhaps you have to restart SQL Server?
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:B873E1EB-030A-41F4-910A-1F15FE1A2D7B@.microsoft.com...

quote:

---

> When I am in Enterprise Manager to create a new database, I click on the location of the d
ata and

---

log file, I only see 1 drive where SQL Server was installed...How do I get S
QL Server to display all
the other drives the node owns in the cluster? I can view them under My Com
puter and within the
Cluster Administrator. Each node owns it's own drives. But I should be abl
e to see all drives
owned by the node when browsing to create a new database so I can assign dif
ferent drives for the
Data and Log files..

quote:

---

> Any ideas would be helpful,
> Thanks,
> Warren

---

|||Dear Tibor,
I will try it and let you know.
Thanks,
Warren|||Dear Tibor,
Same result. Still can't see all the drives?|||Sorry, that was just a wild guess...
Re-reading your original post, you say that you only see the drive where SQL
Server was installed.
Do you mean the local drive? That would imply, methinks, that you didn't ins
tall the SQL Server as a
clustered SQL Server. SQL Server should not show the local drives when creat
ing databases etc, it
should only show the "shared" drives.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Warren Tyler" <anonymous@.discussions.microsoft.com> wrote in message
news:7B544C67-CF57-4D8B-B726-3C259486A975@.microsoft.com...

quote:

---

> Dear Tibor,
> Same result. Still can't see all the drives?

---

|||I found the answer. After a successful install of SQL Server on the cluster
and testing fail-over. You have to take one node off-line and add dependen
cies (IE. the other drives) to the SQl Server , bring that node back on-line
and repeat for the other n
ode. This should be your last step then, re-test failover and moving the cl
uster between nodes.
Whew!
Thanks,
Warren

Cant register to a named instance

2nd instance of sql was sucessfully installed on the 2nd node of the
cluster. However if i try to register on this 2nd instance it failes with
msg as sql server does not exists or access denied. I tried with the Ip
address too but it fails with same error. I havent installed sp3a on this
instance was trying to get the instance up and running but the initial step
only fails. Has anyone seen this before. any help will be greatly
appreciated. TIA
--
Message posted via http://www.sqlmonster.comHive you seen
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/MultipleInstances.asp ?
Peter
"I favor the Civil Rights Act of 1964 and it must be enforced at gunpoint if
necessary."
Ronald Reagan
"ishaan99 via SQLMonster.com" wrote:
> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>|||Hi
You might need to add an alias using the SQL Server client network utility.
You can find it in your SQL Server programs group.
What you need to put in depends on your network protocols. We use either
TCP/IP or named pipes. For TCP/IP you need to supply 'server name\instance
name' and the port that SQL Server is running on. For named pipes supply the
server name\instance name.
You then should be able to access the named instance.
Hope this helps
John
"ishaan99 via SQLMonster.com" wrote:
> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>|||Thanks but I did try adding an alias from client n/w . also tried using
osql with servername\instancename but i get the same error. However I could
see 2nd instance of sql server and sql agent running from 2nd node services
though. My 2nd node accesses 4 drives and i have all system files on one of
these 4 drives but MSSQL$2INSTANCE is under c:\ProgramFiles.... Has it got
anyting to do with installation? Since i am not able to isql to this server
I feel is sql itself is failing.. any thoughts on this'
--
Message posted via http://www.sqlmonster.com|||This what i see after trying from osql
Unable to connect: SQL Server is unavailable or does not exists. Net-
library error 2: ConnectionOpen (Connect())
--
Message posted via http://www.sqlmonster.com|||Have you looked at the SQL Server logs.
It should tell what types of client connections can be made (if you are
using TCP/IP what ports are being used etc).
e.g. my log has the following lines in it
SQL server listening on 127.0.0.1: 2433
SQL server listening on 169.254.151.241: 2433
...
SQL server listening on TCP, Shared Memory, Named Pipes
"ishaan99 via SQLMonster.com" wrote:
> 2nd instance of sql was sucessfully installed on the 2nd node of the
> cluster. However if i try to register on this 2nd instance it failes with
> msg as sql server does not exists or access denied. I tried with the Ip
> address too but it fails with same error. I havent installed sp3a on this
> instance was trying to get the instance up and running but the initial step
> only fails. Has anyone seen this before. any help will be greatly
> appreciated. TIA
> --
> Message posted via http://www.sqlmonster.com
>

Can't ping cluster - need help

Recently set up a cluster and it seems to be working up to a point.
Have run into a problem trying to ping the cluster IP address from a
node not owning any resources, or from outside the cluster. Pinging
from the node that owns everything works, and if I move over the MSDTC
then the second node works.
I have read through books on line and a bunch of kb articles, think
everything is configured correctly, can't figure out what to do next.
Anyone have any thoughts?
Ultimately I want to install SQLServer, but the installation fails, and
I think I need to fix this problem before digging into the sql setup.
Any help would be appreciated.
Mike
If a node owns the group, that means that the IP address is bound to his own
interface. In other words, the TCP/IP packet won't leave the NIC and you
always will get replies. If you cannot ping it from even the other node, then,
- Check connectivity to your switches
- try pinging to the gateway
- Is ping allowed (firewalls, ...)
Chau chau,
Pascalos
"Mike G." wrote:

> Recently set up a cluster and it seems to be working up to a point.
> Have run into a problem trying to ping the cluster IP address from a
> node not owning any resources, or from outside the cluster. Pinging
> from the node that owns everything works, and if I move over the MSDTC
> then the second node works.
> I have read through books on line and a bunch of kb articles, think
> everything is configured correctly, can't figure out what to do next.
> Anyone have any thoughts?
> Ultimately I want to install SQLServer, but the installation fails, and
> I think I need to fix this problem before digging into the sql setup.
> Any help would be appreciated.
> Mike
>

Can't make Remote Connection to SQL Cluster

Have got multiple SQL environments, both 2000 & 2005. Of these two are
clusters, one 2000 & one 2005.
Over remote VPN connection I can connect to every non-clustered server but
can't to either cluster. I've made sure that local & remote connections are
enabled on the clusters.
I have no problems connecting to both clusters on my local network so I'm
definitely connecting with the correct virtual servername.
Anybody had this issue before?
Thanks, Andy.Hi Andy
Although I have never tried this I don't think there should be anything that
stops you doing it. How are you connecting to the Clustered instance
(connection string or SQLCMD command) ? Which protocol are you using/enabled
?
Which port is being used? Are there any firewalls? Is the name being
resolved/can you connect to the IP address?
John
"AndyT" wrote:

> Have got multiple SQL environments, both 2000 & 2005. Of these two are
> clusters, one 2000 & one 2005.
> Over remote VPN connection I can connect to every non-clustered server but
> can't to either cluster. I've made sure that local & remote connections ar
e
> enabled on the clusters.
> I have no problems connecting to both clusters on my local network so I'm
> definitely connecting with the correct virtual servername.
> Anybody had this issue before?
> Thanks, Andy.
>
>|||Have you tried connecting to one of the clustered instances from a node
within the cluster that currently does not currently own the SQL Server
instance (the so-called "passive") node? If that works, then I wonder if
there is a firewall rule between where you are and where the cluster is that
is preventing you from getting to the cluster. However, if you can't get to
SQL server from another node in the cluster, it suggests that SQL is not
listening for remote connections. Be sure to check the SQL Server error
log. It says what protocols it's actually listening on. Be sure to do a
tracert on the SQL Server virtual IP.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"AndyT" <tipton@.tpg.com.au> wrote in message
news:ukMBqehNIHA.4740@.TK2MSFTNGP02.phx.gbl...
Have got multiple SQL environments, both 2000 & 2005. Of these two are
clusters, one 2000 & one 2005.
Over remote VPN connection I can connect to every non-clustered server but
can't to either cluster. I've made sure that local & remote connections are
enabled on the clusters.
I have no problems connecting to both clusters on my local network so I'm
definitely connecting with the correct virtual servername.
Anybody had this issue before?
Thanks, Andy.|||Could be a firewall issue. When you connect to a cluster, it listens on the
virtual IP. Replies are sent from the regular IP address, according to the
packet headers. This drives some firewalls batty. See your network admin
about allowing the physical IP as well as the virtual one to have access
from the outside.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"AndyT" <tipton@.tpg.com.au> wrote in message
news:ukMBqehNIHA.4740@.TK2MSFTNGP02.phx.gbl...
> Have got multiple SQL environments, both 2000 & 2005. Of these two are
> clusters, one 2000 & one 2005.
> Over remote VPN connection I can connect to every non-clustered server but
> can't to either cluster. I've made sure that local & remote connections
> are enabled on the clusters.
> I have no problems connecting to both clusters on my local network so I'm
> definitely connecting with the correct virtual servername.
> Anybody had this issue before?
> Thanks, Andy.
>

Can't make Remote Connection to SQL Cluster

Have got multiple SQL environments, both 2000 & 2005. Of these two are
clusters, one 2000 & one 2005.
Over remote VPN connection I can connect to every non-clustered server but
can't to either cluster. I've made sure that local & remote connections are
enabled on the clusters.
I have no problems connecting to both clusters on my local network so I'm
definitely connecting with the correct virtual servername.
Anybody had this issue before?
Thanks, Andy.Hi Andy
Although I have never tried this I don't think there should be anything that
stops you doing it. How are you connecting to the Clustered instance
(connection string or SQLCMD command) ? Which protocol are you using/enabled?
Which port is being used? Are there any firewalls? Is the name being
resolved/can you connect to the IP address?
John
"AndyT" wrote:
> Have got multiple SQL environments, both 2000 & 2005. Of these two are
> clusters, one 2000 & one 2005.
> Over remote VPN connection I can connect to every non-clustered server but
> can't to either cluster. I've made sure that local & remote connections are
> enabled on the clusters.
> I have no problems connecting to both clusters on my local network so I'm
> definitely connecting with the correct virtual servername.
> Anybody had this issue before?
> Thanks, Andy.
>
>|||Have you tried connecting to one of the clustered instances from a node
within the cluster that currently does not currently own the SQL Server
instance (the so-called "passive") node? If that works, then I wonder if
there is a firewall rule between where you are and where the cluster is that
is preventing you from getting to the cluster. However, if you can't get to
SQL server from another node in the cluster, it suggests that SQL is not
listening for remote connections. Be sure to check the SQL Server error
log. It says what protocols it's actually listening on. Be sure to do a
tracert on the SQL Server virtual IP.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"AndyT" <tipton@.tpg.com.au> wrote in message
news:ukMBqehNIHA.4740@.TK2MSFTNGP02.phx.gbl...
Have got multiple SQL environments, both 2000 & 2005. Of these two are
clusters, one 2000 & one 2005.
Over remote VPN connection I can connect to every non-clustered server but
can't to either cluster. I've made sure that local & remote connections are
enabled on the clusters.
I have no problems connecting to both clusters on my local network so I'm
definitely connecting with the correct virtual servername.
Anybody had this issue before?
Thanks, Andy.|||Could be a firewall issue. When you connect to a cluster, it listens on the
virtual IP. Replies are sent from the regular IP address, according to the
packet headers. This drives some firewalls batty. See your network admin
about allowing the physical IP as well as the virtual one to have access
from the outside.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"AndyT" <tipton@.tpg.com.au> wrote in message
news:ukMBqehNIHA.4740@.TK2MSFTNGP02.phx.gbl...
> Have got multiple SQL environments, both 2000 & 2005. Of these two are
> clusters, one 2000 & one 2005.
> Over remote VPN connection I can connect to every non-clustered server but
> can't to either cluster. I've made sure that local & remote connections
> are enabled on the clusters.
> I have no problems connecting to both clusters on my local network so I'm
> definitely connecting with the correct virtual servername.
> Anybody had this issue before?
> Thanks, Andy.
>

Can't get SQL 2000 installed on new node in Cluster

We can't get SQL 2000 to load on the new node (successfully added to the cluster). We are using the procedure How to add nodes to an existing virtual server (Setup)(from BOL). When asked for computer name we entered the SQL cluster name for the virtual
server. When asked for the logon we used the id used to log both nodes on the domain (Domain Admin & member of Adminisytrators group on both servers). Got a screen asking for the passwords for the ids for MSSQLSERVER & SQLSERVER AGENT. (screen was not e
xpected).
Environment: Windows 2000 Advanced server active/passive two node cluster. Active node has SQL 2000 SP2 with Security Patch 0655. The new node was successfully added to the cluster. We are trying to push SQL 2000 to the new node. The CD we are using
is SQL2000 Enterprise edition with no service packs. Once we get SQL on the new node and failover to it, we are going to apply SQL 2000 SP3. After that we will start the process of evicting the current node and getting a new Windows 2003 node to join th
e cluster. Once SQL 2000 is on that node and we failover to that node, the node we just added will be upgraded to Windows 2003. We have Q811272 on registry hack when the operating systems of the cluster servers are different and Q 294209 & Q 301600 on m
oving the MSDTC resource from the cluster group to the SQL group.
We would like to know if we are using the correct procedure, if it contains all the steps and we are entering the correct information? Plus what's with the screen asking for the MSSQLSERVER and SQLSERVERAGENT services password.
We would also like to know if the apps using the databases should be down during the install. Can't find that anywhere except for applying service packs.
Ok, You guys are really trying. Major kudos for the detailed post.
Ok, here are my notes.
Computer name = new host name, not virtual servername. The cluster install
already asked for the instance name on a prior screen.
Login info: I prefer to use the SA login, avoiding any NT permissions
issues. assuming your cluster is in mixed mode.
SQL Service packs. Run the SP from the node that owns the SQL group. It
WILL take the server offline while the SP is applied. Get over it. You MUST
apply SP3 or SP3 a before upgrading to Windows 2003.
MSDTC:. Win2000 best practices - put it in the cluster group. Win2003 Best
Practices = make a new group. Practical experiance = I have not seen, nor
heard of a situation where it made a difference.
The real difficulty is going to be making sure that 2003 can access the
shared storage. Drivers are critical.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pat Hall" <anonymous@.discussions.microsoft.com> wrote in message
news:0D42B568-1D29-4577-9FA9-327FBF09CC3D@.microsoft.com...
> We can't get SQL 2000 to load on the new node (successfully added to the
cluster). We are using the procedure How to add nodes to an existing
virtual server (Setup)(from BOL). When asked for computer name we entered
the SQL cluster name for the virtual server. When asked for the logon we
used the id used to log both nodes on the domain (Domain Admin & member of
Adminisytrators group on both servers). Got a screen asking for the
passwords for the ids for MSSQLSERVER & SQLSERVER AGENT. (screen was not
expected).
> Environment: Windows 2000 Advanced server active/passive two node
cluster. Active node has SQL 2000 SP2 with Security Patch 0655. The new
node was successfully added to the cluster. We are trying to push SQL 2000
to the new node. The CD we are using is SQL2000 Enterprise edition with no
service packs. Once we get SQL on the new node and failover to it, we are
going to apply SQL 2000 SP3. After that we will start the process of
evicting the current node and getting a new Windows 2003 node to join the
cluster. Once SQL 2000 is on that node and we failover to that node, the
node we just added will be upgraded to Windows 2003. We have Q811272 on
registry hack when the operating systems of the cluster servers are
different and Q 294209 & Q 301600 on moving the MSDTC resource from the
cluster group to the SQL group.
> We would like to know if we are using the correct procedure, if it
contains all the steps and we are entering the correct information? Plus
what's with the screen asking for the MSSQLSERVER and SQLSERVERAGENT
services password.
> We would also like to know if the apps using the databases should be down
during the install. Can't find that anywhere except for applying service
packs.
|||Thanks for the info. NOTE: The questions asked relate to getting SQL on the new node not applying SP3. I figure applying SP3 will be the easist part. And yes I know the apps need to be down and can get a window to do that.
Several questions on getting SQL on the new node:
The Computer Name screen says it wants the name of the "virtual server" there is a later screen (Cluster Management) where we provide the name of the new server. So which of the two virtual server names do we use: the one for the MSCS cluster or the on
e for the SQL cluster? We used the SQL Clsuter name.
The login requested has to have administrator priviledges on both servers which tells me that SA is not the id to use.
What about the screen that showed up that wasn't in the procedure? It asked for the passwords for the ids used for the two services SQL uses.
Do the apps using these databases need to be down when we install SQL on the new node? They can be if needed.
On your comment about the drivers: Our SAN is EMC Symmetrix. The current working node has 2 HBAs & PowerPath (lets computer know the HBAs point to the same disk) the new node has one HBA and no PowerPath plus the nodes have different drivers & firmware
for the HBAs. Based on your comment, I get the feeling that failover won't work. Is this correct? By the way the new node is in the cluster. When we use Disk Management it has an entry for the SAN disk; however, we don't know if it will see the SAN di
sk correctly yet since we can't failover without SQL. Or can we?
Pat Hall
Sr. Database Administrator
pat.hall@.gilbarco.com
-- Geoff N. Hiten wrote: --
Ok, You guys are really trying. Major kudos for the detailed post.
Ok, here are my notes.
Computer name = new host name, not virtual servername. The cluster install
already asked for the instance name on a prior screen.
Login info: I prefer to use the SA login, avoiding any NT permissions
issues. assuming your cluster is in mixed mode.
SQL Service packs. Run the SP from the node that owns the SQL group. It
WILL take the server offline while the SP is applied. Get over it. You MUST
apply SP3 or SP3 a before upgrading to Windows 2003.
MSDTC:. Win2000 best practices - put it in the cluster group. Win2003 Best
Practices = make a new group. Practical experiance = I have not seen, nor
heard of a situation where it made a difference.
The real difficulty is going to be making sure that 2003 can access the
shared storage. Drivers are critical.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pat Hall" <anonymous@.discussions.microsoft.com> wrote in message
news:0D42B568-1D29-4577-9FA9-327FBF09CC3D@.microsoft.com...
> We can't get SQL 2000 to load on the new node (successfully added to the
cluster). We are using the procedure How to add nodes to an existing
virtual server (Setup)(from BOL). When asked for computer name we entered
the SQL cluster name for the virtual server. When asked for the logon we
used the id used to log both nodes on the domain (Domain Admin & member of
Adminisytrators group on both servers). Got a screen asking for the
passwords for the ids for MSSQLSERVER & SQLSERVER AGENT. (screen was not
expected).[vbcol=seagreen]
cluster. Active node has SQL 2000 SP2 with Security Patch 0655. The new
node was successfully added to the cluster. We are trying to push SQL 2000
to the new node. The CD we are using is SQL2000 Enterprise edition with no
service packs. Once we get SQL on the new node and failover to it, we are
going to apply SQL 2000 SP3. After that we will start the process of
evicting the current node and getting a new Windows 2003 node to join the
cluster. Once SQL 2000 is on that node and we failover to that node, the
node we just added will be upgraded to Windows 2003. We have Q811272 on
registry hack when the operating systems of the cluster servers are
different and Q 294209 & Q 301600 on moving the MSDTC resource from the
cluster group to the SQL group.[vbcol=seagreen]
contains all the steps and we are entering the correct information? Plus
what's with the screen asking for the MSSQLSERVER and SQLSERVERAGENT
services password.[vbcol=seagreen]
during the install. Can't find that anywhere except for applying service
packs.
|||You can apply a service pack to a new node without taking the Virtual SQL
server offline. This is possible if the SP has already been applied to the
virtual server. See the README file for details.
When the install is asking for a virtual server name, it means the SQL
virtual server.
Install needs the passwords to create the services correctly on the new
node.
I use EMC Clariion gear and am familiar with the PowerPath software. The
system should failover correctly as long as the new node can see the virtual
disks. Ideally, the nodes should be identical, but during a transition,
this isn't always possible. I would create a small temporary LUN on the SAN
and add it to whatever group you are using on the SAN to present LUNS to
this host collection. You can then format it and make it a clustered
physical disk resource. Put it into a new, temporary virtual server (name,
disk, and IP only) that you manually create. You can then test disk
failover without affecting your SQL server.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pat Hall" <anonymous@.discussions.microsoft.com> wrote in message
news:B70341B7-80F6-4C74-BFC6-78D7CDF655A1@.microsoft.com...
> Thanks for the info. NOTE: The questions asked relate to getting SQL on
the new node not applying SP3. I figure applying SP3 will be the easist
part. And yes I know the apps need to be down and can get a window to do
that.
>
> The Computer Name screen says it wants the name of the "virtual server"
there is a later screen (Cluster Management) where we provide the name of
the new server. So which of the two virtual server names do we use: the
one for the MSCS cluster or the one for the SQL cluster? We used the SQL
Clsuter name.
> The login requested has to have administrator priviledges on both servers
which tells me that SA is not the id to use.
>

> What about the screen that showed up that wasn't in the procedure? It
asked for the passwords for the ids used for the two services SQL uses.
> Do the apps using these databases need to be down when we install SQL on
the new node? They can be if needed.
> On your comment about the drivers: Our SAN is EMC Symmetrix. The current
working node has 2 HBAs & PowerPath (lets computer know the HBAs point to
the same disk) the new node has one HBA and no PowerPath plus the nodes have
different drivers & firmware for the HBAs. Based on your comment, I get the
feeling that failover won't work. Is this correct? By the way the new node
is in the cluster. When we use Disk Management it has an entry for the SAN
disk; however, we don't know if it will see the SAN disk correctly yet since
we can't failover without SQL. Or can we?
> Pat Hall
> Sr. Database Administrator
> pat.hall@.gilbarco.com
> -- Geoff N. Hiten wrote: --
> Ok, You guys are really trying. Major kudos for the detailed post.
> Ok, here are my notes.
> Computer name = new host name, not virtual servername. The cluster
install
> already asked for the instance name on a prior screen.
> Login info: I prefer to use the SA login, avoiding any NT permissions
> issues. assuming your cluster is in mixed mode.
> SQL Service packs. Run the SP from the node that owns the SQL group.
It
> WILL take the server offline while the SP is applied. Get over it.
You MUST
> apply SP3 or SP3 a before upgrading to Windows 2003.
> MSDTC:. Win2000 best practices - put it in the cluster group.
Win2003 Best
> Practices = make a new group. Practical experiance = I have not
seen, nor
> heard of a situation where it made a difference.
> The real difficulty is going to be making sure that 2003 can access
the[vbcol=seagreen]
> shared storage. Drivers are critical.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pat Hall" <anonymous@.discussions.microsoft.com> wrote in message
> news:0D42B568-1D29-4577-9FA9-327FBF09CC3D@.microsoft.com...
to the
> cluster). We are using the procedure How to add nodes to an existing
> virtual server (Setup)(from BOL). When asked for computer name we
entered
> the SQL cluster name for the virtual server. When asked for the
logon we
> used the id used to log both nodes on the domain (Domain Admin &
member of
> Adminisytrators group on both servers). Got a screen asking for the
> passwords for the ids for MSSQLSERVER & SQLSERVER AGENT. (screen was
not
> expected).
> cluster. Active node has SQL 2000 SP2 with Security Patch 0655. The
new
> node was successfully added to the cluster. We are trying to push
SQL 2000
> to the new node. The CD we are using is SQL2000 Enterprise edition
with no
> service packs. Once we get SQL on the new node and failover to it,
we are
> going to apply SQL 2000 SP3. After that we will start the process of
> evicting the current node and getting a new Windows 2003 node to join
the
> cluster. Once SQL 2000 is on that node and we failover to that node,
the
> node we just added will be upgraded to Windows 2003. We have Q811272
on
> registry hack when the operating systems of the cluster servers are
> different and Q 294209 & Q 301600 on moving the MSDTC resource from
the
> cluster group to the SQL group.
> contains all the steps and we are entering the correct information?
Plus[vbcol=seagreen]
> what's with the screen asking for the MSSQLSERVER and SQLSERVERAGENT
> services password.
be down
> during the install. Can't find that anywhere except for applying
service
> packs.
>
>
|||But how do I get SQL Server 2000 on the new node so I can install SP3. That is my problem right now. When I follow the instructions in BOL I get kicked out after I enter the passwords for the two SQL services and click next. On the new node there is no
C:\Program Files\Miscrosoft SQL Server directory.
Do I evict the new node, install SQL 2000 up to the point of the current node, rejoin the cluster then do the procedure I 'm trying? If so, what about the system databases, backup & Data etc directories that will be on the new node which will know nothin
g of the SAN disk.
Also during this install, will my databases be affected? In other words do I need down time?
All I'm trying to do now is get the new node set up so I can perform a failover. Both nodes are Win2K at this time.
On the idea of creating a small LUN, I wish. Our SAN doesn't have any available space. All I can do is get the new node in the cluster and try a failover. It works or it doesn't. And hopefully doesn't hurt the data, if it doesn't. Talk about making s
ure we have a good backup 1st.
Pat Hall
-- Geoff N. Hiten wrote: --
You can apply a service pack to a new node without taking the Virtual SQL
server offline. This is possible if the SP has already been applied to the
virtual server. See the README file for details.
When the install is asking for a virtual server name, it means the SQL
virtual server.
Install needs the passwords to create the services correctly on the new
node.
I use EMC Clariion gear and am familiar with the PowerPath software. The
system should failover correctly as long as the new node can see the virtual
disks. Ideally, the nodes should be identical, but during a transition,
this isn't always possible. I would create a small temporary LUN on the SAN
and add it to whatever group you are using on the SAN to present LUNS to
this host collection. You can then format it and make it a clustered
physical disk resource. Put it into a new, temporary virtual server (name,
disk, and IP only) that you manually create. You can then test disk
failover without affecting your SQL server.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pat Hall" <anonymous@.discussions.microsoft.com> wrote in message
news:B70341B7-80F6-4C74-BFC6-78D7CDF655A1@.microsoft.com...
> Thanks for the info. NOTE: The questions asked relate to getting SQL on
the new node not applying SP3. I figure applying SP3 will be the easist
part. And yes I know the apps need to be down and can get a window to do
that.[vbcol=seagreen]
there is a later screen (Cluster Management) where we provide the name of
the new server. So which of the two virtual server names do we use: the
one for the MSCS cluster or the one for the SQL cluster? We used the SQL
Clsuter name.[vbcol=seagreen]
which tells me that SA is not the id to use.[vbcol=seagreen]
asked for the passwords for the ids used for the two services SQL uses.[vbcol=seagreen]
the new node? They can be if needed.[vbcol=seagreen]
working node has 2 HBAs & PowerPath (lets computer know the HBAs point to
the same disk) the new node has one HBA and no PowerPath plus the nodes have
different drivers & firmware for the HBAs. Based on your comment, I get the
feeling that failover won't work. Is this correct? By the way the new node
is in the cluster. When we use Disk Management it has an entry for the SAN
disk; however, we don't know if it will see the SAN disk correctly yet since
we can't failover without SQL. Or can we?[vbcol=seagreen]
> Sr. Database Administrator
> pat.hall@.gilbarco.com
install[vbcol=seagreen]
> already asked for the instance name on a prior screen.
> issues. assuming your cluster is in mixed mode.
It
> WILL take the server offline while the SP is applied. Get over it.
You MUST[vbcol=seagreen]
> apply SP3 or SP3 a before upgrading to Windows 2003.
Win2003 Best
> Practices = make a new group. Practical experiance = I have not
seen, nor[vbcol=seagreen]
> heard of a situation where it made a difference.
the[vbcol=seagreen]
> shared storage. Drivers are critical.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> www.sqlpass.org
> news:0D42B568-1D29-4577-9FA9-327FBF09CC3D@.microsoft.com...
to the
> cluster). We are using the procedure How to add nodes to an existing
> virtual server (Setup)(from BOL). When asked for computer name we
entered
> the SQL cluster name for the virtual server. When asked for the
logon we
> used the id used to log both nodes on the domain (Domain Admin &
member of
> Adminisytrators group on both servers). Got a screen asking for the
> passwords for the ids for MSSQLSERVER & SQLSERVER AGENT. (screen was
not
> expected).
> cluster. Active node has SQL 2000 SP2 with Security Patch 0655. The
new
> node was successfully added to the cluster. We are trying to push
SQL 2000
> to the new node. The CD we are using is SQL2000 Enterprise edition
with no
> service packs. Once we get SQL on the new node and failover to it,
we are
> going to apply SQL 2000 SP3. After that we will start the process of
> evicting the current node and getting a new Windows 2003 node to join
the
> cluster. Once SQL 2000 is on that node and we failover to that node,
the
> node we just added will be upgraded to Windows 2003. We have Q811272
on
> registry hack when the operating systems of the cluster servers are
> different and Q 294209 & Q 301600 on moving the MSDTC resource from
the
> cluster group to the SQL group.
> contains all the steps and we are entering the correct information?
Plus[vbcol=seagreen]
> what's with the screen asking for the MSSQLSERVER and SQLSERVERAGENT
> services password.
be down
> during the install. Can't find that anywhere except for applying
service[vbcol=seagreen]
> packs.
|||You missed an earlier critical step. You MUST run the SQL install and
remove the old node before you can add the new one. This step is in
addition to the eviction of the old node from the cluster. Until SQL has
current node information, the install will fail.
Also, make sure the service accounts and the install account are
domain-level accounts that are in the local administrators group on the new
node.
When you add a node to SQL, the virtual server remains online.
No spare or emergency space on the SAN is asking for trouble, but then
again, you already have trouble.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pat Hall" <anonymous@.discussions.microsoft.com> wrote in message
news:2B259942-AFA3-4262-84E4-71717DBE66DB@.microsoft.com...
> But how do I get SQL Server 2000 on the new node so I can install SP3.
That is my problem right now. When I follow the instructions in BOL I get
kicked out after I enter the passwords for the two SQL services and click
next. On the new node there is no C:\Program Files\Miscrosoft SQL Server
directory.
> Do I evict the new node, install SQL 2000 up to the point of the current
node, rejoin the cluster then do the procedure I 'm trying? If so, what
about the system databases, backup & Data etc directories that will be on
the new node which will know nothing of the SAN disk.
> Also during this install, will my databases be affected? In other words
do I need down time?
> All I'm trying to do now is get the new node set up so I can perform a
failover. Both nodes are Win2K at this time.
> On the idea of creating a small LUN, I wish. Our SAN doesn't have any
available space. All I can do is get the new node in the cluster and try a
failover. It works or it doesn't. And hopefully doesn't hurt the data, if
it doesn't. Talk about making sure we have a good backup 1st.
> Pat Hall
> -- Geoff N. Hiten wrote: --
> You can apply a service pack to a new node without taking the Virtual
SQL
> server offline. This is possible if the SP has already been applied
to the
> virtual server. See the README file for details.
> When the install is asking for a virtual server name, it means the
SQL
> virtual server.
> Install needs the passwords to create the services correctly on the
new
> node.
> I use EMC Clariion gear and am familiar with the PowerPath software.
The
> system should failover correctly as long as the new node can see the
virtual
> disks. Ideally, the nodes should be identical, but during a
transition,
> this isn't always possible. I would create a small temporary LUN on
the SAN
> and add it to whatever group you are using on the SAN to present LUNS
to
> this host collection. You can then format it and make it a clustered
> physical disk resource. Put it into a new, temporary virtual server
(name,[vbcol=seagreen]
> disk, and IP only) that you manually create. You can then test disk
> failover without affecting your SQL server.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pat Hall" <anonymous@.discussions.microsoft.com> wrote in message
> news:B70341B7-80F6-4C74-BFC6-78D7CDF655A1@.microsoft.com...
SQL on
> the new node not applying SP3. I figure applying SP3 will be the
easist
> part. And yes I know the apps need to be down and can get a window
to do[vbcol=seagreen]
> that.
server"
> there is a later screen (Cluster Management) where we provide the
name of
> the new server. So which of the two virtual server names do we use:
the
> one for the MSCS cluster or the one for the SQL cluster? We used the
SQL[vbcol=seagreen]
> Clsuter name.
servers[vbcol=seagreen]
> which tells me that SA is not the id to use.
It
> asked for the passwords for the ids used for the two services SQL
uses.[vbcol=seagreen]
SQL on[vbcol=seagreen]
> the new node? They can be if needed.
current
> working node has 2 HBAs & PowerPath (lets computer know the HBAs
point to
> the same disk) the new node has one HBA and no PowerPath plus the
nodes have
> different drivers & firmware for the HBAs. Based on your comment, I
get the
> feeling that failover won't work. Is this correct? By the way the
new node
> is in the cluster. When we use Disk Management it has an entry for
the SAN
> disk; however, we don't know if it will see the SAN disk correctly
yet since[vbcol=seagreen]
> we can't failover without SQL. Or can we?
post.[vbcol=seagreen]
cluster[vbcol=seagreen]
> install
permissions[vbcol=seagreen]
SQL group.[vbcol=seagreen]
> It
it.[vbcol=seagreen]
> You MUST
> Win2003 Best
not[vbcol=seagreen]
> seen, nor
access[vbcol=seagreen]
> the
message[vbcol=seagreen]
> to the
existing[vbcol=seagreen]
name we[vbcol=seagreen]
> entered
the[vbcol=seagreen]
> logon we
&[vbcol=seagreen]
> member of
for the[vbcol=seagreen]
(screen was[vbcol=seagreen]
> not
node[vbcol=seagreen]
0655. The[vbcol=seagreen]
> new
push[vbcol=seagreen]
> SQL 2000
edition[vbcol=seagreen]
> with no
to it,[vbcol=seagreen]
> we are
process of[vbcol=seagreen]
to join[vbcol=seagreen]
> the
that node,[vbcol=seagreen]
> the
Q811272[vbcol=seagreen]
> on
servers are[vbcol=seagreen]
from[vbcol=seagreen]
> the
it[vbcol=seagreen]
information?[vbcol=seagreen]
> Plus
SQLSERVERAGENT[vbcol=seagreen]
> be down
applying[vbcol=seagreen]
> service
|||Uh Oh.
When I was working with MS Support they said all I had to do was evict the node from the cluster. They checked with SQL support before responding to me. All we did was evict the node from the cluster. When I go thru the procedure and get to the screen
where I select the node to join the SQL cluster, I do not see the old node just the new node.
Maybe I need to go back to MS Support for help in getting this straightened out. I didn't realize it would be this difficult.
All ids involved meet the criteria you stated.
Thanks for the info on SQL cluster still available whilie I add the new node to the SQL cluster.
Pat Hall
Sr. DBA
Gilbarco Veeder-Root
|||Here are the necessary instruction cut directly from BOL:
--snip--
How to remove a node from an existing failover cluster (Setup)
1.. On the Welcome screen of the Microsoft SQL Server Installation Wizard,
click Next.
2.. On the Computer Name screen, click Virtual Server and specify the name
of the server from which to remove the node. Click Next.
3.. You may see an error message saying that one (or more) of the nodes of
the Microsoft Windows NT 4.0 or Microsoft Windows 2000 cluster are
unavailable. This may be because the node(s) you are attempting to remove is
damaged. The node(s) still can be removed. Click OK.
4.. On the Installation Selection screen, click Advanced Options. Click
Next.
5.. On the Advanced Options screen, click Maintain a virtual server for
failover clustering. Click Next.
6.. On the Failover Clustering screen, click Next.
You do not need to modify any IP address(es).
7.. On the Cluster Management screen, select the node and click Remove.
Click Next.
8.. On the Remote Information screen, enter login credentials for the
remote cluster node that has administrator privileges on the remote node(s)
of the cluster. Click Next.
9.. On the Setup Complete screen, click Finish.
If you are instructed to restart the computer, do so now. It is important
to read the message from SQL Server Setup when you are done with
installation. Failure to restart any of the specified nodes may cause
failures when you run the Setup program in the future on any node in the
failover cluster.
--snip--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pat Hall" <anonymous@.discussions.microsoft.com> wrote in message
news:2893F359-FD01-49DB-8CB1-475BA25C4C5B@.microsoft.com...
> Uh Oh.
> When I was working with MS Support they said all I had to do was evict the
node from the cluster. They checked with SQL support before responding to
me. All we did was evict the node from the cluster. When I go thru the
procedure and get to the screen where I select the node to join the SQL
cluster, I do not see the old node just the new node.
> Maybe I need to go back to MS Support for help in getting this
straightened out. I didn't realize it would be this difficult.
> All ids involved meet the criteria you stated.
> Thanks for the info on SQL cluster still available whilie I add the new
node to the SQL cluster.
> Pat Hall
> Sr. DBA
> Gilbarco Veeder-Root
|||Thanks for the info. That's the procedure that MS cluster support said I didn't have to do. When we went thru the step to add the new node to the SQL cluster I did not see the old node so I think I am OK.
MS SQL support said the problem had to do with KB 273769. We licensed per processor and the CD is the original release with no SPs. They gave me a registry hack to switch to per server until I get the new node in the SQL cluster then I can switch back.
We're doing that today. I'll let you know what happens.
|||The registry hack to set the licensing to Per Seat and a large value for number of seats did the trick. Now I just need to schedule a window to apply SP2 & the security patch. Getting the window is easy, making sure all the app people are available is t
he hard part.
Pat Hall
Sr. DBA
Gilbarco Veeder-Root

Can't get new LUN/Logical Drive visible from within SQL Server on cluster.

We have had a working SQL Server 2000 SP3 (default instance) on two node MS
Windows 2000 Advanced Server with MS Cluster servcie working for over a year
now.
The shared Q: and E: drives are actually two seperate LUNS from a SAN
connected via Host Bus Adapters..
Recently, needed another logical drive. Added another LUN from the SAN.
Configured it as basic disk, drive letter F: It show up in Disk Manager
exactly like the pre-existing E: drive in terms of attribute values.
It is a working a normal drive on the primary node.
Using the cluster administrator, it was added as a physical disk resource
and added to the iManage SQL Cluster Group, the same as the E: drive.
It shows up as online and owned by the primary node where the SQL Server is
active.
However, it does not show up with the Enterprise Manage for the SQL Server.
Only E: is showing. Have even rebooted the nodes for the cluster.
The logical drive F: is available for all other uses, but it cannot be seen
by the SQL Server.
Scott Lord
Willkie Farr & Gallagher LLP
New York, New York
slord@.willkie.com
you have to add new drive as a SQL Server Dependency in cluster administrator. once you added into sqlserver dependency then enterprise mangager see the drive.
Regards
Ram
Systems SQL DBA|||I for get tell one more step . you have to add resource in Cluster administrator.
Regards
Ram

Quote:

Originally posted by yvr4
you have to add new drive as a SQL Server Dependency in cluster administrator. once you added into sqlserver dependency then enterprise mangager see the drive.
Regards
Ram
Systems SQL DBA

|||Have you made it a dependency of the SQL Server group?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Scott Lord" <nomail@.nomail.com> wrote in message
news:ehHkGQKCFHA.2404@.TK2MSFTNGP15.phx.gbl...
We have had a working SQL Server 2000 SP3 (default instance) on two node MS
Windows 2000 Advanced Server with MS Cluster servcie working for over a year
now.
The shared Q: and E: drives are actually two seperate LUNS from a SAN
connected via Host Bus Adapters..
Recently, needed another logical drive. Added another LUN from the SAN.
Configured it as basic disk, drive letter F: It show up in Disk Manager
exactly like the pre-existing E: drive in terms of attribute values.
It is a working a normal drive on the primary node.
Using the cluster administrator, it was added as a physical disk resource
and added to the iManage SQL Cluster Group, the same as the E: drive.
It shows up as online and owned by the primary node where the SQL Server is
active.
However, it does not show up with the Enterprise Manage for the SQL Server.
Only E: is showing. Have even rebooted the nodes for the cluster.
The logical drive F: is available for all other uses, but it cannot be seen
by the SQL Server.
Scott Lord
Willkie Farr & Gallagher LLP
New York, New York
slord@.willkie.com
|||Thanks to Tom Moreau and yvr4 for their answers. I am pretty sure they both
identified the problem, I haven't been able to successfully test their
solution.
I had not added it as a dependency for the SQL Server. I only had it added
it to the SQL Cluster Group. I just tried adding it as a dependency to the
SQL Server.
FYI: The disk resource F: is online to the primary node and the SQL Server
is and online to the primary node.
In the cluster administrator, simply pulling up the properties to the SQL
Server and going to the Dependencies tab showed the F: drive on the left as
an available resource to be added as a dependency. I highlighted the F:
drive and tried to add it. I got a slightly ambiguous error message which I
will also type the text from the error message box.
Message box title: Cluster Administrator
Yellow triangle with exclamation point icon.
An error occurred attempting to add 'Disk F:' as a dependency of 'SQL
Server':
The operation could not be completed because the cluster resource is online.
Error ID: 5019 (0000139b).
This is a production environment: I am concerned about two things. Which
resource, the F: drive or the SQL Server is the error message meaning when
it say 'because the cluster resource is online' I know that I would like
for it to mean the disk drive, but I am modifying the SQL Server dependency
tree, so it is possible it means the SQL Server. I can't take that offline
except during a maintenance window. Also, if I simply take the disk drive
F: resource offline in the cluster administrator window in order to add it
to the SQL Server dependency tree, will it cause a fail-over of the SQL
Server since the newly defined dependency, F: disk drive resource, is not
online. That is what the dependency tree is for, isn't it.
I hope the answer is simply, take the disk drive F: resource offline in
cluster administrator, add it as a dependency to the SQL Server, and it will
either come online itself or I can manually bring it online, without the SQL
Server failing over.
Alternatively, I can accept needing to take the SQL Server offline in the
cluster administrator, having the disk drive F: resource online, adding it
as a dependency to the SQL Server and bringing the SQL Server online.
Sorry about these additional questions, but I thought the error message was
a little ambiguous, and I am concerned about adding an offline resource as a
dependency if it will cause a fail-over in our production environment. We
do not have a test cluster to try this on.
Scott Lord
Willkie Farr & Gallagher LLP
New York, New York
slord@.willkie.com
"yvr4" <yvr4.1jt3a0@.mail.mcse.ms> wrote in message
news:yvr4.1jt3a0@.mail.mcse.ms...
> you have to add new drive as a SQL Server Dependency in cluster
> administrator. once you added into sqlserver dependency then enterprise
> mangager see the drive.
> Regards
> Ram
> Systems SQL DBA
>
> --
> yvr4
> Posted via http://www.mcse.ms
> View this thread: http://www.mcse.ms/message1393040.html
>
|||That error message is correct. You must take the SQL Server resource
offline to change its dependencies.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Scott Lord" <nomail@.nomail.com> wrote in message
news:e97ziSUCFHA.2384@.TK2MSFTNGP14.phx.gbl...
> Thanks to Tom Moreau and yvr4 for their answers. I am pretty sure they
both
> identified the problem, I haven't been able to successfully test their
> solution.
> I had not added it as a dependency for the SQL Server. I only had it
added
> it to the SQL Cluster Group. I just tried adding it as a dependency to
the
> SQL Server.
> FYI: The disk resource F: is online to the primary node and the SQL
Server
> is and online to the primary node.
> In the cluster administrator, simply pulling up the properties to the SQL
> Server and going to the Dependencies tab showed the F: drive on the left
as
> an available resource to be added as a dependency. I highlighted the F:
> drive and tried to add it. I got a slightly ambiguous error message which
I
> will also type the text from the error message box.
> --
> Message box title: Cluster Administrator
> Yellow triangle with exclamation point icon.
> An error occurred attempting to add 'Disk F:' as a dependency of 'SQL
> Server':
> The operation could not be completed because the cluster resource is
online.
> Error ID: 5019 (0000139b).
> --
> This is a production environment: I am concerned about two things. Which
> resource, the F: drive or the SQL Server is the error message meaning when
> it say 'because the cluster resource is online' I know that I would like
> for it to mean the disk drive, but I am modifying the SQL Server
dependency
> tree, so it is possible it means the SQL Server. I can't take that
offline
> except during a maintenance window. Also, if I simply take the disk drive
> F: resource offline in the cluster administrator window in order to add it
> to the SQL Server dependency tree, will it cause a fail-over of the SQL
> Server since the newly defined dependency, F: disk drive resource, is not
> online. That is what the dependency tree is for, isn't it.
> I hope the answer is simply, take the disk drive F: resource offline in
> cluster administrator, add it as a dependency to the SQL Server, and it
will
> either come online itself or I can manually bring it online, without the
SQL
> Server failing over.
> Alternatively, I can accept needing to take the SQL Server offline in the
> cluster administrator, having the disk drive F: resource online, adding it
> as a dependency to the SQL Server and bringing the SQL Server online.
> Sorry about these additional questions, but I thought the error message
was
> a little ambiguous, and I am concerned about adding an offline resource as
a
> dependency if it will cause a fail-over in our production environment. We
> do not have a test cluster to try this on.
> Scott Lord
> Willkie Farr & Gallagher LLP
> New York, New York
> slord@.willkie.com
> "yvr4" <yvr4.1jt3a0@.mail.mcse.ms> wrote in message
> news:yvr4.1jt3a0@.mail.mcse.ms...
>
|||Thank you Geoff.
I will schedule the change to the dependency tree for SQL Server to occur
during a maintenance window.
Scott
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:%23mHvubUCFHA.4004@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> That error message is correct. You must take the SQL Server resource
> offline to change its dependencies.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Scott Lord" <nomail@.nomail.com> wrote in message
> news:e97ziSUCFHA.2384@.TK2MSFTNGP14.phx.gbl...
> both
> added
> the
> Server
SQL[vbcol=seagreen]
> as
which[vbcol=seagreen]
> I
> online.
Which[vbcol=seagreen]
when[vbcol=seagreen]
like[vbcol=seagreen]
> dependency
> offline
drive[vbcol=seagreen]
it[vbcol=seagreen]
not[vbcol=seagreen]
> will
> SQL
the[vbcol=seagreen]
it[vbcol=seagreen]
> was
as[vbcol=seagreen]
> a
We[vbcol=seagreen]
enterprise
>