Renaming a SQL2005 - Unable to connect to RS from Management Studi

We have several 2005 boxes that have been renamed. RS works fine from a
browser and I can deplopy reports to it and see it with the config manager.
What I can't do is reference it from Management Studio. On the one box that
I restarted after sp_drop and sp_add, a message box pops up referring to the
old name. on the other box, niether the old name no the new name are found.
Where does the Studio get these names?For anyone who cares, I had to chnge the rsreportserver.config file. It was
referencing the old server names in the ulrroot section. This also impacted
the SAC tool's ability to manage the rs instance.
"Jeff Ericson" wrote:
> We have several 2005 boxes that have been renamed. RS works fine from a
> browser and I can deplopy reports to it and see it with the config manager.
> What I can't do is reference it from Management Studio. On the one box that
> I restarted after sp_drop and sp_add, a message box pops up referring to the
> old name. on the other box, niether the old name no the new name are found.
> Where does the Studio get these names?

Rename SQL 2005 Instance

Hi,

I have a SQL Server 2005 installation, running under the instance of MyServer\SQL2005. So I have 1 instance called 'SQL 2005'.

I would like to rename the instance back to the default instance. So afterwards, the server instance should just be called 'MyServer'. Does anyone know if this is possible without loosing any data?

Thank you

Jeremy

I don't think it's doable

I searched around when I tried to change my default instance install to named instance - can't do it

had to uninstall, and re-install again

as long as you don't delete your MDF/LDF files, you shouldn't lose much (backup first anyway)

|||

Thanks for your reply,

This is what I was fearing.....although it is strange that Microsoft specificly ship the AS instance rename tool. Yet there's no indication of how you can do this for the database engine.

If anyone does know of a method it would be appreciated,

Thanks

Jeremy

|||

Jeremy,

You can rename a default instance of the database engine just by renaming the computer. See the topic "How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005" in BOL. You cannot rename the instance part of a named instance.

Ron

|||http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/544c4eaf43ddfaf3/e9065e05718e984e

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
>

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.

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.

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.
:(