HI GROUP
I have my production sql server computer name "sql2k"
and of course the default sql instant name as "sql2k"
because they're running on same box aand stand alone
server.
I do have another active\active sql cluster in place
node1 name is sql1 node 2 name sql2 and virtual computer
name sqlcluster. My default sql instance name
is "sqlserver1"
and it running on Node1 with failed over using Node 2
My sql second instance name is "sql/server2" and it
running on Node 2 with failed over using Node1.
I would like to rename my "sqlserver1" sql instance name to
my production sql name is "sql2k, my plan is to uninstall
the sql default instant on node 1 and reinstall sql with
the my sql production name after shutdown my prodution sql
server. my question is do I need to rename the computer
virtual server name too or just sql instance name?
Do any one have any idea what will cause any problem to
rename sql instance in cluster and of course the cluster
will have diff ip address with sql production server
only the name will be transfer to my default cluster on
node 1. Please give me any opinion if you have with this
Thanks a lot
You can't rename a SQL Server instance in a cluster. The only way to
accomplish this is to uninstall SQL Server and reinstall it. There aren't
any issues to doing this that I'm aware of. Just keep the name under 13
chanracters.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
|||Thanks
But I would like to transfer production sql name to the
default sql cluster name is it possible?
I know I can not have 2 sql name in the same network
but what if I shutdown my production and during the
reinstall sql on defaukt cluster Can I use my production
sql name for it? I still not clear if sql name using any
dns or wins like computer name on network if that the case
then where do I need to look for do a clean up of that name
before using it for my cluster?
Thanks a lot
>--Original Message--
>You can't rename a SQL Server instance in a cluster. The
only way to
>accomplish this is to uninstall SQL Server and reinstall
it. There aren't
>any issues to doing this that I'm aware of. Just keep
the name under 13
>chanracters.
>--
>Mike
>Principal Mentor
>Solid Quality Learning
>"More than just Training"
>SQL Server MVP
>http://www.solidqualitylearning.com
>http://www.mssqlserver.com
>
>.
>
|||Yes, you can reuse that name as long as the original server is offline. The
names that you use for the machine, cluster, and SQL Server are DNS
resolvable.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
Showing posts with label default. Show all posts
Showing posts with label default. Show all posts
Monday, March 26, 2012
Rename SqL 2005 default instance and netbios name
I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
2005 Cluster. We are wanting to do a side by side installation where
after everything has been tested we flip the switch in DNS and wins and
the apps and dsn's connect to the new server. The problem is that im
not sure if i will be able to change the netbios name and default
instance on virtual server. First off i would like input on if its
possible or not? Secondly if it is possible what are some of the
caveats? Thanks any input will most appreciatedHi
This talks about SQL 2005 but I think it may also be applicable to SQL 2000
as it is the virtual server that gets renamed and not the instance of SQL
Server.
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Before doing it for real you could run a test.
John
"Dxdunbar@.gmail.com" wrote:
> I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
> 2005 Cluster. We are wanting to do a side by side installation where
> after everything has been tested we flip the switch in DNS and wins and
> the apps and dsn's connect to the new server. The problem is that im
> not sure if i will be able to change the netbios name and default
> instance on virtual server. First off i would like input on if its
> possible or not? Secondly if it is possible what are some of the
> caveats? Thanks any input will most appreciated
>
2005 Cluster. We are wanting to do a side by side installation where
after everything has been tested we flip the switch in DNS and wins and
the apps and dsn's connect to the new server. The problem is that im
not sure if i will be able to change the netbios name and default
instance on virtual server. First off i would like input on if its
possible or not? Secondly if it is possible what are some of the
caveats? Thanks any input will most appreciatedHi
This talks about SQL 2005 but I think it may also be applicable to SQL 2000
as it is the virtual server that gets renamed and not the instance of SQL
Server.
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Before doing it for real you could run a test.
John
"Dxdunbar@.gmail.com" wrote:
> I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
> 2005 Cluster. We are wanting to do a side by side installation where
> after everything has been tested we flip the switch in DNS and wins and
> the apps and dsn's connect to the new server. The problem is that im
> not sure if i will be able to change the netbios name and default
> instance on virtual server. First off i would like input on if its
> possible or not? Secondly if it is possible what are some of the
> caveats? Thanks any input will most appreciated
>
Rename SqL 2005 default instance and netbios name
I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
2005 Cluster. We are wanting to do a side by side installation where
after everything has been tested we flip the switch in DNS and wins and
the apps and dsn's connect to the new server. The problem is that im
not sure if i will be able to change the netbios name and default
instance on virtual server. First off i would like input on if its
possible or not? Secondly if it is possible what are some of the
caveats? Thanks any input will most appreciatedHi
This talks about SQL 2005 but I think it may also be applicable to SQL 2000
as it is the virtual server that gets renamed and not the instance of SQL
Server.
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Before doing it for real you could run a test.
John
"Dxdunbar@.gmail.com" wrote:
> I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
> 2005 Cluster. We are wanting to do a side by side installation where
> after everything has been tested we flip the switch in DNS and wins and
> the apps and dsn's connect to the new server. The problem is that im
> not sure if i will be able to change the netbios name and default
> instance on virtual server. First off i would like input on if its
> possible or not? Secondly if it is possible what are some of the
> caveats? Thanks any input will most appreciated
>
2005 Cluster. We are wanting to do a side by side installation where
after everything has been tested we flip the switch in DNS and wins and
the apps and dsn's connect to the new server. The problem is that im
not sure if i will be able to change the netbios name and default
instance on virtual server. First off i would like input on if its
possible or not? Secondly if it is possible what are some of the
caveats? Thanks any input will most appreciatedHi
This talks about SQL 2005 but I think it may also be applicable to SQL 2000
as it is the virtual server that gets renamed and not the instance of SQL
Server.
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Before doing it for real you could run a test.
John
"Dxdunbar@.gmail.com" wrote:
> I am replacing an old NT 4.0 ,SqL 2000 server with a Server 2003 ,SQL
> 2005 Cluster. We are wanting to do a side by side installation where
> after everything has been tested we flip the switch in DNS and wins and
> the apps and dsn's connect to the new server. The problem is that im
> not sure if i will be able to change the netbios name and default
> instance on virtual server. First off i would like input on if its
> possible or not? Secondly if it is possible what are some of the
> caveats? Thanks any input will most appreciated
>
Rename named instance to default instance?
Is it possible to change a named instance of Sql Server 2005 to the default
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric Hall
No, I believe you would need to reinstall SQL Server for that type of
change.
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
sql
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric Hall
No, I believe you would need to reinstall SQL Server for that type of
change.
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
sql
Rename named instance to default instance?
Is it possible to change a named instance of Sql Server 2005 to the default
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric HallNo, I believe you would need to reinstall SQL Server for that type of
change.
--
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric HallNo, I believe you would need to reinstall SQL Server for that type of
change.
--
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
Rename named instance to default instance?
Is it possible to change a named instance of Sql Server 2005 to the default
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric HallNo, I believe you would need to reinstall SQL Server for that type of
change.
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the defaul
t
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
I've seen only mention default to default or named to named renaming. I do
not need to rename the physical server.
TIA,
Eric HallNo, I believe you would need to reinstall SQL Server for that type of
change.
Aaron Bertrand
SQL Server MVP
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric
No, you have to uninstall SQL Server and then install SQL Server 2005 as a
default instance
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||Eric,
Sorry, but it is not possible to change an instance (MyServer\SecondInstall)
to the default (MyServer). This is set at installation time and is embedded
all throughout the registry, etc. You have to install an unnamed instance
and move the databases to the new instance.
As an aside: If you just want to have some older client tools be able to
connect without using an instance name, you should check out this KB on
server aliases: http://support.microsoft.com/kb/265808/
RLF
"Eric Hall" <ransomhall@.nospam_gmail.com> wrote in message
news:3974C01A-FEAA-4682-B260-EE12030D4E3F@.microsoft.com...
> Is it possible to change a named instance of Sql Server 2005 to the
> default
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall|||That's what I figured. Thanks to all who replied and Russell for the KB
article pointer.
Eric
"Eric Hall" wrote:
> Is it possible to change a named instance of Sql Server 2005 to the defaul
t
> instance? I'm familiar with sp_dropserver/sp_addserver, but all examples
> I've seen only mention default to default or named to named renaming. I do
> not need to rename the physical server.
> TIA,
> Eric Hall
Friday, March 23, 2012
Rename Default Instance
Hi,
I finished the installation of the SQL 2000 Server with one default instance
on a new cluster. After that my boss asked for a new name to Default
Instance ! Ohh my God !
Can I change the name of Defaul Instance ?
thanks,
Rubens
I
Technically, you can. However, Microsoft won't support it. Consider using
a DNS alias.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
Hi,
I finished the installation of the SQL 2000 Server with one default instance
on a new cluster. After that my boss asked for a new name to Default
Instance ! Ohh my God !
Can I change the name of Defaul Instance ?
thanks,
Rubens
I
|||Please Read the following article
http://support.microsoft.com/default...b;en-us;307336
Regards
"Tom Moreau" wrote:
> Technically, you can. However, Microsoft won't support it. Consider using
> a DNS alias.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
> news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
> Hi,
> I finished the installation of the SQL 2000 Server with one default instance
> on a new cluster. After that my boss asked for a new name to Default
> Instance ! Ohh my God !
> Can I change the name of Defaul Instance ?
> thanks,
> Rubens
> I
>
>
|||Just like I said. From the KB article:
"However, renaming the SQL Server virtual, or clustered, servers is not
supported in the current version of Microsoft SQL Server. If you rename the
SQL Server Network Name resource, a variety of problems may occur. One of
the problems that may occur is that the SQL Server virtual server instance
may no longer come online. When this problem occurs, the following
information may be logged in the application event log: "
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:02537079-F255-49E1-9F19-B8CEA3C8C726@.microsoft.com...
Please Read the following article
http://support.microsoft.com/default...b;en-us;307336
Regards
"Tom Moreau" wrote:
> Technically, you can. However, Microsoft won't support it. Consider
> using
> a DNS alias.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
> news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
> Hi,
> I finished the installation of the SQL 2000 Server with one default
> instance
> on a new cluster. After that my boss asked for a new name to Default
> Instance ! Ohh my God !
> Can I change the name of Defaul Instance ?
> thanks,
> Rubens
> I
>
>
|||As pointed out by Tom, renaming a SQL Server clustered virtual servername is not supported. Since this is a new installation, I would uninstall and reinstall with a new virtual servername.
Additional Information:
======================
INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?kbid=254321
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
I finished the installation of the SQL 2000 Server with one default instance
on a new cluster. After that my boss asked for a new name to Default
Instance ! Ohh my God !
Can I change the name of Defaul Instance ?
thanks,
Rubens
I
Technically, you can. However, Microsoft won't support it. Consider using
a DNS alias.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
Hi,
I finished the installation of the SQL 2000 Server with one default instance
on a new cluster. After that my boss asked for a new name to Default
Instance ! Ohh my God !
Can I change the name of Defaul Instance ?
thanks,
Rubens
I
|||Please Read the following article
http://support.microsoft.com/default...b;en-us;307336
Regards
"Tom Moreau" wrote:
> Technically, you can. However, Microsoft won't support it. Consider using
> a DNS alias.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
> news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
> Hi,
> I finished the installation of the SQL 2000 Server with one default instance
> on a new cluster. After that my boss asked for a new name to Default
> Instance ! Ohh my God !
> Can I change the name of Defaul Instance ?
> thanks,
> Rubens
> I
>
>
|||Just like I said. From the KB article:
"However, renaming the SQL Server virtual, or clustered, servers is not
supported in the current version of Microsoft SQL Server. If you rename the
SQL Server Network Name resource, a variety of problems may occur. One of
the problems that may occur is that the SQL Server virtual server instance
may no longer come online. When this problem occurs, the following
information may be logged in the application event log: "
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:02537079-F255-49E1-9F19-B8CEA3C8C726@.microsoft.com...
Please Read the following article
http://support.microsoft.com/default...b;en-us;307336
Regards
"Tom Moreau" wrote:
> Technically, you can. However, Microsoft won't support it. Consider
> using
> a DNS alias.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> ..
> "Rubens Luque Sanches Jr." <rubensluque@.yahoo.com.br> wrote in message
> news:egzFFanLFHA.3988@.tk2msftngp13.phx.gbl...
> Hi,
> I finished the installation of the SQL 2000 Server with one default
> instance
> on a new cluster. After that my boss asked for a new name to Default
> Instance ! Ohh my God !
> Can I change the name of Defaul Instance ?
> thanks,
> Rubens
> I
>
>
|||As pointed out by Tom, renaming a SQL Server clustered virtual servername is not supported. Since this is a new installation, I would uninstall and reinstall with a new virtual servername.
Additional Information:
======================
INF: Clustered SQL Server Do's, Don'ts, and Basic Warnings
http://support.microsoft.com/?kbid=254321
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
Wednesday, March 21, 2012
rename a file without xp_cmdshell
Hi:
By default xp_cmdshell is disabled on new Installation of SQL Server 2005. I want to know how do I rename a file without using xp_cmdshell option?. What are my options programmatically to rename a file without using xp_cmdshell from T-SQL. One option is to create a Active x VB Script that uses the file system object to rename a file in a DTS package and then run the package.
Any ideas would be higly appreciated.
Thanks
Meher
you may use a CLR functions to achive such a requirementTuesday, March 20, 2012
Rename a Computer that is running MS SQL Server 2005
Hi everyone,
Here's what we want to achieve:
We have a production computer hosting a default instance of MS SQL
Server 2005 (Let's use the name DBSVRA)
We have another computer that is currently has a default instance of
MS SQL Server 2005 (DBSVRB)
Because DBSVRB is much faster, efficient, etc..., we want to move all
the databases from DBSVRA to DBSVRB
Now, we don't want to adjust our connection strings from our
applications, we want to simply
rename DBSVRB to DBSVRA.
I checked the following article:
http://msdn2.microsoft.com/en-us/library/ms143799.aspx and all the
criterias under "Before you begin" section is met.
a) We don't have a failover cluster --> can happen in the future
b) We don't have replication set-up --> can happen in the future
c) We are not using reporting services --> can happen in the future
d) No data mirroring --> can happen in the future
Anyway, after all of this, I just find that this might have adverse
effects by simply renaming a computer. For one, we have just tested
this scenario and while the rename of the server was successful and I
was able to log to MGMT Studio using the new name successfully.
However, I have noticed that under Security->Logins, the
<INSTANCENAME>\SQLServer2005MSFTEUser$<INTSANCENAME>
$MSSQLSERVER,<INSTANCENAME>\SQLServer2005MSSQLUser$<INSTANCENAME>
$MSSQLSERVER, <INSTANCENAME>\SQLServer2005SQLAgentUser$<INSTANCENAME>
$MSSQLSERVER
still have the <INSTANCENAME> of the old server name. Is this an
issue?
I don't know...while it's doable, I just don't feel comfortable about
this. What are your thoughts?Did you get any responses to this? I have the same concerns!!!
"audrey.nsh@.gmail.com" wrote:
> Hi everyone,
> Here's what we want to achieve:
> We have a production computer hosting a default instance of MS SQL
> Server 2005 (Let's use the name DBSVRA)
> We have another computer that is currently has a default instance of
> MS SQL Server 2005 (DBSVRB)
> Because DBSVRB is much faster, efficient, etc..., we want to move all
> the databases from DBSVRA to DBSVRB
> Now, we don't want to adjust our connection strings from our
> applications, we want to simply
> rename DBSVRB to DBSVRA.
> I checked the following article:
> http://msdn2.microsoft.com/en-us/library/ms143799.aspx and all the
> criterias under "Before you begin" section is met.
> a) We don't have a failover cluster --> can happen in the future
> b) We don't have replication set-up --> can happen in the future
> c) We are not using reporting services --> can happen in the future
> d) No data mirroring --> can happen in the future
>
> Anyway, after all of this, I just find that this might have adverse
> effects by simply renaming a computer. For one, we have just tested
> this scenario and while the rename of the server was successful and I
> was able to log to MGMT Studio using the new name successfully.
> However, I have noticed that under Security->Logins, the
> <INSTANCENAME>\SQLServer2005MSFTEUser$<INTSANCENAME>
> $MSSQLSERVER,<INSTANCENAME>\SQLServer2005MSSQLUser$<INSTANCENAME>
> $MSSQLSERVER, <INSTANCENAME>\SQLServer2005SQLAgentUser$<INSTANCENAME>
> $MSSQLSERVER
> still have the <INSTANCENAME> of the old server name. Is this an
> issue?
> I don't know...while it's doable, I just don't feel comfortable about
> this. What are your thoughts?
>
>
Here's what we want to achieve:
We have a production computer hosting a default instance of MS SQL
Server 2005 (Let's use the name DBSVRA)
We have another computer that is currently has a default instance of
MS SQL Server 2005 (DBSVRB)
Because DBSVRB is much faster, efficient, etc..., we want to move all
the databases from DBSVRA to DBSVRB
Now, we don't want to adjust our connection strings from our
applications, we want to simply
rename DBSVRB to DBSVRA.
I checked the following article:
http://msdn2.microsoft.com/en-us/library/ms143799.aspx and all the
criterias under "Before you begin" section is met.
a) We don't have a failover cluster --> can happen in the future
b) We don't have replication set-up --> can happen in the future
c) We are not using reporting services --> can happen in the future
d) No data mirroring --> can happen in the future
Anyway, after all of this, I just find that this might have adverse
effects by simply renaming a computer. For one, we have just tested
this scenario and while the rename of the server was successful and I
was able to log to MGMT Studio using the new name successfully.
However, I have noticed that under Security->Logins, the
<INSTANCENAME>\SQLServer2005MSFTEUser$<INTSANCENAME>
$MSSQLSERVER,<INSTANCENAME>\SQLServer2005MSSQLUser$<INSTANCENAME>
$MSSQLSERVER, <INSTANCENAME>\SQLServer2005SQLAgentUser$<INSTANCENAME>
$MSSQLSERVER
still have the <INSTANCENAME> of the old server name. Is this an
issue?
I don't know...while it's doable, I just don't feel comfortable about
this. What are your thoughts?Did you get any responses to this? I have the same concerns!!!
"audrey.nsh@.gmail.com" wrote:
> Hi everyone,
> Here's what we want to achieve:
> We have a production computer hosting a default instance of MS SQL
> Server 2005 (Let's use the name DBSVRA)
> We have another computer that is currently has a default instance of
> MS SQL Server 2005 (DBSVRB)
> Because DBSVRB is much faster, efficient, etc..., we want to move all
> the databases from DBSVRA to DBSVRB
> Now, we don't want to adjust our connection strings from our
> applications, we want to simply
> rename DBSVRB to DBSVRA.
> I checked the following article:
> http://msdn2.microsoft.com/en-us/library/ms143799.aspx and all the
> criterias under "Before you begin" section is met.
> a) We don't have a failover cluster --> can happen in the future
> b) We don't have replication set-up --> can happen in the future
> c) We are not using reporting services --> can happen in the future
> d) No data mirroring --> can happen in the future
>
> Anyway, after all of this, I just find that this might have adverse
> effects by simply renaming a computer. For one, we have just tested
> this scenario and while the rename of the server was successful and I
> was able to log to MGMT Studio using the new name successfully.
> However, I have noticed that under Security->Logins, the
> <INSTANCENAME>\SQLServer2005MSFTEUser$<INTSANCENAME>
> $MSSQLSERVER,<INSTANCENAME>\SQLServer2005MSSQLUser$<INSTANCENAME>
> $MSSQLSERVER, <INSTANCENAME>\SQLServer2005SQLAgentUser$<INSTANCENAME>
> $MSSQLSERVER
> still have the <INSTANCENAME> of the old server name. Is this an
> issue?
> I don't know...while it's doable, I just don't feel comfortable about
> this. What are your thoughts?
>
>
Removing White Space
I have created a report with a drill down button for each unique record. However, when the nodes are not expanded (the default), the report displays with large amounts of white space (varying according to how much space is required once the node is fully expanded). Is there any way to remove this whitespace? Thanks in advance.
I've seen this before where I explicitly set the group header for the inner group to be invisible, but i accidentally left the footer visible. Got the exact same symptom.
Hope that's useful.
|||I tried this but unfortunately it didn't work - all my group headings are set to invisible... (when i initially load the report, I only view the resource names, no other information - indicating that they are set to invisible)
|||You need to make sure you are hiding the groups, not the individual rows inside the group. Edit the group properties and set the visibility there.Removing the default value of RS Parameter (Value:"<Select a Value>")
I want to remove the default value of RS Parameter (Value:"<Select a Value>") but don't know how. Is anyone here can help me out?
HI
You can do this by giving the parameter, your own default
value, or you van go to the report properties Parameters
in the report manager and remove the default value by
de-selecting the checkbox.
Not sure what you wanted but this is how I
understood the question.
G
Friday, March 9, 2012
Removing installed instances from SQL Server Express
I installed SQL Server Express trail for 3 times each with new instance. Now I came to know that I need to have a default instance. I un-installed the SQL Server Express and tried to install it again. It still says I have installed instances and if I select default instance the option buttons are un-checked and disabled. I tried to delete all the folders related to the SQL Server installationa dn tried but still I see the same thing. Please help me in istalling the default instance.
Thank you.
SQL Server EXPRESS always installs with a "named" instances called SQLEXPRESS.Jens K. Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)