Should this be an issue?
My system was working fine before I renamed my system (host), but since
I have renamed it, my application is working from a remote system. From
the local system (the machine where the MSDE is running) the app is
working fine.
Any ideas?
- manzoor
With MSDE 2000, if you rename the host then the name of the SQL Server will
follow the name of the host. Make sure your remote client is connection to
the new name.
Jim
"Manzoorul Hassan" <manzoorul.hassan@.gmail.com> wrote in message
news:1105393521.649255.134690@.c13g2000cwb.googlegr oups.com...
> Should this be an issue?
> My system was working fine before I renamed my system (host), but since
> I have renamed it, my application is working from a remote system. From
> the local system (the machine where the MSDE is running) the app is
> working fine.
> Any ideas?
> - manzoor
>
|||Yeap, it's working fine now. Even though I am not doing anything
different. I had expected teh new name to be required and was trying to
use it initially. Maybe it has something to do with using DHCP, but I'm
not sure.
Anyway, I realy do appreciate your reposnse.
- manzoor
Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts
Friday, March 30, 2012
Renaming a sql server instance after you rename the server
I installed sql server on one of my test servers, and I am eventually going to rename this server and put it into production. This server will replace one of my old servers with the same name. I was wondering if there was a way to rename the SQL Server instance after you rename your server without having to reinstall SQL Server. Thanks in advance for all the help.Originally posted by svanati
I installed sql server on one of my test servers, and I am eventually going to rename this server and put it into production. This server will replace one of my old servers with the same name. I was wondering if there was a way to rename the SQL Server instance after you rename your server without having to reinstall SQL Server. Thanks in advance for all the help.
Done this many times. If you are using replication it gets more complex. I've done that as well but I will assume you aren't
Accommodate change in NetBIOS name:
sp_dropserver 'oldname', 'droplogins'
sp_addserver 'newname', local
use msdb
go
SELECT * FROM sysjobs -- Check which jobs have which server name...
update sysjobs set originating_server = 'newname' -- Assumes no jobs intentionally use a different server name
restart SQL Server
SELECT @.@.servername -- The result should match the systems NetBIOS name|||Thanks for the help.sql
I installed sql server on one of my test servers, and I am eventually going to rename this server and put it into production. This server will replace one of my old servers with the same name. I was wondering if there was a way to rename the SQL Server instance after you rename your server without having to reinstall SQL Server. Thanks in advance for all the help.
Done this many times. If you are using replication it gets more complex. I've done that as well but I will assume you aren't
Accommodate change in NetBIOS name:
sp_dropserver 'oldname', 'droplogins'
sp_addserver 'newname', local
use msdb
go
SELECT * FROM sysjobs -- Check which jobs have which server name...
update sysjobs set originating_server = 'newname' -- Assumes no jobs intentionally use a different server name
restart SQL Server
SELECT @.@.servername -- The result should match the systems NetBIOS name|||Thanks for the help.sql
Renaming a server with SQL 2000 installed
Does anyone know if there would be any issue with SQL if I rename my server?
What complications could this cause?
If you rename the server, SQL Server won't continue to work until you rename
the SQL Server .... which is done by re-installing SQL Server.
Robert
"Wade" wrote:
> Does anyone know if there would be any issue with SQL if I rename my server?
> What complications could this cause?
|||Reinstalling is not required. The things that might break
include replication, linked servers and master jobs. To
reset the relevant row in master..sysservers use:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
At this stage, select @.@.SERVERNAME and select
SERVERPROPERTY('ServerName') should give the same value.
HTH,
Paul Ibison (SQL Server MVP)
|||Thanks for you help!
"Paul Ibison" wrote:
> Reinstalling is not required. The things that might break
> include replication, linked servers and master jobs. To
> reset the relevant row in master..sysservers use:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> At this stage, select @.@.SERVERNAME and select
> SERVERPROPERTY('ServerName') should give the same value.
> HTH,
> Paul Ibison (SQL Server MVP)
>
What complications could this cause?
If you rename the server, SQL Server won't continue to work until you rename
the SQL Server .... which is done by re-installing SQL Server.
Robert
"Wade" wrote:
> Does anyone know if there would be any issue with SQL if I rename my server?
> What complications could this cause?
|||Reinstalling is not required. The things that might break
include replication, linked servers and master jobs. To
reset the relevant row in master..sysservers use:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
At this stage, select @.@.SERVERNAME and select
SERVERPROPERTY('ServerName') should give the same value.
HTH,
Paul Ibison (SQL Server MVP)
|||Thanks for you help!
"Paul Ibison" wrote:
> Reinstalling is not required. The things that might break
> include replication, linked servers and master jobs. To
> reset the relevant row in master..sysservers use:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> At this stage, select @.@.SERVERNAME and select
> SERVERPROPERTY('ServerName') should give the same value.
> HTH,
> Paul Ibison (SQL Server MVP)
>
Renaming a server with SQL 2000 installed
Does anyone know if there would be any issue with SQL if I rename my server?
What complications could this cause?If you rename the server, SQL Server won't continue to work until you rename
the SQL Server .... which is done by re-installing SQL Server.
Robert
"Wade" wrote:
> Does anyone know if there would be any issue with SQL if I rename my server?
> What complications could this cause?|||Reinstalling is not required. The things that might break
include replication, linked servers and master jobs. To
reset the relevant row in master..sysservers use:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
At this stage, select @.@.SERVERNAME and select
SERVERPROPERTY('ServerName') should give the same value.
HTH,
Paul Ibison (SQL Server MVP)|||Thanks for you help!
"Paul Ibison" wrote:
> Reinstalling is not required. The things that might break
> include replication, linked servers and master jobs. To
> reset the relevant row in master..sysservers use:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> At this stage, select @.@.SERVERNAME and select
> SERVERPROPERTY('ServerName') should give the same value.
> HTH,
> Paul Ibison (SQL Server MVP)
>
What complications could this cause?If you rename the server, SQL Server won't continue to work until you rename
the SQL Server .... which is done by re-installing SQL Server.
Robert
"Wade" wrote:
> Does anyone know if there would be any issue with SQL if I rename my server?
> What complications could this cause?|||Reinstalling is not required. The things that might break
include replication, linked servers and master jobs. To
reset the relevant row in master..sysservers use:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
At this stage, select @.@.SERVERNAME and select
SERVERPROPERTY('ServerName') should give the same value.
HTH,
Paul Ibison (SQL Server MVP)|||Thanks for you help!
"Paul Ibison" wrote:
> Reinstalling is not required. The things that might break
> include replication, linked servers and master jobs. To
> reset the relevant row in master..sysservers use:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> At this stage, select @.@.SERVERNAME and select
> SERVERPROPERTY('ServerName') should give the same value.
> HTH,
> Paul Ibison (SQL Server MVP)
>
Renaming a server after SQL is installed.
Hi All
I remember seeing a KB on the issue of renaming a server
name after SQL has been installed. It had something to do
with the fact that SQL binds itself to the server name. I
can't seem to find the article again. Any ideas or
thoughts?
Thanks
Jonolookup RENAMING SERVERS in BOL, you will have to do
sp_dropserver <old_name>
go
sp_addserver <new_name>
go
If you created any jobs under the old server name you will have to change
the originating server in sysjobs in the MSDB database, also, make sure your
service account has appropriate permissions to the new servername (like
ability to log on)HTH-- Ray Higdon MCSE, MCDBA, CCNA--"Jono"
<anonymous@.discussions.microsoft.com> wrote in message
news:2d06101c39438$59fc1d00$a601280a@.phx.gbl...
> Hi All
> I remember seeing a KB on the issue of renaming a server
> name after SQL has been installed. It had something to do
> with the fact that SQL binds itself to the server name. I
> can't seem to find the article again. Any ideas or
> thoughts?
> Thanks
> Jono|||Using
sp_dropserver <old_name>
go
sp_addserver <new_name>
go
doesn't seem to work for SQL7 and you have to run setup
again. The setup process will ask if you want to upgrade,
select yes and sql will assume the new name of the server.
Mark S
>--Original Message--
>lookup RENAMING SERVERS in BOL, you will have to do
>sp_dropserver <old_name>
>go
>sp_addserver <new_name>
>go
>If you created any jobs under the old server name you
will have to change
>the originating server in sysjobs in the MSDB database,
also, make sure your
>service account has appropriate permissions to the new
servername (like
>ability to log on)HTH-- Ray Higdon MCSE, MCDBA, CCNA--
"Jono"
><anonymous@.discussions.microsoft.com> wrote in message
>news:2d06101c39438$59fc1d00$a601280a@.phx.gbl...
>> Hi All
>> I remember seeing a KB on the issue of renaming a server
>> name after SQL has been installed. It had something to
do
>> with the fact that SQL binds itself to the server name.
I
>> can't seem to find the article again. Any ideas or
>> thoughts?
>> Thanks
>> Jono
>
>.
>
I remember seeing a KB on the issue of renaming a server
name after SQL has been installed. It had something to do
with the fact that SQL binds itself to the server name. I
can't seem to find the article again. Any ideas or
thoughts?
Thanks
Jonolookup RENAMING SERVERS in BOL, you will have to do
sp_dropserver <old_name>
go
sp_addserver <new_name>
go
If you created any jobs under the old server name you will have to change
the originating server in sysjobs in the MSDB database, also, make sure your
service account has appropriate permissions to the new servername (like
ability to log on)HTH-- Ray Higdon MCSE, MCDBA, CCNA--"Jono"
<anonymous@.discussions.microsoft.com> wrote in message
news:2d06101c39438$59fc1d00$a601280a@.phx.gbl...
> Hi All
> I remember seeing a KB on the issue of renaming a server
> name after SQL has been installed. It had something to do
> with the fact that SQL binds itself to the server name. I
> can't seem to find the article again. Any ideas or
> thoughts?
> Thanks
> Jono|||Using
sp_dropserver <old_name>
go
sp_addserver <new_name>
go
doesn't seem to work for SQL7 and you have to run setup
again. The setup process will ask if you want to upgrade,
select yes and sql will assume the new name of the server.
Mark S
>--Original Message--
>lookup RENAMING SERVERS in BOL, you will have to do
>sp_dropserver <old_name>
>go
>sp_addserver <new_name>
>go
>If you created any jobs under the old server name you
will have to change
>the originating server in sysjobs in the MSDB database,
also, make sure your
>service account has appropriate permissions to the new
servername (like
>ability to log on)HTH-- Ray Higdon MCSE, MCDBA, CCNA--
"Jono"
><anonymous@.discussions.microsoft.com> wrote in message
>news:2d06101c39438$59fc1d00$a601280a@.phx.gbl...
>> Hi All
>> I remember seeing a KB on the issue of renaming a server
>> name after SQL has been installed. It had something to
do
>> with the fact that SQL binds itself to the server name.
I
>> can't seem to find the article again. Any ideas or
>> thoughts?
>> Thanks
>> Jono
>
>.
>
Wednesday, March 28, 2012
Renaming a named instance of SQL Server 2005
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?Unfortunately, you'll have to do the de-install/reinstall thing.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150329868.510319.124590@.p79g2000cwp.googlegroups.com...
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?|||Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||I don't recall it being a possibility with 2000. However, it's been on my
wish list for a good long time. Don't get me started... ;-)
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||Nope, you gotta do one install per instance. Kinda makes sense, since each
instance could be a different version or different Service Pack level.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150336619.432501.214330@.h76g2000cwa.googlegroups.com...
OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||it's actually possible. (WARNING: do at your own perils!)
1. drop current instname (sp_dropserver)
2. add new instance name (sp_addserver 'new name','local')
3. stop sqlserver
4. modify hklm\software\microsoft\microsoft sql server\
5. modify hklm\system\mssql$<instance>
6. use "sc create" to add new mssql$<inst>
7. start up with new inst_name - voila!
-oj
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>I don't recall it being a possibility with 2000. However, it's been on my
> wish list for a good long time. Don't get me started... ;-)
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> <broy@.omegasoftwareinc.com> wrote in message
> news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
> Thanks Tom...
> Just FMI, wasn't this something that could be done in SQL Server 2000
> without uninstall/reinstall? Did the capability disappear with SQL
> Server 2005 or was it never there even in 2000?
>|||oops. #5 should be "modify
hklm\system\currentcontrolset\services\mssql$inst"
--
-oj
"oj" <nospam_ojngo@.home.com> wrote in message
news:elptQuCkGHA.1276@.TK2MSFTNGP03.phx.gbl...
> it's actually possible. (WARNING: do at your own perils!)
> 1. drop current instname (sp_dropserver)
> 2. add new instance name (sp_addserver 'new name','local')
> 3. stop sqlserver
> 4. modify hklm\software\microsoft\microsoft sql server\
> 5. modify hklm\system\mssql$<instance>
> 6. use "sc create" to add new mssql$<inst>
> 7. start up with new inst_name - voila!
>
> --
> -oj
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>>I don't recall it being a possibility with 2000. However, it's been on my
>> wish list for a good long time. Don't get me started... ;-)
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> <broy@.omegasoftwareinc.com> wrote in message
>> news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> Thanks Tom...
>> Just FMI, wasn't this something that could be done in SQL Server 2000
>> without uninstall/reinstall? Did the capability disappear with SQL
>> Server 2005 or was it never there even in 2000?
>|||The problem is that 'do at your own perils!' How does one know that all the
references to the old instance name have been changed everywhere?
Linchi
"oj" wrote:
> it's actually possible. (WARNING: do at your own perils!)
> 1. drop current instname (sp_dropserver)
> 2. add new instance name (sp_addserver 'new name','local')
> 3. stop sqlserver
> 4. modify hklm\software\microsoft\microsoft sql server\
> 5. modify hklm\system\mssql$<instance>
> 6. use "sc create" to add new mssql$<inst>
> 7. start up with new inst_name - voila!
>
> --
> -oj
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
> >I don't recall it being a possibility with 2000. However, it's been on my
> > wish list for a good long time. Don't get me started... ;-)
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Toronto, ON Canada
> > .
> > <broy@.omegasoftwareinc.com> wrote in message
> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
> > Thanks Tom...
> >
> > Just FMI, wasn't this something that could be done in SQL Server 2000
> > without uninstall/reinstall? Did the capability disappear with SQL
> > Server 2005 or was it never there even in 2000?
> >
>
>|||"do at your own perils" is just my blanket disclaimer when it comes to
system configuration. Actually, you can do all this very safely. Instead of
modifying the existing keys, you can create a new set. Modify this new set
with appropriate changes (I'll see about putting an article together
documenting it all). Register a new service for the new instance and then
start it.
Your original configuration/data is _never_ touched, so, if need to, you can
always start up the old instance.
--
-oj
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:97130750-F0A3-483C-8693-BAD70E02F5CF@.microsoft.com...
> The problem is that 'do at your own perils!' How does one know that all
> the
> references to the old instance name have been changed everywhere?
> Linchi
> "oj" wrote:
>> it's actually possible. (WARNING: do at your own perils!)
>> 1. drop current instname (sp_dropserver)
>> 2. add new instance name (sp_addserver 'new name','local')
>> 3. stop sqlserver
>> 4. modify hklm\software\microsoft\microsoft sql server\
>> 5. modify hklm\system\mssql$<instance>
>> 6. use "sc create" to add new mssql$<inst>
>> 7. start up with new inst_name - voila!
>>
>> --
>> -oj
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>> >I don't recall it being a possibility with 2000. However, it's been on
>> >my
>> > wish list for a good long time. Don't get me started... ;-)
>> >
>> > --
>> > Tom
>> >
>> > ----
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> > SQL Server MVP
>> > Toronto, ON Canada
>> > .
>> > <broy@.omegasoftwareinc.com> wrote in message
>> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> > Thanks Tom...
>> >
>> > Just FMI, wasn't this something that could be done in SQL Server 2000
>> > without uninstall/reinstall? Did the capability disappear with SQL
>> > Server 2005 or was it never there even in 2000?
>> >
>>|||Makes you wonder why MS doesn't have a tool to do this - without the risk or
disclaimer. I think many folks would sure love to have it.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"oj" <nospam_ojngo@.home.com> wrote in message
news:O%23dBhbKkGHA.3484@.TK2MSFTNGP03.phx.gbl...
"do at your own perils" is just my blanket disclaimer when it comes to
system configuration. Actually, you can do all this very safely. Instead of
modifying the existing keys, you can create a new set. Modify this new set
with appropriate changes (I'll see about putting an article together
documenting it all). Register a new service for the new instance and then
start it.
Your original configuration/data is _never_ touched, so, if need to, you can
always start up the old instance.
--
-oj
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:97130750-F0A3-483C-8693-BAD70E02F5CF@.microsoft.com...
> The problem is that 'do at your own perils!' How does one know that all
> the
> references to the old instance name have been changed everywhere?
> Linchi
> "oj" wrote:
>> it's actually possible. (WARNING: do at your own perils!)
>> 1. drop current instname (sp_dropserver)
>> 2. add new instance name (sp_addserver 'new name','local')
>> 3. stop sqlserver
>> 4. modify hklm\software\microsoft\microsoft sql server\
>> 5. modify hklm\system\mssql$<instance>
>> 6. use "sc create" to add new mssql$<inst>
>> 7. start up with new inst_name - voila!
>>
>> --
>> -oj
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>> >I don't recall it being a possibility with 2000. However, it's been on
>> >my
>> > wish list for a good long time. Don't get me started... ;-)
>> >
>> > --
>> > Tom
>> >
>> > ----
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> > SQL Server MVP
>> > Toronto, ON Canada
>> > .
>> > <broy@.omegasoftwareinc.com> wrote in message
>> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> > Thanks Tom...
>> >
>> > Just FMI, wasn't this something that could be done in SQL Server 2000
>> > without uninstall/reinstall? Did the capability disappear with SQL
>> > Server 2005 or was it never there even in 2000?
>> >
>>|||well, it's not that simple. ;-)
you can't easily change instance name if you have replication, loopback
linked server, etc. which depends on the old instance name. also, it would
be more support call for them because the new instance name does not
reference the normal instance path (i.e. physical location/pointer still
point to the old instance). this can be very confusing for _regular_ users.
uninstall/reinstall is the recommended route because it ensures everything
is right where it should be. of course this requires some work on the dba
(i.e. move data from old instance to new instance) but that's not of their
concern.
-oj
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OY4F5FNkGHA.456@.TK2MSFTNGP05.phx.gbl...
> Makes you wonder why MS doesn't have a tool to do this - without the risk
> or
> disclaimer. I think many folks would sure love to have it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:O%23dBhbKkGHA.3484@.TK2MSFTNGP03.phx.gbl...
> "do at your own perils" is just my blanket disclaimer when it comes to
> system configuration. Actually, you can do all this very safely. Instead
> of
> modifying the existing keys, you can create a new set. Modify this new set
> with appropriate changes (I'll see about putting an article together
> documenting it all). Register a new service for the new instance and then
> start it.
> Your original configuration/data is _never_ touched, so, if need to, you
> can
> always start up the old instance.
> --
> -oj
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:97130750-F0A3-483C-8693-BAD70E02F5CF@.microsoft.com...
>> The problem is that 'do at your own perils!' How does one know that all
>> the
>> references to the old instance name have been changed everywhere?
>> Linchi
>> "oj" wrote:
>> it's actually possible. (WARNING: do at your own perils!)
>> 1. drop current instname (sp_dropserver)
>> 2. add new instance name (sp_addserver 'new name','local')
>> 3. stop sqlserver
>> 4. modify hklm\software\microsoft\microsoft sql server\
>> 5. modify hklm\system\mssql$<instance>
>> 6. use "sc create" to add new mssql$<inst>
>> 7. start up with new inst_name - voila!
>>
>> --
>> -oj
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>> >I don't recall it being a possibility with 2000. However, it's been on
>> >my
>> > wish list for a good long time. Don't get me started... ;-)
>> >
>> > --
>> > Tom
>> >
>> > ----
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> > SQL Server MVP
>> > Toronto, ON Canada
>> > .
>> > <broy@.omegasoftwareinc.com> wrote in message
>> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> > Thanks Tom...
>> >
>> > Just FMI, wasn't this something that could be done in SQL Server 2000
>> > without uninstall/reinstall? Did the capability disappear with SQL
>> > Server 2005 or was it never there even in 2000?
>> >
>>
>
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?Unfortunately, you'll have to do the de-install/reinstall thing.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150329868.510319.124590@.p79g2000cwp.googlegroups.com...
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?|||Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||I don't recall it being a possibility with 2000. However, it's been on my
wish list for a good long time. Don't get me started... ;-)
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||Nope, you gotta do one install per instance. Kinda makes sense, since each
instance could be a different version or different Service Pack level.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150336619.432501.214330@.h76g2000cwa.googlegroups.com...
OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||it's actually possible. (WARNING: do at your own perils!)
1. drop current instname (sp_dropserver)
2. add new instance name (sp_addserver 'new name','local')
3. stop sqlserver
4. modify hklm\software\microsoft\microsoft sql server\
5. modify hklm\system\mssql$<instance>
6. use "sc create" to add new mssql$<inst>
7. start up with new inst_name - voila!
-oj
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>I don't recall it being a possibility with 2000. However, it's been on my
> wish list for a good long time. Don't get me started... ;-)
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> <broy@.omegasoftwareinc.com> wrote in message
> news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
> Thanks Tom...
> Just FMI, wasn't this something that could be done in SQL Server 2000
> without uninstall/reinstall? Did the capability disappear with SQL
> Server 2005 or was it never there even in 2000?
>|||oops. #5 should be "modify
hklm\system\currentcontrolset\services\mssql$inst"
--
-oj
"oj" <nospam_ojngo@.home.com> wrote in message
news:elptQuCkGHA.1276@.TK2MSFTNGP03.phx.gbl...
> it's actually possible. (WARNING: do at your own perils!)
> 1. drop current instname (sp_dropserver)
> 2. add new instance name (sp_addserver 'new name','local')
> 3. stop sqlserver
> 4. modify hklm\software\microsoft\microsoft sql server\
> 5. modify hklm\system\mssql$<instance>
> 6. use "sc create" to add new mssql$<inst>
> 7. start up with new inst_name - voila!
>
> --
> -oj
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>>I don't recall it being a possibility with 2000. However, it's been on my
>> wish list for a good long time. Don't get me started... ;-)
>> --
>> Tom
>> ----
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> SQL Server MVP
>> Toronto, ON Canada
>> .
>> <broy@.omegasoftwareinc.com> wrote in message
>> news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> Thanks Tom...
>> Just FMI, wasn't this something that could be done in SQL Server 2000
>> without uninstall/reinstall? Did the capability disappear with SQL
>> Server 2005 or was it never there even in 2000?
>|||The problem is that 'do at your own perils!' How does one know that all the
references to the old instance name have been changed everywhere?
Linchi
"oj" wrote:
> it's actually possible. (WARNING: do at your own perils!)
> 1. drop current instname (sp_dropserver)
> 2. add new instance name (sp_addserver 'new name','local')
> 3. stop sqlserver
> 4. modify hklm\software\microsoft\microsoft sql server\
> 5. modify hklm\system\mssql$<instance>
> 6. use "sc create" to add new mssql$<inst>
> 7. start up with new inst_name - voila!
>
> --
> -oj
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
> >I don't recall it being a possibility with 2000. However, it's been on my
> > wish list for a good long time. Don't get me started... ;-)
> >
> > --
> > Tom
> >
> > ----
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Toronto, ON Canada
> > .
> > <broy@.omegasoftwareinc.com> wrote in message
> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
> > Thanks Tom...
> >
> > Just FMI, wasn't this something that could be done in SQL Server 2000
> > without uninstall/reinstall? Did the capability disappear with SQL
> > Server 2005 or was it never there even in 2000?
> >
>
>|||"do at your own perils" is just my blanket disclaimer when it comes to
system configuration. Actually, you can do all this very safely. Instead of
modifying the existing keys, you can create a new set. Modify this new set
with appropriate changes (I'll see about putting an article together
documenting it all). Register a new service for the new instance and then
start it.
Your original configuration/data is _never_ touched, so, if need to, you can
always start up the old instance.
--
-oj
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:97130750-F0A3-483C-8693-BAD70E02F5CF@.microsoft.com...
> The problem is that 'do at your own perils!' How does one know that all
> the
> references to the old instance name have been changed everywhere?
> Linchi
> "oj" wrote:
>> it's actually possible. (WARNING: do at your own perils!)
>> 1. drop current instname (sp_dropserver)
>> 2. add new instance name (sp_addserver 'new name','local')
>> 3. stop sqlserver
>> 4. modify hklm\software\microsoft\microsoft sql server\
>> 5. modify hklm\system\mssql$<instance>
>> 6. use "sc create" to add new mssql$<inst>
>> 7. start up with new inst_name - voila!
>>
>> --
>> -oj
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>> >I don't recall it being a possibility with 2000. However, it's been on
>> >my
>> > wish list for a good long time. Don't get me started... ;-)
>> >
>> > --
>> > Tom
>> >
>> > ----
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> > SQL Server MVP
>> > Toronto, ON Canada
>> > .
>> > <broy@.omegasoftwareinc.com> wrote in message
>> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> > Thanks Tom...
>> >
>> > Just FMI, wasn't this something that could be done in SQL Server 2000
>> > without uninstall/reinstall? Did the capability disappear with SQL
>> > Server 2005 or was it never there even in 2000?
>> >
>>|||Makes you wonder why MS doesn't have a tool to do this - without the risk or
disclaimer. I think many folks would sure love to have it.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"oj" <nospam_ojngo@.home.com> wrote in message
news:O%23dBhbKkGHA.3484@.TK2MSFTNGP03.phx.gbl...
"do at your own perils" is just my blanket disclaimer when it comes to
system configuration. Actually, you can do all this very safely. Instead of
modifying the existing keys, you can create a new set. Modify this new set
with appropriate changes (I'll see about putting an article together
documenting it all). Register a new service for the new instance and then
start it.
Your original configuration/data is _never_ touched, so, if need to, you can
always start up the old instance.
--
-oj
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:97130750-F0A3-483C-8693-BAD70E02F5CF@.microsoft.com...
> The problem is that 'do at your own perils!' How does one know that all
> the
> references to the old instance name have been changed everywhere?
> Linchi
> "oj" wrote:
>> it's actually possible. (WARNING: do at your own perils!)
>> 1. drop current instname (sp_dropserver)
>> 2. add new instance name (sp_addserver 'new name','local')
>> 3. stop sqlserver
>> 4. modify hklm\software\microsoft\microsoft sql server\
>> 5. modify hklm\system\mssql$<instance>
>> 6. use "sc create" to add new mssql$<inst>
>> 7. start up with new inst_name - voila!
>>
>> --
>> -oj
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>> >I don't recall it being a possibility with 2000. However, it's been on
>> >my
>> > wish list for a good long time. Don't get me started... ;-)
>> >
>> > --
>> > Tom
>> >
>> > ----
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> > SQL Server MVP
>> > Toronto, ON Canada
>> > .
>> > <broy@.omegasoftwareinc.com> wrote in message
>> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> > Thanks Tom...
>> >
>> > Just FMI, wasn't this something that could be done in SQL Server 2000
>> > without uninstall/reinstall? Did the capability disappear with SQL
>> > Server 2005 or was it never there even in 2000?
>> >
>>|||well, it's not that simple. ;-)
you can't easily change instance name if you have replication, loopback
linked server, etc. which depends on the old instance name. also, it would
be more support call for them because the new instance name does not
reference the normal instance path (i.e. physical location/pointer still
point to the old instance). this can be very confusing for _regular_ users.
uninstall/reinstall is the recommended route because it ensures everything
is right where it should be. of course this requires some work on the dba
(i.e. move data from old instance to new instance) but that's not of their
concern.
-oj
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OY4F5FNkGHA.456@.TK2MSFTNGP05.phx.gbl...
> Makes you wonder why MS doesn't have a tool to do this - without the risk
> or
> disclaimer. I think many folks would sure love to have it.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "oj" <nospam_ojngo@.home.com> wrote in message
> news:O%23dBhbKkGHA.3484@.TK2MSFTNGP03.phx.gbl...
> "do at your own perils" is just my blanket disclaimer when it comes to
> system configuration. Actually, you can do all this very safely. Instead
> of
> modifying the existing keys, you can create a new set. Modify this new set
> with appropriate changes (I'll see about putting an article together
> documenting it all). Register a new service for the new instance and then
> start it.
> Your original configuration/data is _never_ touched, so, if need to, you
> can
> always start up the old instance.
> --
> -oj
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:97130750-F0A3-483C-8693-BAD70E02F5CF@.microsoft.com...
>> The problem is that 'do at your own perils!' How does one know that all
>> the
>> references to the old instance name have been changed everywhere?
>> Linchi
>> "oj" wrote:
>> it's actually possible. (WARNING: do at your own perils!)
>> 1. drop current instname (sp_dropserver)
>> 2. add new instance name (sp_addserver 'new name','local')
>> 3. stop sqlserver
>> 4. modify hklm\software\microsoft\microsoft sql server\
>> 5. modify hklm\system\mssql$<instance>
>> 6. use "sc create" to add new mssql$<inst>
>> 7. start up with new inst_name - voila!
>>
>> --
>> -oj
>>
>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
>> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>> >I don't recall it being a possibility with 2000. However, it's been on
>> >my
>> > wish list for a good long time. Don't get me started... ;-)
>> >
>> > --
>> > Tom
>> >
>> > ----
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>> > SQL Server MVP
>> > Toronto, ON Canada
>> > .
>> > <broy@.omegasoftwareinc.com> wrote in message
>> > news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
>> > Thanks Tom...
>> >
>> > Just FMI, wasn't this something that could be done in SQL Server 2000
>> > without uninstall/reinstall? Did the capability disappear with SQL
>> > Server 2005 or was it never there even in 2000?
>> >
>>
>
Renaming a named instance of SQL Server 2005
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?Unfortunately, you'll have to do the de-install/reinstall thing.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150329868.510319.124590@.p79g2000cwp.googlegroups.com...
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?|||Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||I don't recall it being a possibility with 2000. However, it's been on my
wish list for a good long time. Don't get me started... ;-)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||Nope, you gotta do one install per instance. Kinda makes sense, since each
instance could be a different version or different Service Pack level.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150336619.432501.214330@.h76g2000cwa.googlegroups.com...
OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||it's actually possible. (WARNING: do at your own perils!)
1. drop current instname (sp_dropserver)
2. add new instance name (sp_addserver 'new name','local')
3. stop sqlserver
4. modify hklm\software\microsoft\microsoft sql server\
5. modify hklm\system\mssql$<instance>
6. use "sc create" to add new mssql$<inst>
7. start up with new inst_name - voila!
-oj
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>I don't recall it being a possibility with 2000. However, it's been on my
> wish list for a good long time. Don't get me started... ;-)
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> <broy@.omegasoftwareinc.com> wrote in message
> news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
> Thanks Tom...
> Just FMI, wasn't this something that could be done in SQL Server 2000
> without uninstall/reinstall? Did the capability disappear with SQL
> Server 2005 or was it never there even in 2000?
>|||oops. #5 should be "modify
hklm\system\currentcontrolset\services\m
ssql$inst"
-oj
"oj" <nospam_ojngo@.home.com> wrote in message
news:elptQuCkGHA.1276@.TK2MSFTNGP03.phx.gbl...
> it's actually possible. (WARNING: do at your own perils!)
> 1. drop current instname (sp_dropserver)
> 2. add new instance name (sp_addserver 'new name','local')
> 3. stop sqlserver
> 4. modify hklm\software\microsoft\microsoft sql server\
> 5. modify hklm\system\mssql$<instance>
> 6. use "sc create" to add new mssql$<inst>
> 7. start up with new inst_name - voila!
>
> --
> -oj
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>|||Unfortunately, you'll have to do the de-install/reinstall thing.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150329868.510319.124590@.p79g2000cwp.googlegroups.com...
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?|||Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?Unfortunately, you'll have to do the de-install/reinstall thing.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150329868.510319.124590@.p79g2000cwp.googlegroups.com...
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?|||Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||I don't recall it being a possibility with 2000. However, it's been on my
wish list for a good long time. Don't get me started... ;-)
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?|||OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||Nope, you gotta do one install per instance. Kinda makes sense, since each
instance could be a different version or different Service Pack level.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150336619.432501.214330@.h76g2000cwa.googlegroups.com...
OK, OK, won't get you started (or did I already?!). Just another quick
question for you, though. What if want another named instance of SQL
Server 2005 on the machine. Do I need to go through another install to
do that or is there another way to "spawn" another named instance on
the machine without getting rid of the current one?|||it's actually possible. (WARNING: do at your own perils!)
1. drop current instname (sp_dropserver)
2. add new instance name (sp_addserver 'new name','local')
3. stop sqlserver
4. modify hklm\software\microsoft\microsoft sql server\
5. modify hklm\system\mssql$<instance>
6. use "sc create" to add new mssql$<inst>
7. start up with new inst_name - voila!
-oj
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>I don't recall it being a possibility with 2000. However, it's been on my
> wish list for a good long time. Don't get me started... ;-)
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> <broy@.omegasoftwareinc.com> wrote in message
> news:1150334059.199056.4380@.h76g2000cwa.googlegroups.com...
> Thanks Tom...
> Just FMI, wasn't this something that could be done in SQL Server 2000
> without uninstall/reinstall? Did the capability disappear with SQL
> Server 2005 or was it never there even in 2000?
>|||oops. #5 should be "modify
hklm\system\currentcontrolset\services\m
ssql$inst"
-oj
"oj" <nospam_ojngo@.home.com> wrote in message
news:elptQuCkGHA.1276@.TK2MSFTNGP03.phx.gbl...
> it's actually possible. (WARNING: do at your own perils!)
> 1. drop current instname (sp_dropserver)
> 2. add new instance name (sp_addserver 'new name','local')
> 3. stop sqlserver
> 4. modify hklm\software\microsoft\microsoft sql server\
> 5. modify hklm\system\mssql$<instance>
> 6. use "sc create" to add new mssql$<inst>
> 7. start up with new inst_name - voila!
>
> --
> -oj
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:%23eYqXqBkGHA.2200@.TK2MSFTNGP05.phx.gbl...
>|||Unfortunately, you'll have to do the de-install/reinstall thing.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<broy@.omegasoftwareinc.com> wrote in message
news:1150329868.510319.124590@.p79g2000cwp.googlegroups.com...
I installed a named instance of SQL Server 2005 on a machine...let's
say I called it VAIO4. I want to rename it to BTSERVER. I'd rather not
have to uninstall and reinstall, but will do that if I have to. Is
there a way to rename the named instance without uninstall/reinstall?|||Thanks Tom...
Just FMI, wasn't this something that could be done in SQL Server 2000
without uninstall/reinstall? Did the capability disappear with SQL
Server 2005 or was it never there even in 2000?
Renaming a diagram in SQL Server Management Studio
Hello, I have MS SQL 2005 installed on my server. When I tried to rename a
diagram, I received an error. Is it possible to rename a diagram, or I need
to create a new one and copy the contents? Does this problem exist only in my
installation, or does anyone else have the same problem? Thank you for
response. Here is the error message (renaming Diagram1 to Diagram2):
TITLE: Microsoft SQL Server Management Studio
Unable to rename Diagram2. (ObjectExplorer)
ADDITIONAL INFORMATION:
Could not find stored procedure 'dbo.sp_renamediagram'. (Microsoft SQL
Server, Error: 2812)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=2812&LinkId=20476[/url]
BUTTONS:
OK
On Mar 4, 4:31 pm, Paul J <P...@.discussions.microsoft.com> wrote:
> Hello, I have MS SQL 2005 installed on my server. When I tried to rename a
> diagram, I received an error. Is it possible to rename a diagram, or I need
> to create a new one and copy the contents? Does this problem exist only in my
> installation, or does anyone else have the same problem? Thank you for
> response. Here is the error message (renaming Diagram1 to Diagram2):
> TITLE: Microsoft SQL Server Management Studio
> --
> Unable to rename Diagram2. (ObjectExplorer)
> --
> ADDITIONAL INFORMATION:
> Could not find stored procedure 'dbo.sp_renamediagram'. (Microsoft SQL
> Server, Error: 2812)
> For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=...
> --
> BUTTONS:
> OK
> --
You should be able to rename a diagram.
When you created the first diagram in the database you should have
seen a message that database objects needed for diagrams would be
created and the following ojects should have been created:
sp_helpdiagramdefinition
sp_creatediagram
sp_renamediagram
sp_alterdiagram
sp_dropdiagram
fn_diagramobjects
sp_upgraddiagrams
sysdiagrams
PK__sysdiagrams__ID
UK_principal_name
sp_helpdiagrams
|||Paul J (PaulJ@.discussions.microsoft.com) writes:
> Hello, I have MS SQL 2005 installed on my server. When I tried to rename
> a diagram, I received an error. Is it possible to rename a diagram, or I
> need to create a new one and copy the contents? Does this problem exist
> only in my installation, or does anyone else have the same problem?
> Thank you for response. Here is the error message (renaming Diagram1 to
> Diagram2):
> TITLE: Microsoft SQL Server Management Studio
> --
> Unable to rename Diagram2. (ObjectExplorer)
>
To add to Steve's post, create some other database and add diagrams there.
Then do this from a query window:
sp_helptext sp_renamediagram
Copy and paste, and the run the script in the database you are having
problem with. This should work. (But I have not actually tested.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||"Erland Sommarskog" wrote:
> To add to Steve's post, create some other database and add diagrams there.
> Then do this from a query window:
> sp_helptext sp_renamediagram
> Copy and paste, and the run the script in the database you are having
> problem with. This should work. (But I have not actually tested.)
>
>
I already had the procedure there. But it doesn't work even after launching
the script... It works in new DB, so I will switch my objects data to the new
one. I still don't know what's wrong, but I believe it won't happen again :-)
If you still think you can help me with this issue, feel free to ask me for
all information you need. Resolving of this problem would save me much time.
Thank you
|||Paul J (PaulJ@.discussions.microsoft.com) writes:
> I already had the procedure there. But it doesn't work even after
> launching the script... It works in new DB, so I will switch my objects
> data to the new one. I still don't know what's wrong, but I believe it
> won't happen again :-) If you still think you can help me with this
> issue, feel free to ask me for all information you need. Resolving of
> this problem would save me much time.
What does
SELECT schema_id, schema_name(schema_id)
FROM sys.objects WHERE name = 'sp_renamediagram'
return?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||1 dbo
"Erland Sommarskog" wrote:
> Paul J (PaulJ@.discussions.microsoft.com) writes:
> What does
> SELECT schema_id, schema_name(schema_id)
> FROM sys.objects WHERE name = 'sp_renamediagram'
> return?
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
diagram, I received an error. Is it possible to rename a diagram, or I need
to create a new one and copy the contents? Does this problem exist only in my
installation, or does anyone else have the same problem? Thank you for
response. Here is the error message (renaming Diagram1 to Diagram2):
TITLE: Microsoft SQL Server Management Studio
Unable to rename Diagram2. (ObjectExplorer)
ADDITIONAL INFORMATION:
Could not find stored procedure 'dbo.sp_renamediagram'. (Microsoft SQL
Server, Error: 2812)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=2812&LinkId=20476[/url]
BUTTONS:
OK
On Mar 4, 4:31 pm, Paul J <P...@.discussions.microsoft.com> wrote:
> Hello, I have MS SQL 2005 installed on my server. When I tried to rename a
> diagram, I received an error. Is it possible to rename a diagram, or I need
> to create a new one and copy the contents? Does this problem exist only in my
> installation, or does anyone else have the same problem? Thank you for
> response. Here is the error message (renaming Diagram1 to Diagram2):
> TITLE: Microsoft SQL Server Management Studio
> --
> Unable to rename Diagram2. (ObjectExplorer)
> --
> ADDITIONAL INFORMATION:
> Could not find stored procedure 'dbo.sp_renamediagram'. (Microsoft SQL
> Server, Error: 2812)
> For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=...
> --
> BUTTONS:
> OK
> --
You should be able to rename a diagram.
When you created the first diagram in the database you should have
seen a message that database objects needed for diagrams would be
created and the following ojects should have been created:
sp_helpdiagramdefinition
sp_creatediagram
sp_renamediagram
sp_alterdiagram
sp_dropdiagram
fn_diagramobjects
sp_upgraddiagrams
sysdiagrams
PK__sysdiagrams__ID
UK_principal_name
sp_helpdiagrams
|||Paul J (PaulJ@.discussions.microsoft.com) writes:
> Hello, I have MS SQL 2005 installed on my server. When I tried to rename
> a diagram, I received an error. Is it possible to rename a diagram, or I
> need to create a new one and copy the contents? Does this problem exist
> only in my installation, or does anyone else have the same problem?
> Thank you for response. Here is the error message (renaming Diagram1 to
> Diagram2):
> TITLE: Microsoft SQL Server Management Studio
> --
> Unable to rename Diagram2. (ObjectExplorer)
>
To add to Steve's post, create some other database and add diagrams there.
Then do this from a query window:
sp_helptext sp_renamediagram
Copy and paste, and the run the script in the database you are having
problem with. This should work. (But I have not actually tested.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||"Erland Sommarskog" wrote:
> To add to Steve's post, create some other database and add diagrams there.
> Then do this from a query window:
> sp_helptext sp_renamediagram
> Copy and paste, and the run the script in the database you are having
> problem with. This should work. (But I have not actually tested.)
>
>
I already had the procedure there. But it doesn't work even after launching
the script... It works in new DB, so I will switch my objects data to the new
one. I still don't know what's wrong, but I believe it won't happen again :-)
If you still think you can help me with this issue, feel free to ask me for
all information you need. Resolving of this problem would save me much time.
Thank you
|||Paul J (PaulJ@.discussions.microsoft.com) writes:
> I already had the procedure there. But it doesn't work even after
> launching the script... It works in new DB, so I will switch my objects
> data to the new one. I still don't know what's wrong, but I believe it
> won't happen again :-) If you still think you can help me with this
> issue, feel free to ask me for all information you need. Resolving of
> this problem would save me much time.
What does
SELECT schema_id, schema_name(schema_id)
FROM sys.objects WHERE name = 'sp_renamediagram'
return?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||1 dbo
"Erland Sommarskog" wrote:
> Paul J (PaulJ@.discussions.microsoft.com) writes:
> What does
> SELECT schema_id, schema_name(schema_id)
> FROM sys.objects WHERE name = 'sp_renamediagram'
> return?
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
Rename virtual SQL Server in cluster
Can I rename my virtual cluster name that has SQL 2005 installed after I
build it for example if the virtual name is MASTER_New to MASTER?
thanks,
Yes, check the books online for details.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
<msnews.microsoft.com> wrote in message
news:%23qPaVW5VHHA.1120@.TK2MSFTNGP02.phx.gbl...
> Can I rename my virtual cluster name that has SQL 2005 installed after I
> build it for example if the virtual name is MASTER_New to MASTER?
> thanks,
>
|||You can rename the cluster network name resource, but not the instance name
(not without a lot of registry hacks).
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Sincerely,
Anthony Thomas
<msnews.microsoft.com> wrote in message
news:%23qPaVW5VHHA.1120@.TK2MSFTNGP02.phx.gbl...
> Can I rename my virtual cluster name that has SQL 2005 installed after I
> build it for example if the virtual name is MASTER_New to MASTER?
> thanks,
>
build it for example if the virtual name is MASTER_New to MASTER?
thanks,
Yes, check the books online for details.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
<msnews.microsoft.com> wrote in message
news:%23qPaVW5VHHA.1120@.TK2MSFTNGP02.phx.gbl...
> Can I rename my virtual cluster name that has SQL 2005 installed after I
> build it for example if the virtual name is MASTER_New to MASTER?
> thanks,
>
|||You can rename the cluster network name resource, but not the instance name
(not without a lot of registry hacks).
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
Sincerely,
Anthony Thomas
<msnews.microsoft.com> wrote in message
news:%23qPaVW5VHHA.1120@.TK2MSFTNGP02.phx.gbl...
> Can I rename my virtual cluster name that has SQL 2005 installed after I
> build it for example if the virtual name is MASTER_New to MASTER?
> thanks,
>
Monday, March 26, 2012
Rename Server
Help please. Not very up on SQL server. Hopefully this is
a simple one. If SQL server 2000 is installed on an W2k
member server can there be any complications re-naming the
server or will SQL have problems.
Regards
GraemeAfter NT renaming, do:
sp_dropserver <oldname>
sp_addserver <newname>, LOCAL
And I think that you have to redo replication, if you have such...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Graeme Lockhart" <graeme.lockhart@.scotland.gsi.gov.uk> wrote in message
news:0b8d01c366e5$2184ef90$a101280a@.phx.gbl...
> Help please. Not very up on SQL server. Hopefully this is
> a simple one. If SQL server 2000 is installed on an W2k
> member server can there be any complications re-naming the
> server or will SQL have problems.
> Regards
> Graeme|||To add to Tibor's post, if you have created any jobs under the old name you
will have to change the originating server in sysjobs to the new name.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Graeme Lockhart" <graeme.lockhart@.scotland.gsi.gov.uk> wrote in message
news:0b8d01c366e5$2184ef90$a101280a@.phx.gbl...
> Help please. Not very up on SQL server. Hopefully this is
> a simple one. If SQL server 2000 is installed on an W2k
> member server can there be any complications re-naming the
> server or will SQL have problems.
> Regards
> Graeme
a simple one. If SQL server 2000 is installed on an W2k
member server can there be any complications re-naming the
server or will SQL have problems.
Regards
GraemeAfter NT renaming, do:
sp_dropserver <oldname>
sp_addserver <newname>, LOCAL
And I think that you have to redo replication, if you have such...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Graeme Lockhart" <graeme.lockhart@.scotland.gsi.gov.uk> wrote in message
news:0b8d01c366e5$2184ef90$a101280a@.phx.gbl...
> Help please. Not very up on SQL server. Hopefully this is
> a simple one. If SQL server 2000 is installed on an W2k
> member server can there be any complications re-naming the
> server or will SQL have problems.
> Regards
> Graeme|||To add to Tibor's post, if you have created any jobs under the old name you
will have to change the originating server in sysjobs to the new name.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Graeme Lockhart" <graeme.lockhart@.scotland.gsi.gov.uk> wrote in message
news:0b8d01c366e5$2184ef90$a101280a@.phx.gbl...
> Help please. Not very up on SQL server. Hopefully this is
> a simple one. If SQL server 2000 is installed on an W2k
> member server can there be any complications re-naming the
> server or will SQL have problems.
> Regards
> Graeme
Friday, March 23, 2012
Rename existing SQL 2K to new name
Can an existing instance of SQL 2K be renamed from "Local Machine" to
"NewName"? There is only one SQL Server 2K installed on this machine. It can
be reinstalled if necessary since there is no databases added yet. Thank you
for any help you may be able to give me.
RGPHI,
No need of reinstalling, you can use the below stored procedures to rename
SQL server.
sp_dropserver <servername>
go
sp_addserver <newservername>,local
Thanks
Hari
MCDBA
"riley" <riley3@.microtek-sales.com> wrote in message
news:O4DxZbQwDHA.2340@.TK2MSFTNGP12.phx.gbl...
> Can an existing instance of SQL 2K be renamed from "Local Machine" to
> "NewName"? There is only one SQL Server 2K installed on this machine. It
can
> be reinstalled if necessary since there is no databases added yet. Thank
you
> for any help you may be able to give me.
> RGP
>|||Thank you very much for the response. It has been very helpful.
Riley
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OHpMYfRwDHA.1740@.TK2MSFTNGP12.phx.gbl...
> HI,
> No need of reinstalling, you can use the below stored procedures to rename
> SQL server.
> sp_dropserver <servername>
> go
> sp_addserver <newservername>,local
> Thanks
> Hari
> MCDBA
> "riley" <riley3@.microtek-sales.com> wrote in message
> news:O4DxZbQwDHA.2340@.TK2MSFTNGP12.phx.gbl...
> > Can an existing instance of SQL 2K be renamed from "Local Machine" to
> > "NewName"? There is only one SQL Server 2K installed on this machine. It
> can
> > be reinstalled if necessary since there is no databases added yet. Thank
> you
> > for any help you may be able to give me.
> > RGP
> >
> >
>
"NewName"? There is only one SQL Server 2K installed on this machine. It can
be reinstalled if necessary since there is no databases added yet. Thank you
for any help you may be able to give me.
RGPHI,
No need of reinstalling, you can use the below stored procedures to rename
SQL server.
sp_dropserver <servername>
go
sp_addserver <newservername>,local
Thanks
Hari
MCDBA
"riley" <riley3@.microtek-sales.com> wrote in message
news:O4DxZbQwDHA.2340@.TK2MSFTNGP12.phx.gbl...
> Can an existing instance of SQL 2K be renamed from "Local Machine" to
> "NewName"? There is only one SQL Server 2K installed on this machine. It
can
> be reinstalled if necessary since there is no databases added yet. Thank
you
> for any help you may be able to give me.
> RGP
>|||Thank you very much for the response. It has been very helpful.
Riley
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OHpMYfRwDHA.1740@.TK2MSFTNGP12.phx.gbl...
> HI,
> No need of reinstalling, you can use the below stored procedures to rename
> SQL server.
> sp_dropserver <servername>
> go
> sp_addserver <newservername>,local
> Thanks
> Hari
> MCDBA
> "riley" <riley3@.microtek-sales.com> wrote in message
> news:O4DxZbQwDHA.2340@.TK2MSFTNGP12.phx.gbl...
> > Can an existing instance of SQL 2K be renamed from "Local Machine" to
> > "NewName"? There is only one SQL Server 2K installed on this machine. It
> can
> > be reinstalled if necessary since there is no databases added yet. Thank
> you
> > for any help you may be able to give me.
> > RGP
> >
> >
>
Wednesday, March 21, 2012
Rename a SQL2005 Istance
I've installed a SQL2005 with named instance: SERVER\SQL2005
Because some software does'nt recognize this instance, i'd like to rename it
to default instance.
Is it possibile ?
How ?
Mauro
Mauro Miotello wrote:
> I've installed a SQL2005 with named instance: SERVER\SQL2005
> Because some software does'nt recognize this instance, i'd like to rename it
> to default instance.
> Is it possibile ?
> How ?
> Mauro
>
You'll have to uninstall the named instance and the run the install
again. In the new install you can install it as a default instance.
Regards
Steen
|||"Steen Persson (DK)" <spe@.REMOVEdatea.dk> ha scritto nel messaggio
news:eNXySxTSGHA.4440@.TK2MSFTNGP11.phx.gbl...
> You'll have to uninstall the named instance and the run the install again.
> In the new install you can install it as a default instance.
Because some software does'nt recognize this instance, i'd like to rename it
to default instance.
Is it possibile ?
How ?
Mauro
Mauro Miotello wrote:
> I've installed a SQL2005 with named instance: SERVER\SQL2005
> Because some software does'nt recognize this instance, i'd like to rename it
> to default instance.
> Is it possibile ?
> How ?
> Mauro
>
You'll have to uninstall the named instance and the run the install
again. In the new install you can install it as a default instance.
Regards
Steen
|||"Steen Persson (DK)" <spe@.REMOVEdatea.dk> ha scritto nel messaggio
news:eNXySxTSGHA.4440@.TK2MSFTNGP11.phx.gbl...
> You'll have to uninstall the named instance and the run the install again.
> In the new install you can install it as a default instance.
Rename a SQL2005 Istance
I've installed a SQL2005 with named instance: SERVER\SQL2005
Because some software does'nt recognize this instance, i'd like to rename it
to default instance.
Is it possibile ?
How ?
MauroMauro Miotello wrote:
> I've installed a SQL2005 with named instance: SERVER\SQL2005
> Because some software does'nt recognize this instance, i'd like to rename
it
> to default instance.
> Is it possibile ?
> How ?
> Mauro
>
You'll have to uninstall the named instance and the run the install
again. In the new install you can install it as a default instance.
Regards
Steen|||"Steen Persson (DK)" <spe@.REMOVEdatea.dk> ha scritto nel messaggio
news:eNXySxTSGHA.4440@.TK2MSFTNGP11.phx.gbl...
> You'll have to uninstall the named instance and the run the install again.
> In the new install you can install it as a default instance.
Because some software does'nt recognize this instance, i'd like to rename it
to default instance.
Is it possibile ?
How ?
MauroMauro Miotello wrote:
> I've installed a SQL2005 with named instance: SERVER\SQL2005
> Because some software does'nt recognize this instance, i'd like to rename
it
> to default instance.
> Is it possibile ?
> How ?
> Mauro
>
You'll have to uninstall the named instance and the run the install
again. In the new install you can install it as a default instance.
Regards
Steen|||"Steen Persson (DK)" <spe@.REMOVEdatea.dk> ha scritto nel messaggio
news:eNXySxTSGHA.4440@.TK2MSFTNGP11.phx.gbl...
> You'll have to uninstall the named instance and the run the install again.
> In the new install you can install it as a default instance.
Rename a SQL2005 Istance
I've installed a SQL2005 with named instance: SERVER\SQL2005
Because some software does'nt recognize this instance, i'd like to rename it
to default instance.
Is it possibile ?
How ?
MauroMauro Miotello wrote:
> I've installed a SQL2005 with named instance: SERVER\SQL2005
> Because some software does'nt recognize this instance, i'd like to rename it
> to default instance.
> Is it possibile ?
> How ?
> Mauro
>
You'll have to uninstall the named instance and the run the install
again. In the new install you can install it as a default instance.
Regards
Steen|||"Steen Persson (DK)" <spe@.REMOVEdatea.dk> ha scritto nel messaggio
news:eNXySxTSGHA.4440@.TK2MSFTNGP11.phx.gbl...
> You'll have to uninstall the named instance and the run the install again.
> In the new install you can install it as a default instance.
:(
Because some software does'nt recognize this instance, i'd like to rename it
to default instance.
Is it possibile ?
How ?
MauroMauro Miotello wrote:
> I've installed a SQL2005 with named instance: SERVER\SQL2005
> Because some software does'nt recognize this instance, i'd like to rename it
> to default instance.
> Is it possibile ?
> How ?
> Mauro
>
You'll have to uninstall the named instance and the run the install
again. In the new install you can install it as a default instance.
Regards
Steen|||"Steen Persson (DK)" <spe@.REMOVEdatea.dk> ha scritto nel messaggio
news:eNXySxTSGHA.4440@.TK2MSFTNGP11.phx.gbl...
> You'll have to uninstall the named instance and the run the install again.
> In the new install you can install it as a default instance.
:(
Rename a server
Hi I am running MSSQL2000 and recently installed the server software and
created a server. Just wondering if anyone knows how to change the server
name?
I did a google search and found that after the server is renamed one should
open Query analyzer and use sp_dropserver and sp_addserver
thanks.
Paul G
Software engineer.Paul wrote:
> Hi I am running MSSQL2000 and recently installed the server software
> and created a server. Just wondering if anyone knows how to change
> the server name?
> I did a google search and found that after the server is renamed one
> should open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
See "Renaming a Server" in BOL.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:2865418F-08B0-4BA2-BFCB-4295BD73115D@.microsoft.com...
> Hi I am running MSSQL2000 and recently installed the server software and
> created a server. Just wondering if anyone knows how to change the server
> name?
> I did a google search and found that after the server is renamed one should
> open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
created a server. Just wondering if anyone knows how to change the server
name?
I did a google search and found that after the server is renamed one should
open Query analyzer and use sp_dropserver and sp_addserver
thanks.
Paul G
Software engineer.Paul wrote:
> Hi I am running MSSQL2000 and recently installed the server software
> and created a server. Just wondering if anyone knows how to change
> the server name?
> I did a google search and found that after the server is renamed one
> should open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
See "Renaming a Server" in BOL.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:2865418F-08B0-4BA2-BFCB-4295BD73115D@.microsoft.com...
> Hi I am running MSSQL2000 and recently installed the server software and
> created a server. Just wondering if anyone knows how to change the server
> name?
> I did a google search and found that after the server is renamed one should
> open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
Rename a server
Hi I am running MSSQL2000 and recently installed the server software and
created a server. Just wondering if anyone knows how to change the server
name?
I did a google search and found that after the server is renamed one should
open Query analyzer and use sp_dropserver and sp_addserver
thanks.
Paul G
Software engineer.Paul wrote:
> Hi I am running MSSQL2000 and recently installed the server software
> and created a server. Just wondering if anyone knows how to change
> the server name?
> I did a google search and found that after the server is renamed one
> should open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
See "Renaming a Server" in BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:2865418F-08B0-4BA2-BFCB-4295BD73115D@.microsoft.com...
> Hi I am running MSSQL2000 and recently installed the server software and
> created a server. Just wondering if anyone knows how to change the server
> name?
> I did a google search and found that after the server is renamed one shoul
d
> open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
created a server. Just wondering if anyone knows how to change the server
name?
I did a google search and found that after the server is renamed one should
open Query analyzer and use sp_dropserver and sp_addserver
thanks.
Paul G
Software engineer.Paul wrote:
> Hi I am running MSSQL2000 and recently installed the server software
> and created a server. Just wondering if anyone knows how to change
> the server name?
> I did a google search and found that after the server is renamed one
> should open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
See "Renaming a Server" in BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:2865418F-08B0-4BA2-BFCB-4295BD73115D@.microsoft.com...
> Hi I am running MSSQL2000 and recently installed the server software and
> created a server. Just wondering if anyone knows how to change the server
> name?
> I did a google search and found that after the server is renamed one shoul
d
> open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
Rename a server
Hi I am running MSSQL2000 and recently installed the server software and
created a server. Just wondering if anyone knows how to change the server
name?
I did a google search and found that after the server is renamed one should
open Query analyzer and use sp_dropserver and sp_addserver
thanks.
Paul G
Software engineer.
Paul wrote:
> Hi I am running MSSQL2000 and recently installed the server software
> and created a server. Just wondering if anyone knows how to change
> the server name?
> I did a google search and found that after the server is renamed one
> should open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
See "Renaming a Server" in BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:2865418F-08B0-4BA2-BFCB-4295BD73115D@.microsoft.com...
> Hi I am running MSSQL2000 and recently installed the server software and
> created a server. Just wondering if anyone knows how to change the server
> name?
> I did a google search and found that after the server is renamed one should
> open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
created a server. Just wondering if anyone knows how to change the server
name?
I did a google search and found that after the server is renamed one should
open Query analyzer and use sp_dropserver and sp_addserver
thanks.
Paul G
Software engineer.
Paul wrote:
> Hi I am running MSSQL2000 and recently installed the server software
> and created a server. Just wondering if anyone knows how to change
> the server name?
> I did a google search and found that after the server is renamed one
> should open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
See "Renaming a Server" in BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||http://www.karaszi.com/SQLServer/inf...erver_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:2865418F-08B0-4BA2-BFCB-4295BD73115D@.microsoft.com...
> Hi I am running MSSQL2000 and recently installed the server software and
> created a server. Just wondering if anyone knows how to change the server
> name?
> I did a google search and found that after the server is renamed one should
> open Query analyzer and use sp_dropserver and sp_addserver
> thanks.
> Paul G
> Software engineer.
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)