Good day,
There is a 2-node microsoft sql 2000 cluster in active/active mode. .
Default instance is on node A, another named instance is on node B.
Client uses BDE while connecting. When the node A fails over to the
node B, it's not possible to connect to the default instance while
using trusted logins. When sql login is used, users can connect..
I can connect via Query Analyzer, but via tcp/ip only(when named pipes
aren't used) at this very moment.
As far as I understand, BDE uses named pipes with trusted logins.
Are there any workarounds?
Thank in advance,
Andrew.
Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on
Windows NT 5.2 (Build 3790: Service Pack 1)
Andrew,
What is the service pack level for your SQL Server 2000 clustered instance?
As of SQL Server 2000 SP3 -- Named Pipes Support Cannot Be Removed on a Virtual Server That Is Running SQL Server 2000 SP3
Here is the link that explains this
http://support.microsoft.com/default.aspx?kbid=831127
Note: If you are already on SP3a --> On a virtual server that is running SQL 2000 SP3a, an administrator can disable Named Pipes support through SQL Server Enterprise
Manager in SQL Server 2000 SP2 or earlier.
Recommendation:
Although Named Pipes support is not required for a virtual server, Microsoft recommends that both network libraries must be present on the system because of the
following reasons:
Having both network libraries available permits an administrator or an alternative interprocess communication (IPC) mechanism to repair the system.
Clients can continue to work with the virtual server, even if only one server-side network library is available.
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Hi Uttam,
sp3a was installed..
named pipes aren't disabled. I can see them enabled while viewing the
sql servers logs.
Moreover, i can't connect to the moved instance via named pipes using
Query Analyzer as well. Not only our application can't connect.
Andrew.
Uttam Parui[MS] =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
> Andrew,
> What is the service pack level for your SQL Server 2000 clustered instanc=
e?
> As of SQL Server 2000 SP3 -- Named Pipes Support Cannot Be Removed on a V=
irtual Server That Is Running SQL Server 2000 SP3
> Here is the link that explains this
> http://support.microsoft.com/default.aspx?kbid=3D831127
> Note: If you are already on SP3a --> On a virtual server that is runnin=
g SQL 2000 SP3a, an administrator can disable Named Pipes support through S=
QL Server Enterprise
> Manager in SQL Server 2000 SP2 or earlier.
> Recommendation:
> Although Named Pipes support is not required for a virtual server, Micros=
oft recommends that both network libraries must be present on the system be=
cause of the
> following reasons:
> Having both network libraries available permits an administrator or an al=
ternative interprocess communication (IPC) mechanism to repair the system.
> Clients can continue to work with the virtual server, even if only one se=
rver-side network library is available.
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no right=
s=2E
> Are you secure? For information about the Strategic Technology Protectio=
n Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their =
Microsoft software to better protect against viruses and security vulnerabi=
lities. The easiest way
> to do this is to visit the following websites: http://www.microsoft.com/p=
rotect
> http://www.microsoft.com/security/guidance/default.mspx
Showing posts with label cluster. Show all posts
Showing posts with label cluster. Show all posts
Wednesday, March 28, 2012
Named Pipes and Clusters
Can the Named Pipes protocol be removed from a SQL Cluster
(SQL2000/Win2003)? And it still function properly, of course...
-Arnie Rowland
Hi Arnie,
No it cannot, see KB article:
831127 Named Pipes Support Cannot Be Removed on a Virtual Server That Is
http://support.microsoft.com/?id=831127
Dave Whitney
SQL Support
This posting is provided "AS IS" with no warranties, and confers no rights.
(SQL2000/Win2003)? And it still function properly, of course...
-Arnie Rowland
Hi Arnie,
No it cannot, see KB article:
831127 Named Pipes Support Cannot Be Removed on a Virtual Server That Is
http://support.microsoft.com/?id=831127
Dave Whitney
SQL Support
This posting is provided "AS IS" with no warranties, and confers no rights.
named pipes
The cluster consists of two nodes and of two instances. One default sql
instance and one another named instanse.
To connect to the named instance all the clients have alias(done by
cliconfg.exe), but when the instance fails over to another node no one
can't connect to this named instance anymore. If i edit the alias to
use the default instance pipe name, this helps!
It seems named pipes don't fail over to another node.. Any suggestions?
Thanks in advance.
Andrew
Have you run cliconfg.exe on both nodes, not just the "primary"?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"kreit" <kreit@.mail.ru> wrote in message
news:1118052606.954693.185910@.g47g2000cwa.googlegr oups.com...
The cluster consists of two nodes and of two instances. One default sql
instance and one another named instanse.
To connect to the named instance all the clients have alias(done by
cliconfg.exe), but when the instance fails over to another node no one
can't connect to this named instance anymore. If i edit the alias to
use the default instance pipe name, this helps!
It seems named pipes don't fail over to another node.. Any suggestions?
Thanks in advance.
Andrew
|||I run cliconfg.exe on the clients side. The problem is that our
end-user applications aren't ms sql instances aware of and i need to
provide an alias.
i can change the alias on the user machines via some kind of gpo etc..
Andrew
Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
> Have you run cliconfg.exe on both nodes, not just the "primary"?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118052606.954693.185910@.g47g2000cwa.googlegr oups.com...
> The cluster consists of two nodes and of two instances. One default sql
> instance and one another named instanse.
>
> To connect to the named instance all the clients have alias(done by
> cliconfg.exe), but when the instance fails over to another node no one
> can't connect to this named instance anymore. If i edit the alias to
> use the default instance pipe name, this helps!
>
> It seems named pipes don't fail over to another node.. Any suggestions?
>=20
>=20
>=20
> Thanks in advance.
> Andrew
|||This sounds strange. Have you tried removing the aliases from the client
machines?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"kreit" <kreit@.mail.ru> wrote in message
news:1118228154.834811.10600@.o13g2000cwo.googlegro ups.com...
I run cliconfg.exe on the clients side. The problem is that our
end-user applications aren't ms sql instances aware of and i need to
provide an alias.
i can change the alias on the user machines via some kind of gpo etc..
Andrew
Tom Moreau писал(а):
> Have you run cliconfg.exe on both nodes, not just the "primary"?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118052606.954693.185910@.g47g2000cwa.googlegr oups.com...
> The cluster consists of two nodes and of two instances. One default sql
> instance and one another named instanse.
>
> To connect to the named instance all the clients have alias(done by
> cliconfg.exe), but when the instance fails over to another node no one
> can't connect to this named instance anymore. If i edit the alias to
> use the default instance pipe name, this helps!
>
> It seems named pipes don't fail over to another node.. Any suggestions?
>
> Thanks in advance.
> Andrew
|||If i remove - i just can't connect..
Andrew
Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):[vbcol=seagreen]
> This sounds strange. Have you tried removing the aliases from the client
> machines?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118228154.834811.10600@.o13g2000cwo.googlegro ups.com...
> I run cliconfg.exe on the clients side. The problem is that our
> end-user applications aren't ms sql instances aware of and i need to
> provide an alias.
> i can change the alias on the user machines via some kind of gpo etc..
> Andrew
> Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
|||This sounds like either a DNS issue or that SQL Server is not listening on
TCP/IP. Check out the Server Network Utility on your cluster - or the SQL
Server errorlog to see what protocols SQL Server will "hear". Also, ensure
that your clients are using TCP/IP. Check out their Client Network Utility
to confirm.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"kreit" <kreit@.mail.ru> wrote in message
news:1118242276.507481.291570@.f14g2000cwb.googlegr oups.com...
If i remove - i just can't connect..
Andrew
Tom Moreau писал(а):[vbcol=seagreen]
> This sounds strange. Have you tried removing the aliases from the client
> machines?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118228154.834811.10600@.o13g2000cwo.googlegro ups.com...
> I run cliconfg.exe on the clients side. The problem is that our
> end-user applications aren't ms sql instances aware of and i need to
> provide an alias.
> i can change the alias on the user machines via some kind of gpo etc..
> Andrew
> Tom Moreau писал(а):
|||with tcp/ip everything is ok. I've a problem with named pipes. Our
application isn't tcp/ip aware, just named pipes - thats all.
Andrew
Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
> This sounds like either a DNS issue or that SQL Server is not listening on
> TCP/IP. Check out the Server Network Utility on your cluster - or the SQL
> Server errorlog to see what protocols SQL Server will "hear". Also, ensu=
re
> that your clients are using TCP/IP. Check out their Client Network Utili=
ty[vbcol=seagreen]
> to confirm.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118242276.507481.291570@.f14g2000cwb.googlegr oups.com...
> If i remove - i just can't connect..
> Andrew
> Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
nt[vbcol=seagreen]
ql[vbcol=seagreen]
s?[vbcol=seagreen]
|||ok, for example
Active-Active cluster. One instance server1, another one -
server2\instance
Since my application isnt't cluster aware i create an alias to connect
via named pipes.
- server alias: server2
- server name: server2\instance
- pipe name: \\server2\pipe\MSSQL$INSTANCE\sql\query
when server2 fails over to server1 i can't use my application. At this
moment I can ping server2 successfully.
If i change on the client the alias server2:
- server alias: server2 (it's the same)
- server name: server1
- pipe name: \\server1\pipe\\sql\query
I can connect and can't use my application
|||kreit wrote:
> The cluster consists of two nodes and of two instances. One default sql
> instance and one another named instanse.
>
> To connect to the named instance all the clients have alias(done by
> cliconfg.exe), but when the instance fails over to another node no one
> can't connect to this named instance anymore. If i edit the alias to
> use the default instance pipe name, this helps!
>
> It seems named pipes don't fail over to another node.. Any suggestions?
>
Maybe some of the registry is not replicated. In the cluster registry
there should be about 7 registry entries for each sql server resource
which are used to replicate some of the sql registry keys. Check if they
exist. Also check the contents of software\microsoft\microsoft sql
server\instance\mssqlserver\supersocketnetlib\np\p ipename on the problem
node when sql is running there.
The service account of the default instance should be able to read the
registry key's of the named instance and vice versa. Sqlservers log
mentions its listening on named pipes?
What I think is kind of strange is that you are able to use the client
network tools aliases but not tcp\ip. Your program should not even know
about named pipes or tcp/ip. It just needs to talk to the sqldriver.
Maybe its time to instal ethereal (http://www.ethereal.com/) on one of
the clients.
Hans
|||kreit wrote:
> ok, for example
> Active-Active cluster. One instance server1, another one -
> server2\instance
> Since my application isnt't cluster aware i create an alias to connect
> via named pipes.
> - server alias: server2
> - server name: server2\instance
> - pipe name: \\server2\pipe\MSSQL$INSTANCE\sql\query
>
> when server2 fails over to server1 i can't use my application. At this
> moment I can ping server2 successfully.
> If i change on the client the alias server2:
> - server alias: server2 (it's the same)
> - server name: server1
> - pipe name: \\server1\pipe\\sql\query
> I can connect and can't use my application
>
Just to make very sure, you do know the difference between the virtual
server name and the node name?
'when server2 fails over to server1 i can't use my application'
should be:
'when virtual server2 fails over to node1 i can't use my application'
Clients should connect to the virtual server name and not to the not to
the name of the physical server.
Hans
sql
instance and one another named instanse.
To connect to the named instance all the clients have alias(done by
cliconfg.exe), but when the instance fails over to another node no one
can't connect to this named instance anymore. If i edit the alias to
use the default instance pipe name, this helps!
It seems named pipes don't fail over to another node.. Any suggestions?
Thanks in advance.
Andrew
Have you run cliconfg.exe on both nodes, not just the "primary"?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"kreit" <kreit@.mail.ru> wrote in message
news:1118052606.954693.185910@.g47g2000cwa.googlegr oups.com...
The cluster consists of two nodes and of two instances. One default sql
instance and one another named instanse.
To connect to the named instance all the clients have alias(done by
cliconfg.exe), but when the instance fails over to another node no one
can't connect to this named instance anymore. If i edit the alias to
use the default instance pipe name, this helps!
It seems named pipes don't fail over to another node.. Any suggestions?
Thanks in advance.
Andrew
|||I run cliconfg.exe on the clients side. The problem is that our
end-user applications aren't ms sql instances aware of and i need to
provide an alias.
i can change the alias on the user machines via some kind of gpo etc..
Andrew
Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
> Have you run cliconfg.exe on both nodes, not just the "primary"?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118052606.954693.185910@.g47g2000cwa.googlegr oups.com...
> The cluster consists of two nodes and of two instances. One default sql
> instance and one another named instanse.
>
> To connect to the named instance all the clients have alias(done by
> cliconfg.exe), but when the instance fails over to another node no one
> can't connect to this named instance anymore. If i edit the alias to
> use the default instance pipe name, this helps!
>
> It seems named pipes don't fail over to another node.. Any suggestions?
>=20
>=20
>=20
> Thanks in advance.
> Andrew
|||This sounds strange. Have you tried removing the aliases from the client
machines?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"kreit" <kreit@.mail.ru> wrote in message
news:1118228154.834811.10600@.o13g2000cwo.googlegro ups.com...
I run cliconfg.exe on the clients side. The problem is that our
end-user applications aren't ms sql instances aware of and i need to
provide an alias.
i can change the alias on the user machines via some kind of gpo etc..
Andrew
Tom Moreau писал(а):
> Have you run cliconfg.exe on both nodes, not just the "primary"?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118052606.954693.185910@.g47g2000cwa.googlegr oups.com...
> The cluster consists of two nodes and of two instances. One default sql
> instance and one another named instanse.
>
> To connect to the named instance all the clients have alias(done by
> cliconfg.exe), but when the instance fails over to another node no one
> can't connect to this named instance anymore. If i edit the alias to
> use the default instance pipe name, this helps!
>
> It seems named pipes don't fail over to another node.. Any suggestions?
>
> Thanks in advance.
> Andrew
|||If i remove - i just can't connect..
Andrew
Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):[vbcol=seagreen]
> This sounds strange. Have you tried removing the aliases from the client
> machines?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118228154.834811.10600@.o13g2000cwo.googlegro ups.com...
> I run cliconfg.exe on the clients side. The problem is that our
> end-user applications aren't ms sql instances aware of and i need to
> provide an alias.
> i can change the alias on the user machines via some kind of gpo etc..
> Andrew
> Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
|||This sounds like either a DNS issue or that SQL Server is not listening on
TCP/IP. Check out the Server Network Utility on your cluster - or the SQL
Server errorlog to see what protocols SQL Server will "hear". Also, ensure
that your clients are using TCP/IP. Check out their Client Network Utility
to confirm.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"kreit" <kreit@.mail.ru> wrote in message
news:1118242276.507481.291570@.f14g2000cwb.googlegr oups.com...
If i remove - i just can't connect..
Andrew
Tom Moreau писал(а):[vbcol=seagreen]
> This sounds strange. Have you tried removing the aliases from the client
> machines?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118228154.834811.10600@.o13g2000cwo.googlegro ups.com...
> I run cliconfg.exe on the clients side. The problem is that our
> end-user applications aren't ms sql instances aware of and i need to
> provide an alias.
> i can change the alias on the user machines via some kind of gpo etc..
> Andrew
> Tom Moreau писал(а):
|||with tcp/ip everything is ok. I've a problem with named pipes. Our
application isn't tcp/ip aware, just named pipes - thats all.
Andrew
Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
> This sounds like either a DNS issue or that SQL Server is not listening on
> TCP/IP. Check out the Server Network Utility on your cluster - or the SQL
> Server errorlog to see what protocols SQL Server will "hear". Also, ensu=
re
> that your clients are using TCP/IP. Check out their Client Network Utili=
ty[vbcol=seagreen]
> to confirm.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "kreit" <kreit@.mail.ru> wrote in message
> news:1118242276.507481.291570@.f14g2000cwb.googlegr oups.com...
> If i remove - i just can't connect..
> Andrew
> Tom Moreau =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
nt[vbcol=seagreen]
ql[vbcol=seagreen]
s?[vbcol=seagreen]
|||ok, for example
Active-Active cluster. One instance server1, another one -
server2\instance
Since my application isnt't cluster aware i create an alias to connect
via named pipes.
- server alias: server2
- server name: server2\instance
- pipe name: \\server2\pipe\MSSQL$INSTANCE\sql\query
when server2 fails over to server1 i can't use my application. At this
moment I can ping server2 successfully.
If i change on the client the alias server2:
- server alias: server2 (it's the same)
- server name: server1
- pipe name: \\server1\pipe\\sql\query
I can connect and can't use my application
|||kreit wrote:
> The cluster consists of two nodes and of two instances. One default sql
> instance and one another named instanse.
>
> To connect to the named instance all the clients have alias(done by
> cliconfg.exe), but when the instance fails over to another node no one
> can't connect to this named instance anymore. If i edit the alias to
> use the default instance pipe name, this helps!
>
> It seems named pipes don't fail over to another node.. Any suggestions?
>
Maybe some of the registry is not replicated. In the cluster registry
there should be about 7 registry entries for each sql server resource
which are used to replicate some of the sql registry keys. Check if they
exist. Also check the contents of software\microsoft\microsoft sql
server\instance\mssqlserver\supersocketnetlib\np\p ipename on the problem
node when sql is running there.
The service account of the default instance should be able to read the
registry key's of the named instance and vice versa. Sqlservers log
mentions its listening on named pipes?
What I think is kind of strange is that you are able to use the client
network tools aliases but not tcp\ip. Your program should not even know
about named pipes or tcp/ip. It just needs to talk to the sqldriver.
Maybe its time to instal ethereal (http://www.ethereal.com/) on one of
the clients.
Hans
|||kreit wrote:
> ok, for example
> Active-Active cluster. One instance server1, another one -
> server2\instance
> Since my application isnt't cluster aware i create an alias to connect
> via named pipes.
> - server alias: server2
> - server name: server2\instance
> - pipe name: \\server2\pipe\MSSQL$INSTANCE\sql\query
>
> when server2 fails over to server1 i can't use my application. At this
> moment I can ping server2 successfully.
> If i change on the client the alias server2:
> - server alias: server2 (it's the same)
> - server name: server1
> - pipe name: \\server1\pipe\\sql\query
> I can connect and can't use my application
>
Just to make very sure, you do know the difference between the virtual
server name and the node name?
'when server2 fails over to server1 i can't use my application'
should be:
'when virtual server2 fails over to node1 i can't use my application'
Clients should connect to the virtual server name and not to the not to
the name of the physical server.
Hans
sql
Monday, March 26, 2012
Named Pipe and Clustering
Hi,
I need to disable named pipes in a SQL Cluster environment (Windows 2000 and
SQL 2000 latest SP). Here is the scenario:
Our security policy requires me to secure my production SQL Server (Virtual
SQL Cluster name=SQL01) by disabling any access to SQL Server except access
from application server. I implemented this security in UAT (Non clustered )
by creating an IPSEC filter and disabling Named Pipes on SQL Server. In one
IPSEC filter, All IP Traffic to port 1433 is blocked. In another filter,
traffic from application server IP Address is permitted. This configuration
worked fine in UAT.
When I promoted the same IPSEC policy to production (both nodes
active-passive), I noticed that I can't disable Named Pipes in cluster
environment. Is there any work around this?
Can I change default pipe for Named Pipe in order to block SQL connections
coming from default pipe?
Do you have any better suggestion to secure SQL Server?
ThanksThis was an update in sp3 that was not well documented. After installing
sp3, you can't remove Named Pipes on a Cluster. If Named Pipes was
previously removed (prior to sp3) , then it will not add it back.
We experienced numerous customer problems where the server would not come
online, and it was only listening on tcp. Here's the full reference in the
kb.
831127 Named Pipes Support Cannot Be Removed on a Virtual Server That Is
http://support.microsoft.com/?id=831127
My recommendation would be to use ISA server and publish the SQL Server.
This will allow you to only publish the TCP netlib.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
I need to disable named pipes in a SQL Cluster environment (Windows 2000 and
SQL 2000 latest SP). Here is the scenario:
Our security policy requires me to secure my production SQL Server (Virtual
SQL Cluster name=SQL01) by disabling any access to SQL Server except access
from application server. I implemented this security in UAT (Non clustered )
by creating an IPSEC filter and disabling Named Pipes on SQL Server. In one
IPSEC filter, All IP Traffic to port 1433 is blocked. In another filter,
traffic from application server IP Address is permitted. This configuration
worked fine in UAT.
When I promoted the same IPSEC policy to production (both nodes
active-passive), I noticed that I can't disable Named Pipes in cluster
environment. Is there any work around this?
Can I change default pipe for Named Pipe in order to block SQL connections
coming from default pipe?
Do you have any better suggestion to secure SQL Server?
ThanksThis was an update in sp3 that was not well documented. After installing
sp3, you can't remove Named Pipes on a Cluster. If Named Pipes was
previously removed (prior to sp3) , then it will not add it back.
We experienced numerous customer problems where the server would not come
online, and it was only listening on tcp. Here's the full reference in the
kb.
831127 Named Pipes Support Cannot Be Removed on a Virtual Server That Is
http://support.microsoft.com/?id=831127
My recommendation would be to use ISA server and publish the SQL Server.
This will allow you to only publish the TCP netlib.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
named instances
I am setting up a 3 + 1 Windows 2003 Server cluster hosting 3 named instances of SQL Server 2000 on the active servers. This SQL Farm will support approximately 150 databases supporting 15 different groups of applications distrbuted amongst a user population of 5000 desktops over mutiple sites. Each named instance of SQL Server will initially host a different subset of the databases. To optimise the server load on each of the 3 active cluster members, over time I want to be able to move the databases supporting any particular application group from one server to a different server in the cluster. Ideally I would like to do this without having to change anything on the client side. I cannot think of any way to do this as I think the client connections will have to refer to the instance name, which in turn will refer to the virtual server name. If anyone knows how I can do this I would appreciate your directions. ThanksHi,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
As my understanding of you question, you want to optimise the server load
within a clustered SQL Server environment and you want to move the database
from one serve to another. If you want to move the databases from one
virtual server to another (in the cluster), you have to make changes to
your client connections as they now need to connect to a new server that
has the databases. The client machines can have alias that point to a
virtual server. In this case, the clients can use the same alias but still
you still have to change alias to point to the new virtual server after the
databases are moved.
Hope this helps and if you still have questions, please feel free to post
new message here and I am ready to help!
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Baisong Wei,
Thnaks for your response, from your description you
understand the problem well. To reiterate I would like to
be able to move databases between the named instances
running on the virtual servers and to update the location
by changing something centrally (like a dns alias or a
server side alias) without having to change anything on
the clients. But the only way I can think of doing it is
to make a synchronised change on all the clients as they
have to refer to both the virtual server name and the
instance name. Any ideas?
Thanks
Geoff.
>--Original Message--
>Hi,
>Thank you for using the newsgroup and it is my pleasure
to help you with
>you issue.
>As my understanding of you question, you want to
optimise the server load
>within a clustered SQL Server environment and you want
to move the database
>from one serve to another. If you want to move the
databases from one
>virtual server to another (in the cluster), you have to
make changes to
>your client connections as they now need to connect to a
new server that
>has the databases. The client machines can have alias
that point to a
>virtual server. In this case, the clients can use the
same alias but still
>you still have to change alias to point to the new
virtual server after the
>databases are moved.
>Hope this helps and if you still have questions, please
feel free to post
>new message here and I am ready to help!
>Thanks.
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>.
>|||Hello Geoff,
As per my knowledge, there may not be a central way to achieve this.
Since you want to move the databases to a different virtual server,
you would need to make appropriate changes to the clients connection
strings. It is the same as moving dbs from one SQL Server to another.
Only difference is that you are using virtual SQL Server.Virtual SQL
Servers is for high availability and not for load balancing.
Does that answer you question ?
Thanks for using MSDN Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no
rights.
>Content-Class: urn:content-classes:message
>From: <anonymous@.discussions.microsoft.com>
>Sender: <anonymous@.discussions.microsoft.com>
>References: <E539FE0B-030C-4315-8677-41CAD358B95D@.microsoft.com>
<fAHzT4t6DHA.568@.cpmsftngxa07.phx.gbl>
>Subject: RE: named instances
>Date: Wed, 4 Feb 2004 03:16:59 -0800
>Lines: 59
>Message-ID: <0a1901c3eb10$6815d050$3501280a@.phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcPrEGgVFRmJzG6iTB2Kxa9WPaBHUA==>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:327510
>NNTP-Posting-Host: tk2msftngxa06.phx.gbl 10.40.1.53
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Baisong Wei,
>Thnaks for your response, from your description you
>understand the problem well. To reiterate I would like to
>be able to move databases between the named instances
>running on the virtual servers and to update the location
>by changing something centrally (like a dns alias or a
>server side alias) without having to change anything on
>the clients. But the only way I can think of doing it is
>to make a synchronised change on all the clients as they
>have to refer to both the virtual server name and the
>instance name. Any ideas?
>Thanks
>Geoff.
>>--Original Message--
>>Hi,
>>Thank you for using the newsgroup and it is my pleasure
>to help you with
>>you issue.
>>As my understanding of you question, you want to
>optimise the server load
>>within a clustered SQL Server environment and you want
>to move the database
>>from one serve to another. If you want to move the
>databases from one
>>virtual server to another (in the cluster), you have to
>make changes to
>>your client connections as they now need to connect to a
>new server that
>>has the databases. The client machines can have alias
>that point to a
>>virtual server. In this case, the clients can use the
>same alias but still
>>you still have to change alias to point to the new
>virtual server after the
>>databases are moved.
>>Hope this helps and if you still have questions, please
>feel free to post
>>new message here and I am ready to help!
>>Thanks.
>>Best regards
>>Baisong Wei
>>Microsoft Online Support
>>----
>>Get Secure! - www.microsoft.com/security
>>This posting is provided "as is" with no warranties and
>confers no rights.
>>Please reply to newsgroups only. Thanks.
>>.
>|||Vikrant
Thanks for your reply. We'd come to the same conclusion but I'm glad it has been confirmed by you guys
Cheer
Geoff.sql
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
As my understanding of you question, you want to optimise the server load
within a clustered SQL Server environment and you want to move the database
from one serve to another. If you want to move the databases from one
virtual server to another (in the cluster), you have to make changes to
your client connections as they now need to connect to a new server that
has the databases. The client machines can have alias that point to a
virtual server. In this case, the clients can use the same alias but still
you still have to change alias to point to the new virtual server after the
databases are moved.
Hope this helps and if you still have questions, please feel free to post
new message here and I am ready to help!
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Baisong Wei,
Thnaks for your response, from your description you
understand the problem well. To reiterate I would like to
be able to move databases between the named instances
running on the virtual servers and to update the location
by changing something centrally (like a dns alias or a
server side alias) without having to change anything on
the clients. But the only way I can think of doing it is
to make a synchronised change on all the clients as they
have to refer to both the virtual server name and the
instance name. Any ideas?
Thanks
Geoff.
>--Original Message--
>Hi,
>Thank you for using the newsgroup and it is my pleasure
to help you with
>you issue.
>As my understanding of you question, you want to
optimise the server load
>within a clustered SQL Server environment and you want
to move the database
>from one serve to another. If you want to move the
databases from one
>virtual server to another (in the cluster), you have to
make changes to
>your client connections as they now need to connect to a
new server that
>has the databases. The client machines can have alias
that point to a
>virtual server. In this case, the clients can use the
same alias but still
>you still have to change alias to point to the new
virtual server after the
>databases are moved.
>Hope this helps and if you still have questions, please
feel free to post
>new message here and I am ready to help!
>Thanks.
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>Please reply to newsgroups only. Thanks.
>.
>|||Hello Geoff,
As per my knowledge, there may not be a central way to achieve this.
Since you want to move the databases to a different virtual server,
you would need to make appropriate changes to the clients connection
strings. It is the same as moving dbs from one SQL Server to another.
Only difference is that you are using virtual SQL Server.Virtual SQL
Servers is for high availability and not for load balancing.
Does that answer you question ?
Thanks for using MSDN Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no
rights.
>Content-Class: urn:content-classes:message
>From: <anonymous@.discussions.microsoft.com>
>Sender: <anonymous@.discussions.microsoft.com>
>References: <E539FE0B-030C-4315-8677-41CAD358B95D@.microsoft.com>
<fAHzT4t6DHA.568@.cpmsftngxa07.phx.gbl>
>Subject: RE: named instances
>Date: Wed, 4 Feb 2004 03:16:59 -0800
>Lines: 59
>Message-ID: <0a1901c3eb10$6815d050$3501280a@.phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcPrEGgVFRmJzG6iTB2Kxa9WPaBHUA==>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:327510
>NNTP-Posting-Host: tk2msftngxa06.phx.gbl 10.40.1.53
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Baisong Wei,
>Thnaks for your response, from your description you
>understand the problem well. To reiterate I would like to
>be able to move databases between the named instances
>running on the virtual servers and to update the location
>by changing something centrally (like a dns alias or a
>server side alias) without having to change anything on
>the clients. But the only way I can think of doing it is
>to make a synchronised change on all the clients as they
>have to refer to both the virtual server name and the
>instance name. Any ideas?
>Thanks
>Geoff.
>>--Original Message--
>>Hi,
>>Thank you for using the newsgroup and it is my pleasure
>to help you with
>>you issue.
>>As my understanding of you question, you want to
>optimise the server load
>>within a clustered SQL Server environment and you want
>to move the database
>>from one serve to another. If you want to move the
>databases from one
>>virtual server to another (in the cluster), you have to
>make changes to
>>your client connections as they now need to connect to a
>new server that
>>has the databases. The client machines can have alias
>that point to a
>>virtual server. In this case, the clients can use the
>same alias but still
>>you still have to change alias to point to the new
>virtual server after the
>>databases are moved.
>>Hope this helps and if you still have questions, please
>feel free to post
>>new message here and I am ready to help!
>>Thanks.
>>Best regards
>>Baisong Wei
>>Microsoft Online Support
>>----
>>Get Secure! - www.microsoft.com/security
>>This posting is provided "as is" with no warranties and
>confers no rights.
>>Please reply to newsgroups only. Thanks.
>>.
>|||Vikrant
Thanks for your reply. We'd come to the same conclusion but I'm glad it has been confirmed by you guys
Cheer
Geoff.sql
named instances
I am setting up a 3 + 1 Windows 2003 Server cluster hosting 3 named instance
s of SQL Server 2000 on the active servers. This SQL Farm will support appro
ximately 150 databases supporting 15 different groups of applications distrb
uted amongst a user populat
ion of 5000 desktops over mutiple sites. Each named instance of SQL Server
will initially host a different subset of the databases. To optimise the se
rver load on each of the 3 active cluster members, over time I want to be ab
le to move the databases su
pporting any particular application group from one server to a different ser
ver in the cluster. Ideally I would like to do this without having to chang
e anything on the client side. I cannot think of any way to do this as I th
ink the client connections
will have to refer to the instance name, which in turn will refer to the vir
tual server name. If anyone knows how I can do this I would appreciate your
directions. ThanksHi,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
As my understanding of you question, you want to optimise the server load
within a clustered SQL Server environment and you want to move the database
from one serve to another. If you want to move the databases from one
virtual server to another (in the cluster), you have to make changes to
your client connections as they now need to connect to a new server that
has the databases. The client machines can have alias that point to a
virtual server. In this case, the clients can use the same alias but still
you still have to change alias to point to the new virtual server after the
databases are moved.
Hope this helps and if you still have questions, please feel free to post
new message here and I am ready to help!
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Baisong Wei,
Thnaks for your response, from your description you
understand the problem well. To reiterate I would like to
be able to move databases between the named instances
running on the virtual servers and to update the location
by changing something centrally (like a dns alias or a
server side alias) without having to change anything on
the clients. But the only way I can think of doing it is
to make a synchronised change on all the clients as they
have to refer to both the virtual server name and the
instance name. Any ideas?
Thanks
Geoff.
to help you with
optimise the server load
to move the database
databases from one
make changes to
new server that
that point to a
same alias but still
virtual server after the
feel free to post
confers no rights.
As per my knowledge, there may not be a central way to achieve this.
Since you want to move the databases to a different virtual server,
you would need to make appropriate changes to the clients connection
strings. It is the same as moving dbs from one SQL Server to another.
Only difference is that you are using virtual SQL Server.Virtual SQL
Servers is for high availability and not for load balancing.
Does that answer you question ?
Thanks for using MSDN Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computers security.
This posting is provided "AS IS" with no warranties, and confers no
rights.
--
>Content-Class: urn:content-classes:message
>From: <anonymous@.discussions.microsoft.com>
>Sender: <anonymous@.discussions.microsoft.com>
>References: <E539FE0B-030C-4315-8677-41CAD358B95D@.microsoft.com>
<fAHzT4t6DHA.568@.cpmsftngxa07.phx.gbl>
>Subject: RE: named instances
>Date: Wed, 4 Feb 2004 03:16:59 -0800
>Lines: 59
>Message-ID: <0a1901c3eb10$6815d050$3501280a@.phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcPrEGgVFRmJzG6iTB2Kxa9WPaBHUA==
>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:327510
>NNTP-Posting-Host: tk2msftngxa06.phx.gbl 10.40.1.53
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Baisong Wei,
>Thnaks for your response, from your description you
>understand the problem well. To reiterate I would like to
>be able to move databases between the named instances
>running on the virtual servers and to update the location
>by changing something centrally (like a dns alias or a
>server side alias) without having to change anything on
>the clients. But the only way I can think of doing it is
>to make a synchronised change on all the clients as they
>have to refer to both the virtual server name and the
>instance name. Any ideas?
>Thanks
>Geoff.
>to help you with
>optimise the server load
>to move the database
>databases from one
>make changes to
>new server that
>that point to a
>same alias but still
>virtual server after the
>feel free to post
>confers no rights.
>|||Vikrant,
Thanks for your reply. We'd come to the same conclusion but I'm glad it has
been confirmed by you guys.
Cheers
Geoff.
s of SQL Server 2000 on the active servers. This SQL Farm will support appro
ximately 150 databases supporting 15 different groups of applications distrb
uted amongst a user populat
ion of 5000 desktops over mutiple sites. Each named instance of SQL Server
will initially host a different subset of the databases. To optimise the se
rver load on each of the 3 active cluster members, over time I want to be ab
le to move the databases su
pporting any particular application group from one server to a different ser
ver in the cluster. Ideally I would like to do this without having to chang
e anything on the client side. I cannot think of any way to do this as I th
ink the client connections
will have to refer to the instance name, which in turn will refer to the vir
tual server name. If anyone knows how I can do this I would appreciate your
directions. ThanksHi,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
As my understanding of you question, you want to optimise the server load
within a clustered SQL Server environment and you want to move the database
from one serve to another. If you want to move the databases from one
virtual server to another (in the cluster), you have to make changes to
your client connections as they now need to connect to a new server that
has the databases. The client machines can have alias that point to a
virtual server. In this case, the clients can use the same alias but still
you still have to change alias to point to the new virtual server after the
databases are moved.
Hope this helps and if you still have questions, please feel free to post
new message here and I am ready to help!
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Baisong Wei,
Thnaks for your response, from your description you
understand the problem well. To reiterate I would like to
be able to move databases between the named instances
running on the virtual servers and to update the location
by changing something centrally (like a dns alias or a
server side alias) without having to change anything on
the clients. But the only way I can think of doing it is
to make a synchronised change on all the clients as they
have to refer to both the virtual server name and the
instance name. Any ideas?
Thanks
Geoff.
quote:
>--Original Message--
>Hi,
>Thank you for using the newsgroup and it is my pleasure
to help you with
quote:
>you issue.
>As my understanding of you question, you want to
optimise the server load
quote:
>within a clustered SQL Server environment and you want
to move the database
quote:
>from one serve to another. If you want to move the
databases from one
quote:
>virtual server to another (in the cluster), you have to
make changes to
quote:
>your client connections as they now need to connect to a
new server that
quote:
>has the databases. The client machines can have alias
that point to a
quote:
>virtual server. In this case, the clients can use the
same alias but still
quote:
>you still have to change alias to point to the new
virtual server after the
quote:
>databases are moved.
>Hope this helps and if you still have questions, please
feel free to post
quote:
>new message here and I am ready to help!
>Thanks.
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
quote:|||Hello Geoff,
>Please reply to newsgroups only. Thanks.
>.
>
As per my knowledge, there may not be a central way to achieve this.
Since you want to move the databases to a different virtual server,
you would need to make appropriate changes to the clients connection
strings. It is the same as moving dbs from one SQL Server to another.
Only difference is that you are using virtual SQL Server.Virtual SQL
Servers is for high availability and not for load balancing.
Does that answer you question ?
Thanks for using MSDN Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit
the http://www.microsoft.com/protect site and perform the three
straightforward steps listed to improve your computers security.
This posting is provided "AS IS" with no warranties, and confers no
rights.
--
>Content-Class: urn:content-classes:message
>From: <anonymous@.discussions.microsoft.com>
>Sender: <anonymous@.discussions.microsoft.com>
>References: <E539FE0B-030C-4315-8677-41CAD358B95D@.microsoft.com>
<fAHzT4t6DHA.568@.cpmsftngxa07.phx.gbl>
>Subject: RE: named instances
>Date: Wed, 4 Feb 2004 03:16:59 -0800
>Lines: 59
>Message-ID: <0a1901c3eb10$6815d050$3501280a@.phx.gbl>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcPrEGgVFRmJzG6iTB2Kxa9WPaBHUA==
>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.server:327510
>NNTP-Posting-Host: tk2msftngxa06.phx.gbl 10.40.1.53
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Baisong Wei,
>Thnaks for your response, from your description you
>understand the problem well. To reiterate I would like to
>be able to move databases between the named instances
>running on the virtual servers and to update the location
>by changing something centrally (like a dns alias or a
>server side alias) without having to change anything on
>the clients. But the only way I can think of doing it is
>to make a synchronised change on all the clients as they
>have to refer to both the virtual server name and the
>instance name. Any ideas?
>Thanks
>Geoff.
>to help you with
>optimise the server load
>to move the database
>databases from one
>make changes to
>new server that
>that point to a
>same alias but still
>virtual server after the
>feel free to post
>confers no rights.
>|||Vikrant,
Thanks for your reply. We'd come to the same conclusion but I'm glad it has
been confirmed by you guys.
Cheers
Geoff.
Named Instance On Cluster.
I am running a default instance on my Active\Passive cluster and want to
install a named instance on the same cluster. How is that done?
Hi
Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>I am running a default instance on my Active\Passive cluster and want to
>install a named instance on the same cluster. How is that done?
>
|||The problem is, I have a default instance running and when I run SQL
install, The Named Instance option is not available.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||You'll have to specify a new virtual server name and then specify an
instance for it.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:eqVHDWUbFHA.3184@.TK2MSFTNGP15.phx.gbl...
The problem is, I have a default instance running and when I run SQL
install, The Named Instance option is not available.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||And a new ip as well?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23WsMY$UbFHA.3864@.TK2MSFTNGP10.phx.gbl...
> You'll have to specify a new virtual server name and then specify an
> instance for it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:eqVHDWUbFHA.3184@.TK2MSFTNGP15.phx.gbl...
> The problem is, I have a default instance running and when I run SQL
> install, The Named Instance option is not available.
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
>
|||New IP, New Virtual Server\Instance Name, and all new disks for each SQL
Instance.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:ulFCVLVbFHA.2520@.TK2MSFTNGP09.phx.gbl...
> And a new ip as well?
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23WsMY$UbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
install a named instance on the same cluster. How is that done?
Hi
Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>I am running a default instance on my Active\Passive cluster and want to
>install a named instance on the same cluster. How is that done?
>
|||The problem is, I have a default instance running and when I run SQL
install, The Named Instance option is not available.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||You'll have to specify a new virtual server name and then specify an
instance for it.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:eqVHDWUbFHA.3184@.TK2MSFTNGP15.phx.gbl...
The problem is, I have a default instance running and when I run SQL
install, The Named Instance option is not available.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
> Hi
> Search for "How to create a new failover cluster " in SQL Server 2000 BOL.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:uBx4fGUbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
|||And a new ip as well?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23WsMY$UbFHA.3864@.TK2MSFTNGP10.phx.gbl...
> You'll have to specify a new virtual server name and then specify an
> instance for it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinpub.com
> .
> "Shawn" <sscamner@.bellsouth.net> wrote in message
> news:eqVHDWUbFHA.3184@.TK2MSFTNGP15.phx.gbl...
> The problem is, I have a default instance running and when I run SQL
> install, The Named Instance option is not available.
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:etyZXKUbFHA.2736@.TK2MSFTNGP12.phx.gbl...
>
|||New IP, New Virtual Server\Instance Name, and all new disks for each SQL
Instance.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shawn" <sscamner@.bellsouth.net> wrote in message
news:ulFCVLVbFHA.2520@.TK2MSFTNGP09.phx.gbl...
> And a new ip as well?
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23WsMY$UbFHA.3864@.TK2MSFTNGP10.phx.gbl...
>
Friday, March 23, 2012
Named Instance in a SQL 2000 Cluster
Hi,
When I installed a SQL 2000 Cluster Active/Active I defined one default
instance as SERVER01 and the other instance as SERVER02/I2. Is it
possible to use the second instance without put "/I2" at the end of name
server?
Do I must to install two named instances instead one default instance
and one named instance ?
thanks,
Rubens
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You can only have one default instance, the rest have to be named. You can
also create only named instances, and not have a default.
At this point, you can uninstall the default instance. Then, install a
second named instance.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Rubens Sanches" <rubensluque@.yahoo.com.br> wrote in message
news:%23SB%233M9LFHA.1472@.TK2MSFTNGP14.phx.gbl...
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
> thanks,
> Rubens
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Rubens Sanches wrote:
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
>
yes, but you can run every instance on the cluster at the default port 1433.
When clients connect to the instance they do not need the instance name when
connecting to the server as long as they use tcp/ip and now the
sqlserverport. Try osql -E -Sserver02,1433 or server02,1433 when
registering the server whith the enterprise manager. When you create an odbc
connection deselect automaticly detect the server port, fill in the port
number and forget the instance name.
Hans
|||Hi
Check that SERVER01 is actually a cluster resource. For clusters, the only
way for it to be correct is virtualservername\instancename
SERVER02/I2 is correct, but SERVER01 can not be.
Regards
Mike
"Rubens Sanches" wrote:
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
> thanks,
> Rubens
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
|||Mike,
SERVER01 is a default clustered SQL instance and is the virtualservername. Since it is a default instance, it will work. It does not need an instance name.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
When I installed a SQL 2000 Cluster Active/Active I defined one default
instance as SERVER01 and the other instance as SERVER02/I2. Is it
possible to use the second instance without put "/I2" at the end of name
server?
Do I must to install two named instances instead one default instance
and one named instance ?
thanks,
Rubens
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
You can only have one default instance, the rest have to be named. You can
also create only named instances, and not have a default.
At this point, you can uninstall the default instance. Then, install a
second named instance.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Rubens Sanches" <rubensluque@.yahoo.com.br> wrote in message
news:%23SB%233M9LFHA.1472@.TK2MSFTNGP14.phx.gbl...
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
> thanks,
> Rubens
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Rubens Sanches wrote:
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
>
yes, but you can run every instance on the cluster at the default port 1433.
When clients connect to the instance they do not need the instance name when
connecting to the server as long as they use tcp/ip and now the
sqlserverport. Try osql -E -Sserver02,1433 or server02,1433 when
registering the server whith the enterprise manager. When you create an odbc
connection deselect automaticly detect the server port, fill in the port
number and forget the instance name.
Hans
|||Hi
Check that SERVER01 is actually a cluster resource. For clusters, the only
way for it to be correct is virtualservername\instancename
SERVER02/I2 is correct, but SERVER01 can not be.
Regards
Mike
"Rubens Sanches" wrote:
> Hi,
> When I installed a SQL 2000 Cluster Active/Active I defined one default
> instance as SERVER01 and the other instance as SERVER02/I2. Is it
> possible to use the second instance without put "/I2" at the end of name
> server?
> Do I must to install two named instances instead one default instance
> and one named instance ?
> thanks,
> Rubens
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
|||Mike,
SERVER01 is a default clustered SQL instance and is the virtualservername. Since it is a default instance, it will work. It does not need an instance name.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
Named Instance
hi,
i wanted to have my 2 node server cluster as active-active. DO i need to put
the named pipes in both servers before i install sql2000 or just on the one
that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2.
do i need to put both of them in CNU and install sql on first node and
proceed to another? pls advice.. just a bit blur on that part.Also when do i
need to remove this named pipes? JUST after installation and sqlspa3
completed?
TIA
Hi
During the SQL Server Install on a cluster, the setup creates the instances
and copies the binaries to all nodes. It is not a good idea to have any SQL
server installed intances prior to configuring clustering.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rupart" wrote:
> hi,
> i wanted to have my 2 node server cluster as active-active. DO i need to put
> the named pipes in both servers before i install sql2000 or just on the one
> that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2.
> do i need to put both of them in CNU and install sql on first node and
> proceed to another? pls advice.. just a bit blur on that part.Also when do i
> need to remove this named pipes? JUST after installation and sqlspa3
> completed?
> TIA
i wanted to have my 2 node server cluster as active-active. DO i need to put
the named pipes in both servers before i install sql2000 or just on the one
that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2.
do i need to put both of them in CNU and install sql on first node and
proceed to another? pls advice.. just a bit blur on that part.Also when do i
need to remove this named pipes? JUST after installation and sqlspa3
completed?
TIA
Hi
During the SQL Server Install on a cluster, the setup creates the instances
and copies the binaries to all nodes. It is not a good idea to have any SQL
server installed intances prior to configuring clustering.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rupart" wrote:
> hi,
> i wanted to have my 2 node server cluster as active-active. DO i need to put
> the named pipes in both servers before i install sql2000 or just on the one
> that i wanted to install the instance?i will have VSS1/INST1 and VSS2/INST2.
> do i need to put both of them in CNU and install sql on first node and
> proceed to another? pls advice.. just a bit blur on that part.Also when do i
> need to remove this named pipes? JUST after installation and sqlspa3
> completed?
> TIA
Wednesday, March 21, 2012
Name Change of Server
Hello,
When seting up my cluster it asked for a instance name instead using the default so I gave it one and now my cluster name is BankingSQL\BankingSQL how can I change this to just BankingSQL also in a way that it doesnt mess up my cluster.
SQL Named Instances are always accessed via [VirtualServerName]\[SQL Instance Name]. You "may" be able to do something clever with a DNS PTR record but I've not tried it. I'm also not sure what effect this would have on the Cluster Service (don't do you
r testing in a production environment).
|||Assuming that you don't wish to configure a client alias (cliconfg.exe) you could use a DNS CNAME alias record. For more info look up the CNAME in the windows DNS documentation.
|||You cannot change the SQL cluster name. You will need to uninstall and
reinstall to actually cchange the name. The methods suggested will allow
users to connect uisng the name you want but will not change the actual
name.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Actually, you need a SRV record in the DNS server. SRV records point to IP
and port numbers.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Stephen Strong" <anonymous@.discussions.microsoft.com> wrote in message
news:18DED1C1-591D-4475-A01C-4C2F6328759B@.microsoft.com...
> Assuming that you don't wish to configure a client alias (cliconfg.exe)
you could use a DNS CNAME alias record. For more info look up the CNAME in
the windows DNS documentation.
When seting up my cluster it asked for a instance name instead using the default so I gave it one and now my cluster name is BankingSQL\BankingSQL how can I change this to just BankingSQL also in a way that it doesnt mess up my cluster.
SQL Named Instances are always accessed via [VirtualServerName]\[SQL Instance Name]. You "may" be able to do something clever with a DNS PTR record but I've not tried it. I'm also not sure what effect this would have on the Cluster Service (don't do you
r testing in a production environment).
|||Assuming that you don't wish to configure a client alias (cliconfg.exe) you could use a DNS CNAME alias record. For more info look up the CNAME in the windows DNS documentation.
|||You cannot change the SQL cluster name. You will need to uninstall and
reinstall to actually cchange the name. The methods suggested will allow
users to connect uisng the name you want but will not change the actual
name.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Actually, you need a SRV record in the DNS server. SRV records point to IP
and port numbers.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Stephen Strong" <anonymous@.discussions.microsoft.com> wrote in message
news:18DED1C1-591D-4475-A01C-4C2F6328759B@.microsoft.com...
> Assuming that you don't wish to configure a client alias (cliconfg.exe)
you could use a DNS CNAME alias record. For more info look up the CNAME in
the windows DNS documentation.
Friday, March 9, 2012
MySQL Cluster
Hi
Could somebody may explain me how works backup in clusters ?
Thanks
AdamYou may want to post this to the appropriate group; this is a group for
Microsoft SQL Server. Although a few of us may have experience with
MySQL, you'll probably get more information from a group dedicated to
MySQL.|||Stu wrote:
> You may want to post this to the appropriate group; this is a group for
> Microsoft SQL Server. Although a few of us may have experience with
> MySQL, you'll probably get more information from a group dedicated to
> MySQL.
Could somebody may explain me how works backup in clusters ?
Thanks
AdamYou may want to post this to the appropriate group; this is a group for
Microsoft SQL Server. Although a few of us may have experience with
MySQL, you'll probably get more information from a group dedicated to
MySQL.|||Stu wrote:
> You may want to post this to the appropriate group; this is a group for
> Microsoft SQL Server. Although a few of us may have experience with
> MySQL, you'll probably get more information from a group dedicated to
> MySQL.
Oh Sorry..I did mistake, I chose bad wrong group.
Thanks
Adam
Subscribe to:
Posts (Atom)