Can not create my Publisher

Hi,
I install Sql server 2000 on a server named JMI_SQL
After Installation we decide to rename the server JMI_SQL for SQL2007
I create a Distributor on the server SQLDIST2007
Once my distibutor created i try to create my Publisher on SQL2007 and I
receive this message
Error 18482 Could not connec to server SqlDIST2007 because JMI_SQL is not
defined as a remote Server
In the Wizard when I was creating my Publisher I select SQl2007 as Publisher
and the wizard is looking for JMI_SQL which the old name of the server
I try those commands in sql query analyser to get some information
select @.@.servername Show JMI_SQL
SELECT srvname, srvid
FROM sysservers
Show this
ADAMM_DB1
BESERVER_DB2
CATALOG_DB3
JMI_SQL0
repl_distributor 4
In the tables master.sysservers I try to Change manually all the JMI_SQL for
SQL2007 Sql server dont let me change it
Is there a way that I can change the JMI_SQL for SQL2007 in the sysservers
table
I would like to avoid to uninstall and reinstall Sql Server 2000
Before trying to do something I would like to have an advise from
experimented person on how to do that.
Thanks in advance and have a nice day!
Hi Gav,
Thanks a lot for the information
I appreciate very much !
Have a nice day
"Gav" wrote:

> Using Query Analyzer, execute the following:
> Use master
> go
> sp_dropserver 'JMI_SQL', droplogins
> go
> sp_addserver 'SQL2007', LOCAL
> go
> After you have done this make sure you restart the SQL service or restart
> your computer (whichever you fancy!) and that should do it
> Regards
> Gav
> "GC" <GC@.discussions.microsoft.com> wrote in message
> news:65162A3C-16DB-43C1-884D-601056BEFAF8@.microsoft.com...
>
>
sql

can i run alter "database rename logical file" on live production server?

Just wondering if i can do this on a live database?
Matt
Hi,
You could do that; because it just updates the system tables. But I wont
advise any changes to production
database while online.
Thanks
Hari
SQL Server MVP
"Matt Landis" <matt(remove)@.landiscomputer.com> wrote in message
news:%23Exlumm4GHA.3512@.TK2MSFTNGP04.phx.gbl...
> Just wondering if i can do this on a live database?
> Matt
>

can i run alter "database rename logical file" on live production server?

Just wondering if i can do this on a live database?
MattHi,
You could do that; because it just updates the system tables. But I wont
advise any changes to production
database while online.
Thanks
Hari
SQL Server MVP
"Matt Landis" <matt(remove)@.landiscomputer.com> wrote in message
news:%23Exlumm4GHA.3512@.TK2MSFTNGP04.phx.gbl...
> Just wondering if i can do this on a live database?
> Matt
>

can i run alter "database rename logical file" on live production server?

Just wondering if i can do this on a live database?
MattHi,
You could do that; because it just updates the system tables. But I wont
advise any changes to production
database while online.
Thanks
Hari
SQL Server MVP
"Matt Landis" <matt(remove)@.landiscomputer.com> wrote in message
news:%23Exlumm4GHA.3512@.TK2MSFTNGP04.phx.gbl...
> Just wondering if i can do this on a live database?
> Matt
>

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon
SQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon
|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
SimonSQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Sorry - forgot to mention that if you have any remote logins, then you may
get an error. If so, you need to drop those before you can drop the
servername.
Apologies for the incomplete first response - was just running to the coffee
machine - it's that time of the day
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon|||Some thoughts here:
http://www.karaszi.com/SQLServer/in...server_name.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Simon Harvey" <nothanks@.hotmail.com> wrote in message news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx
.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is
> it "name agnostic"?
> Many thanks
> Simon

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
SimonSQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Sorry - forgot to mention that if you have any remote logins, then you may
get an error. If so, you need to drop those before you can drop the
servername.
Apologies for the incomplete first response - was just running to the coffee
machine - it's that time of the day :)
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon|||Some thoughts here:
http://www.karaszi.com/SQLServer/info_change_server_name.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Simon Harvey" <nothanks@.hotmail.com> wrote in message news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is
> it "name agnostic"?
> Many thanks
> Simon