Rename virtual server

Hi,
Is this possible to rename the virtual server in a cluster environnement
? I use SQL2000 with win2003 server.No. There is no supported way to rename a virtual instance in SQL 2000.
The closest way is to detach the user databases, uninstall SQL, reinstall
SQL, and reattach the user databases. You still have to fix login and
maintenance information manually.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:9E540053-4D88-45EF-9454-41A6A888FD42@.microsoft.com...
> Hi,
> Is this possible to rename the virtual server in a cluster
> environnement
> ? I use SQL2000 with win2003 server.

Rename virtual server

Hi,
Is this possible to rename the virtual server in a cluster environnement
? I use SQL2000 with win2003 server.
No. There is no supported way to rename a virtual instance in SQL 2000.
The closest way is to detach the user databases, uninstall SQL, reinstall
SQL, and reattach the user databases. You still have to fix login and
maintenance information manually.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:9E540053-4D88-45EF-9454-41A6A888FD42@.microsoft.com...
> Hi,
> Is this possible to rename the virtual server in a cluster
> environnement
> ? I use SQL2000 with win2003 server.

Rename virtual server

Hi,
Is this possible to rename the virtual server in a cluster environnement
? I use SQL2000 with win2003 server.No. There is no supported way to rename a virtual instance in SQL 2000.
The closest way is to detach the user databases, uninstall SQL, reinstall
SQL, and reattach the user databases. You still have to fix login and
maintenance information manually.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"TheOne" <TheOne@.discussions.microsoft.com> wrote in message
news:9E540053-4D88-45EF-9454-41A6A888FD42@.microsoft.com...
> Hi,
> Is this possible to rename the virtual server in a cluster
> environnement
> ? I use SQL2000 with win2003 server.sql

Rename of Server Name getting problem

I use win200 and SQL2000.
At the first time, I set the server name as "ABC" and then install SQL2000.
Then I rename the server name as "DEF"
Then I type "select @.@.servername" and find that the server name is still in
"ABC" so I get trouble in replication.
I have tried to drop "ABC" and then add "DEF" again but it prompts that
"DEF" exists in database. If I type "Select @.@.servername" again. It shows
"NULL"
How to solve it? thx.sp_dropserver oldname
sp_addserver newname, LOCAL
Also, you need to handle the originating_server column in msdb..sysjobs.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"12345" <tommychu@.landsearch.com.hk> wrote in message news:uWC0aGrdDHA.1620@.TK2MSFTNGP12.phx.gbl...
> I use win200 and SQL2000.
> At the first time, I set the server name as "ABC" and then install SQL2000.
> Then I rename the server name as "DEF"
> Then I type "select @.@.servername" and find that the server name is still in
> "ABC" so I get trouble in replication.
> I have tried to drop "ABC" and then add "DEF" again but it prompts that
> "DEF" exists in database. If I type "Select @.@.servername" again. It shows
> "NULL"
> How to solve it? thx.
>|||Look at sp_addserver and sp_dropserver in BOL
"12345" <tommychu@.landsearch.com.hk> wrote in message
news:uWC0aGrdDHA.1620@.TK2MSFTNGP12.phx.gbl...
> I use win200 and SQL2000.
> At the first time, I set the server name as "ABC" and then install
SQL2000.
> Then I rename the server name as "DEF"
> Then I type "select @.@.servername" and find that the server name is still
in
> "ABC" so I get trouble in replication.
> I have tried to drop "ABC" and then add "DEF" again but it prompts that
> "DEF" exists in database. If I type "Select @.@.servername" again. It shows
> "NULL"
> How to solve it? thx.
>|||Try this
Exec sp_dropserver 'Old Name'
Exec sp_addserver 'New Name','local'
Reboot
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"12345" <tommychu@.landsearch.com.hk> wrote in message
news:uWC0aGrdDHA.1620@.TK2MSFTNGP12.phx.gbl...
> I use win200 and SQL2000.
> At the first time, I set the server name as "ABC" and then install
SQL2000.
> Then I rename the server name as "DEF"
> Then I type "select @.@.servername" and find that the server name is still
in
> "ABC" so I get trouble in replication.
> I have tried to drop "ABC" and then add "DEF" again but it prompts that
> "DEF" exists in database. If I type "Select @.@.servername" again. It shows
> "NULL"
> How to solve it? thx.
>|||I have tried to run "sp_addserver newname, local" but it prompts it is
existing currently.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
¼¶¼g©ó¶l¥ó·s»D:OFuuIIrdDHA.1876@.TK2MSFTNGP12.phx.gbl...
> sp_dropserver oldname
> sp_addserver newname, LOCAL
> Also, you need to handle the originating_server column in msdb..sysjobs.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "12345" <tommychu@.landsearch.com.hk> wrote in message
news:uWC0aGrdDHA.1620@.TK2MSFTNGP12.phx.gbl...
> > I use win200 and SQL2000.
> > At the first time, I set the server name as "ABC" and then install
SQL2000.
> > Then I rename the server name as "DEF"
> > Then I type "select @.@.servername" and find that the server name is still
in
> > "ABC" so I get trouble in replication.
> > I have tried to drop "ABC" and then add "DEF" again but it prompts that
> > "DEF" exists in database. If I type "Select @.@.servername" again. It
shows
> > "NULL"
> >
> > How to solve it? thx.
> >
> >
>|||the you probably added it without the LOCAL parameter by mistake (so SQL Server thinks it is a
remote server). If so, you need to use sp_dropserver first.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"12345" <tommychu@.landsearch.com.hk> wrote in message
news:%23$J5QcrdDHA.2516@.TK2MSFTNGP10.phx.gbl...
> I have tried to run "sp_addserver newname, local" but it prompts it is
> existing currently.
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> ¼¶¼g©ó¶l¥ó·s»D:OFuuIIrdDHA.1876@.TK2MSFTNGP12.phx.gbl...
> > sp_dropserver oldname
> > sp_addserver newname, LOCAL
> >
> > Also, you need to handle the originating_server column in msdb..sysjobs.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "12345" <tommychu@.landsearch.com.hk> wrote in message
> news:uWC0aGrdDHA.1620@.TK2MSFTNGP12.phx.gbl...
> > > I use win200 and SQL2000.
> > > At the first time, I set the server name as "ABC" and then install
> SQL2000.
> > > Then I rename the server name as "DEF"
> > > Then I type "select @.@.servername" and find that the server name is still
> in
> > > "ABC" so I get trouble in replication.
> > > I have tried to drop "ABC" and then add "DEF" again but it prompts that
> > > "DEF" exists in database. If I type "Select @.@.servername" again. It
> shows
> > > "NULL"
> > >
> > > How to solve it? thx.
> > >
> > >
> >
> >
>|||Just see the error message. You now have to remove the remote logins for that remote server before
you can drop that remote server.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"12345" <tommychu@.landsearch.com.hk> wrote in message news:O5spJordDHA.2640@.TK2MSFTNGP09.phx.gbl...
> I can sure that "LOCAL" parameter is typed. e.g. exec sp_addserver
> 'serverABC', local
> It prompts following error.
> Error Message :
> Server: Msg 15190, Level 16, State 1, Procedure sp_dropserver, Line 44
> There are still remote logins for the server 'server231'.
>
>
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> ¼¶¼g©ó¶l¥ó·s»D:OchG2hrdDHA.2560@.TK2MSFTNGP10.phx.gbl...
> > the you probably added it without the LOCAL parameter by mistake (so SQL
> Server thinks it is a
> > remote server). If so, you need to use sp_dropserver first.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "12345" <tommychu@.landsearch.com.hk> wrote in message
> > news:%23$J5QcrdDHA.2516@.TK2MSFTNGP10.phx.gbl...
> > > I have tried to run "sp_addserver newname, local" but it prompts it is
> > > existing currently.
> > >
> > >
> > > "Tibor Karaszi"
> <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> > > ¼¶¼g©ó¶l¥ó·s»D:OFuuIIrdDHA.1876@.TK2MSFTNGP12.phx.gbl...
> > > > sp_dropserver oldname
> > > > sp_addserver newname, LOCAL
> > > >
> > > > Also, you need to handle the originating_server column in
> msdb..sysjobs.
> > > >
> > > > --
> > > > Tibor Karaszi, SQL Server MVP
> > > > Archive at: http://groups.google.com/groups?oi=djq&as
> > > ugroup=microsoft.public.sqlserver
> > > >
> > > >
> > > > "12345" <tommychu@.landsearch.com.hk> wrote in message
> > > news:uWC0aGrdDHA.1620@.TK2MSFTNGP12.phx.gbl...
> > > > > I use win200 and SQL2000.
> > > > > At the first time, I set the server name as "ABC" and then install
> > > SQL2000.
> > > > > Then I rename the server name as "DEF"
> > > > > Then I type "select @.@.servername" and find that the server name is
> still
> > > in
> > > > > "ABC" so I get trouble in replication.
> > > > > I have tried to drop "ABC" and then add "DEF" again but it prompts
> that
> > > > > "DEF" exists in database. If I type "Select @.@.servername" again. It
> > > shows
> > > > > "NULL"
> > > > >
> > > > > How to solve it? thx.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Rename A Server

We want to migrate a SQL 7 to SQL2000 (there will be a new box) and then rename the old SQL 7 box and keep it on the network.
Seems like I remember there is a problem when your rename a SQL server.
Anyone have experience with this?
Thanks
ChuckCheck this out (http://www.databasejournal.com/scripts/article.php/1496451)|||...And this is what M$ says about this process:

Q. Can I rename a server after installing SQL Server 2000?

A: Yes, you can rename a server after the installation of SQL Server 2000. When the SQL Server service starts for the first time after the name change, it automatically recognizes the change and resets the computer name. You do not need to run setup again to reset this value. However, you must perform several additional configuration steps. To correct the sysservers system table, you should manually run the following procedures.

For a default instance: sp_dropserver <old_servername>
go
sp_addserver <new_servername> , local
go

For a named instance:sp_dropserver <old_servername\instancename>
go
sp_addserver <new_servername\instancename> , local
go|||Thanks.

I'll try that. It is actually SQL 7. We are upgrading a SQL 7 server to SQL 2000. The SQL 2000 is a new box and we want to keep the SQL 7 server around on the lan for a while.

Thanks again

Chuck

Removing operators from System administrator Role

Hi List!
I have 2 users with SA admin rol granted on a SQL2000 SP3 Server. I want to
take them off, but the people said me that they need to monitor a lot of job
s
running on this server, so what priviledges does i need to grant them to all
o
to see the results of this jobs?496371c0860" target="_blank">http://groups.google.de/group/micro.../>
496371c0860
http://groups.google.de/group/micro...853a5d26aa1b4e1
HTH, Jens Suessmeyer.
"Tinchos" wrote:

> Hi List!
> I have 2 users with SA admin rol granted on a SQL2000 SP3 Server. I want t
o
> take them off, but the people said me that they need to monitor a lot of j
obs
> running on this server, so what priviledges does i need to grant them to a
llo
> to see the results of this jobs?
>

Removing operators from System administrator Role

Hi List!
I have 2 users with SA admin rol granted on a SQL2000 SP3 Server. I want to
take them off, but the people said me that they need to monitor a lot of jobs
running on this server, so what priviledges does i need to grant them to allo
to see the results of this jobs?
http://groups.google.de/group/micros...9c4496371c0860
http://groups.google.de/group/micros...53a5d26aa1b4e1
HTH, Jens Suessmeyer.
"Tinchos" wrote:

> Hi List!
> I have 2 users with SA admin rol granted on a SQL2000 SP3 Server. I want to
> take them off, but the people said me that they need to monitor a lot of jobs
> running on this server, so what priviledges does i need to grant them to allo
> to see the results of this jobs?
>

Removing operators from System administrator Role

Hi List!
I have 2 users with SA admin rol granted on a SQL2000 SP3 Server. I want to
take them off, but the people said me that they need to monitor a lot of jobs
running on this server, so what priviledges does i need to grant them to allo
to see the results of this jobs?http://groups.google.de/group/microsoft.public.sqlserver.server/browse_frm/thread/795ec20703b7b535/919c4496371c0860?tvc=1&q=jobs+Jens+S%C3%BC%C3%9Fmeyer&hl=de#919c4496371c0860
http://groups.google.de/group/microsoft.public.sqlserver.security/browse_frm/thread/1d0ffa0f2b2fbdcd/0853a5d26aa1b4e1?lnk=st&q=jobs+Jens+S%C3%BC%C3%9Fmeyer&rnum=6&hl=de#0853a5d26aa1b4e1
HTH, Jens Suessmeyer.
"Tinchos" wrote:
> Hi List!
> I have 2 users with SA admin rol granted on a SQL2000 SP3 Server. I want to
> take them off, but the people said me that they need to monitor a lot of jobs
> running on this server, so what priviledges does i need to grant them to allo
> to see the results of this jobs?
>