Good day,
I have recently installed a 2 node cluster server with SQL 2000 SP3 in my
network. and have found out that users connect to the Virtual cluster server
inorder to receive SQL services but they get the replay for the physical
node that holds the SQL.
I was wondering if this configuration can be changed so that the SQL servers
answers back with the IP address of the virtual server and not the physical
cluster.
the problem is that im working with a Firewall and we would like to restrict
the number of IP address that we expose to the world.
Thanks in advance
Oren Zippori
This is one of the wierd but unavoidable artifacts of clustering. You will
have to expose the host computer's IP addresses through the firewall.
Personally, I like to run my database servers on an restricted segment, just
to minimize the impact of stuff like this.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Oren Zippori" <orenzp@.hotmail.com> wrote in message
news:eu17pHbwFHA.3548@.tk2msftngp13.phx.gbl...
> Good day,
> I have recently installed a 2 node cluster server with SQL 2000 SP3 in my
> network. and have found out that users connect to the Virtual cluster
> server inorder to receive SQL services but they get the replay for the
> physical node that holds the SQL.
> I was wondering if this configuration can be changed so that the SQL
> servers answers back with the IP address of the virtual server and not the
> physical cluster.
> the problem is that im working with a Firewall and we would like to
> restrict the number of IP address that we expose to the world.
> Thanks in advance
> Oren Zippori
>
|||Thanks for the information on this Geoff.
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uNRVXAgwFHA.664@.tk2msftngp13.phx.gbl...
> This is one of the wierd but unavoidable artifacts of clustering. You
> will have to expose the host computer's IP addresses through the firewall.
> Personally, I like to run my database servers on an restricted segment,
> just to minimize the impact of stuff like this.
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Oren Zippori" <orenzp@.hotmail.com> wrote in message
> news:eu17pHbwFHA.3548@.tk2msftngp13.phx.gbl...
>
Showing posts with label virtual. Show all posts
Showing posts with label virtual. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Cluster name with multiple IP addresses?
Can multiple IP addresses be assigned to a cluster and/or virtual name?
I have a 2-node Active/Passive cluster on a switched (not routed) network.
Each node has 3 NICs, each on its own subnet;
a) public/client access - 192.168.10.0
b) private/cluster traffic - 10.0.0.0
c) data backup network - 192.168.20.0
The cluster name "SQLCLST" and the virtual machine name "SQLSVR" have been
defined with IP addresses on the public/client network.
My backup software is cluster aware but because the traffic is separated via
switched network, I need the cluster and/or virtual machine name to respond
to IP addresses on two different subnets. Is this possible? Did this make
sense? ;)
TIA
It is not an uncommon request, nor is it too difficult. Once you have the
NICs and networks defined in the cluser configuration, you run the SQL setup
wizard to add the networks to SQL Server. To use them effectively, look
into connection-specific suffixes. That way you can force traffic to a
particular network.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Can multiple IP addresses be assigned to a cluster and/or virtual name?
> I have a 2-node Active/Passive cluster on a switched (not routed) network.
> Each node has 3 NICs, each on its own subnet;
> a) public/client access - 192.168.10.0
> b) private/cluster traffic - 10.0.0.0
> c) data backup network - 192.168.20.0
> The cluster name "SQLCLST" and the virtual machine name "SQLSVR" have been
> defined with IP addresses on the public/client network.
> My backup software is cluster aware but because the traffic is separated
> via switched network, I need the cluster and/or virtual machine name to
> respond to IP addresses on two different subnets. Is this possible? Did
> this make sense? ;)
> TIA
>
|||Thanks for the quick info. Apparently it is a little more difficult than
that, heheh
I did not see any dialog/screen that allowed for the addition of new
network - only to modify node membership.
I have a ticket opened with MS. They have escalated it stating that they
don't even know if SQL will support this configuration and are attempting to
duplicate it in their labs. The MS SQL Data Engine Team manager stated they
may even have to look at the code...
Should you happen to have any detailed steps on making this work, I'd
appreciate it and apparently MS would too! LOL
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
> It is not an uncommon request, nor is it too difficult. Once you have the
> NICs and networks defined in the cluser configuration, you run the SQL
> setup wizard to add the networks to SQL Server. To use them effectively,
> look into connection-specific suffixes. That way you can force traffic to
> a particular network.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
> news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
>
|||OK, you are not trying to stack multiple IP addresses on a single NIC, you
are using a unique IP address for each NIC. That isn't a problem.
The problem comes from having the same DNS alias (network name) respond on
two different subnets. That is a networking issue, not a clustering issue.
I would use connection-specific domain suffixes to differentiate the
networks. Also, I would use DNS SRV records to abstract the names. I.E.
MySQLCluster points to the IP and port of the normal public NIC.
MySQLClusterBackup points to the IP and port on the backup LAN.
I have used this setup in the past and it works just fine.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
news:Ooh45iT2HHA.2752@.TK2MSFTNGP06.phx.gbl...
> Thanks for the quick info. Apparently it is a little more difficult than
> that, heheh
> I did not see any dialog/screen that allowed for the addition of new
> network - only to modify node membership.
> I have a ticket opened with MS. They have escalated it stating that they
> don't even know if SQL will support this configuration and are attempting
> to duplicate it in their labs. The MS SQL Data Engine Team manager stated
> they may even have to look at the code...
> Should you happen to have any detailed steps on making this work, I'd
> appreciate it and apparently MS would too! LOL
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
>
I have a 2-node Active/Passive cluster on a switched (not routed) network.
Each node has 3 NICs, each on its own subnet;
a) public/client access - 192.168.10.0
b) private/cluster traffic - 10.0.0.0
c) data backup network - 192.168.20.0
The cluster name "SQLCLST" and the virtual machine name "SQLSVR" have been
defined with IP addresses on the public/client network.
My backup software is cluster aware but because the traffic is separated via
switched network, I need the cluster and/or virtual machine name to respond
to IP addresses on two different subnets. Is this possible? Did this make
sense? ;)
TIA
It is not an uncommon request, nor is it too difficult. Once you have the
NICs and networks defined in the cluser configuration, you run the SQL setup
wizard to add the networks to SQL Server. To use them effectively, look
into connection-specific suffixes. That way you can force traffic to a
particular network.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Can multiple IP addresses be assigned to a cluster and/or virtual name?
> I have a 2-node Active/Passive cluster on a switched (not routed) network.
> Each node has 3 NICs, each on its own subnet;
> a) public/client access - 192.168.10.0
> b) private/cluster traffic - 10.0.0.0
> c) data backup network - 192.168.20.0
> The cluster name "SQLCLST" and the virtual machine name "SQLSVR" have been
> defined with IP addresses on the public/client network.
> My backup software is cluster aware but because the traffic is separated
> via switched network, I need the cluster and/or virtual machine name to
> respond to IP addresses on two different subnets. Is this possible? Did
> this make sense? ;)
> TIA
>
|||Thanks for the quick info. Apparently it is a little more difficult than
that, heheh
I did not see any dialog/screen that allowed for the addition of new
network - only to modify node membership.
I have a ticket opened with MS. They have escalated it stating that they
don't even know if SQL will support this configuration and are attempting to
duplicate it in their labs. The MS SQL Data Engine Team manager stated they
may even have to look at the code...
Should you happen to have any detailed steps on making this work, I'd
appreciate it and apparently MS would too! LOL
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
> It is not an uncommon request, nor is it too difficult. Once you have the
> NICs and networks defined in the cluser configuration, you run the SQL
> setup wizard to add the networks to SQL Server. To use them effectively,
> look into connection-specific suffixes. That way you can force traffic to
> a particular network.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
> news:%23Y%23s8Mv0HHA.5380@.TK2MSFTNGP04.phx.gbl...
>
|||OK, you are not trying to stack multiple IP addresses on a single NIC, you
are using a unique IP address for each NIC. That isn't a problem.
The problem comes from having the same DNS alias (network name) respond on
two different subnets. That is a networking issue, not a clustering issue.
I would use connection-specific domain suffixes to differentiate the
networks. Also, I would use DNS SRV records to abstract the names. I.E.
MySQLCluster points to the IP and port of the normal public NIC.
MySQLClusterBackup points to the IP and port on the backup LAN.
I have used this setup in the past and it works just fine.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Structured Chaos" <jeffery_tyree@.yahoo.com> wrote in message
news:Ooh45iT2HHA.2752@.TK2MSFTNGP06.phx.gbl...
> Thanks for the quick info. Apparently it is a little more difficult than
> that, heheh
> I did not see any dialog/screen that allowed for the addition of new
> network - only to modify node membership.
> I have a ticket opened with MS. They have escalated it stating that they
> don't even know if SQL will support this configuration and are attempting
> to duplicate it in their labs. The MS SQL Data Engine Team manager stated
> they may even have to look at the code...
> Should you happen to have any detailed steps on making this work, I'd
> appreciate it and apparently MS would too! LOL
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OQYwDPx0HHA.1184@.TK2MSFTNGP04.phx.gbl...
>
Cluster Install Q
Hi All, Can I set up a cluster on my PC (through virtual server) Can
someone point me out the docs of how to do it?
Thanks much.
Yes. See
http://www.microsoft.com/technet/pro...y/cvs2005.mspx
for the details
You could also attend a 4 day class in which you cluster everything with
Virtual Server 2005 - see www.clusterhelp.com for details.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Vai2000" <nospam@.microsoft.com> wrote in message
news:%23z68pvoIGHA.3060@.TK2MSFTNGP10.phx.gbl...
> Hi All, Can I set up a cluster on my PC (through virtual server) Can
> someone point me out the docs of how to do it?
> Thanks much.
>
someone point me out the docs of how to do it?
Thanks much.
Yes. See
http://www.microsoft.com/technet/pro...y/cvs2005.mspx
for the details
You could also attend a 4 day class in which you cluster everything with
Virtual Server 2005 - see www.clusterhelp.com for details.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"Vai2000" <nospam@.microsoft.com> wrote in message
news:%23z68pvoIGHA.3060@.TK2MSFTNGP10.phx.gbl...
> Hi All, Can I set up a cluster on my PC (through virtual server) Can
> someone point me out the docs of how to do it?
> Thanks much.
>
Thursday, March 22, 2012
Cluster Install
We have a Win2003 EE A/P cluster running on a DELL/EMC CX300. There are 2
logical disks defined outside of the quorum. When I install the Virtual
server, I select the parent group of the disks which happens to be the SQL
Server resource group which contains all resources except the clsuter
specific items. When I finish, I can only see one logical disk from within
EM even though both are on the node I am working from . Any thoughts on how
to see multiple logical disks?Starting with a LUN that is a cluster resource. Add the disk resource to
the SQL Resource group if it is not there already. Make the SQL Service
dependent on the additionan disk resource (just like the existing disk.)
You will have to stop SQL to change the dependencies.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:D52638EE-3297-4D6E-9971-7B7759DDD7A6@.microsoft.com...
> We have a Win2003 EE A/P cluster running on a DELL/EMC CX300. There are 2
> logical disks defined outside of the quorum. When I install the Virtual
> server, I select the parent group of the disks which happens to be the SQL
> Server resource group which contains all resources except the clsuter
> specific items. When I finish, I can only see one logical disk from
> within
> EM even though both are on the node I am working from . Any thoughts on
> how
> to see multiple logical disks?
logical disks defined outside of the quorum. When I install the Virtual
server, I select the parent group of the disks which happens to be the SQL
Server resource group which contains all resources except the clsuter
specific items. When I finish, I can only see one logical disk from within
EM even though both are on the node I am working from . Any thoughts on how
to see multiple logical disks?Starting with a LUN that is a cluster resource. Add the disk resource to
the SQL Resource group if it is not there already. Make the SQL Service
dependent on the additionan disk resource (just like the existing disk.)
You will have to stop SQL to change the dependencies.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:D52638EE-3297-4D6E-9971-7B7759DDD7A6@.microsoft.com...
> We have a Win2003 EE A/P cluster running on a DELL/EMC CX300. There are 2
> logical disks defined outside of the quorum. When I install the Virtual
> server, I select the parent group of the disks which happens to be the SQL
> Server resource group which contains all resources except the clsuter
> specific items. When I finish, I can only see one logical disk from
> within
> EM even though both are on the node I am working from . Any thoughts on
> how
> to see multiple logical disks?
Monday, March 19, 2012
cluseter name (virtual server name)
Hi ,
is there any command to display current cluster name through query .
Thanks
ARR
Aswered in this NG: xp_readreg thread
Regards
Mike
"Aju" wrote:
> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>
>
is there any command to display current cluster name through query .
Thanks
ARR
Aswered in this NG: xp_readreg thread
Regards
Mike
"Aju" wrote:
> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>
>
cluseter name (virtual server name)
Hi ,
is there any command to display current cluster name through query .
Thanks
ARRAswered in this NG: xp_readreg thread
Regards
Mike
"Aju" wrote:
> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>
>
is there any command to display current cluster name through query .
Thanks
ARRAswered in this NG: xp_readreg thread
Regards
Mike
"Aju" wrote:
> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>
>
cluseter name (virtual server name)
Hi ,
is there any command to display current cluster name through query .
Thanks
ARRAswered in this NG: xp_readreg thread
Regards
Mike
"Aju" wrote:
> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>
>
is there any command to display current cluster name through query .
Thanks
ARRAswered in this NG: xp_readreg thread
Regards
Mike
"Aju" wrote:
> Hi ,
> is there any command to display current cluster name through query .
> Thanks
> ARR
>
>
Saturday, February 25, 2012
cloning servers with sql server on them
Anyone have any experience with cloning servers that have sql server
installed. I am wondering what will happen when the new virtual server comes
up using a different name. sql server takes it name from the server name.
Will it just automatically adjust or is there a process to deal with that?
Thanks.
If it's SQL Server 2005 and it has never run after installation, it will
"fix" itself upon first startup. Else, it's a simple process to
drop/register the new server name (just like in 2000). If you have other
objects in there name/server dependencies, well, that gets a little more
complicated.
joe.
"jason" <jason@.discussions.microsoft.com> wrote in message
news:68DB416E-E2B6-4E21-996C-2A99B37D6C01@.microsoft.com...
> Anyone have any experience with cloning servers that have sql server
> installed. I am wondering what will happen when the new virtual server
> comes
> up using a different name. sql server takes it name from the server name.
> Will it just automatically adjust or is there a process to deal with that?
> Thanks.
>
|||Hello Jason,
If you rename a server with SQL 2000/2005 installed, you may want to use
sp_dropserver to drop old server name, and then run sp_addserver to add the
new server name.
303774BUG: "Renaming A Server" Topic in SQL Server Books Online is
Incomplete
http://support.microsoft.com/default.aspx?scid=kb;EN-US;303774
317241Renaming a host computer for SQL Server causes stored procedure
debug to fail
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317241
281642PRB: Error 14274 Occurs When You Update a SQL Agent Job After
Renaming Windows Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;281642
Please let me know if you have any comments or questions. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
installed. I am wondering what will happen when the new virtual server comes
up using a different name. sql server takes it name from the server name.
Will it just automatically adjust or is there a process to deal with that?
Thanks.
If it's SQL Server 2005 and it has never run after installation, it will
"fix" itself upon first startup. Else, it's a simple process to
drop/register the new server name (just like in 2000). If you have other
objects in there name/server dependencies, well, that gets a little more
complicated.
joe.
"jason" <jason@.discussions.microsoft.com> wrote in message
news:68DB416E-E2B6-4E21-996C-2A99B37D6C01@.microsoft.com...
> Anyone have any experience with cloning servers that have sql server
> installed. I am wondering what will happen when the new virtual server
> comes
> up using a different name. sql server takes it name from the server name.
> Will it just automatically adjust or is there a process to deal with that?
> Thanks.
>
|||Hello Jason,
If you rename a server with SQL 2000/2005 installed, you may want to use
sp_dropserver to drop old server name, and then run sp_addserver to add the
new server name.
303774BUG: "Renaming A Server" Topic in SQL Server Books Online is
Incomplete
http://support.microsoft.com/default.aspx?scid=kb;EN-US;303774
317241Renaming a host computer for SQL Server causes stored procedure
debug to fail
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317241
281642PRB: Error 14274 Occurs When You Update a SQL Agent Job After
Renaming Windows Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;281642
Please let me know if you have any comments or questions. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
cloning servers with sql server on them
Anyone have any experience with cloning servers that have sql server
installed. I am wondering what will happen when the new virtual server come
s
up using a different name. sql server takes it name from the server name.
Will it just automatically adjust or is there a process to deal with that?
Thanks.If it's SQL Server 2005 and it has never run after installation, it will
"fix" itself upon first startup. Else, it's a simple process to
drop/register the new server name (just like in 2000). If you have other
objects in there name/server dependencies, well, that gets a little more
complicated.
joe.
"jason" <jason@.discussions.microsoft.com> wrote in message
news:68DB416E-E2B6-4E21-996C-2A99B37D6C01@.microsoft.com...
> Anyone have any experience with cloning servers that have sql server
> installed. I am wondering what will happen when the new virtual server
> comes
> up using a different name. sql server takes it name from the server name.
> Will it just automatically adjust or is there a process to deal with that?
> Thanks.
>|||Hello Jason,
If you rename a server with SQL 2000/2005 installed, you may want to use
sp_dropserver to drop old server name, and then run sp_addserver to add the
new server name.
303774 BUG: "Renaming A Server" Topic in SQL Server Books Online is
Incomplete
http://support.microsoft.com/defaul...kb;EN-US;303774
317241 Renaming a host computer for SQL Server causes stored procedure
debug to fail
http://support.microsoft.com/defaul...kb;EN-US;317241
281642 PRB: Error 14274 Occurs When You Update a SQL Agent Job After
Renaming Windows Server
http://support.microsoft.com/defaul...kb;EN-US;281642
Please let me know if you have any comments or questions. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
installed. I am wondering what will happen when the new virtual server come
s
up using a different name. sql server takes it name from the server name.
Will it just automatically adjust or is there a process to deal with that?
Thanks.If it's SQL Server 2005 and it has never run after installation, it will
"fix" itself upon first startup. Else, it's a simple process to
drop/register the new server name (just like in 2000). If you have other
objects in there name/server dependencies, well, that gets a little more
complicated.
joe.
"jason" <jason@.discussions.microsoft.com> wrote in message
news:68DB416E-E2B6-4E21-996C-2A99B37D6C01@.microsoft.com...
> Anyone have any experience with cloning servers that have sql server
> installed. I am wondering what will happen when the new virtual server
> comes
> up using a different name. sql server takes it name from the server name.
> Will it just automatically adjust or is there a process to deal with that?
> Thanks.
>|||Hello Jason,
If you rename a server with SQL 2000/2005 installed, you may want to use
sp_dropserver to drop old server name, and then run sp_addserver to add the
new server name.
303774 BUG: "Renaming A Server" Topic in SQL Server Books Online is
Incomplete
http://support.microsoft.com/defaul...kb;EN-US;303774
317241 Renaming a host computer for SQL Server causes stored procedure
debug to fail
http://support.microsoft.com/defaul...kb;EN-US;317241
281642 PRB: Error 14274 Occurs When You Update a SQL Agent Job After
Renaming Windows Server
http://support.microsoft.com/defaul...kb;EN-US;281642
Please let me know if you have any comments or questions. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
Cloned SQL 2005 Install
I need a little help with a cloned SQL 2005 install. We have a couple of Virtual Machines that SQL 2005 was installed on. The install was orginally completed on <pc1> and then duped over to <pc2>. The problem now is that <pc2> is showing information from <pc1> everywhere. I have reviewd this document: http://msdn2.microsoft.com/en-us/library/ms143799.aspx, and it doesn't seem to help any. I have used the sp_dropserver command with 'droplogins' to try to recreate the logins for <pc2> but it's still showing the logins from <pc1>. Can someone please help me out, I'm not sure what I'm doing wrong here. Thanks!
Am I looking at a re-install here?
The doc says there is no need to re-install, but those commands just aren't taking care of the problem. When I run @.@.servername it does show the correct server as node 0, but the logins are still there from <pc1>. I deleted the 3 logins that were referenced to the old PC, now I just can't get them re-created for <pc2>
|||What logins are you referring to?
Subscribe to:
Posts (Atom)