|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > SQL7.0
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Huong Tran 2002-12-16, 11:23 am |
| I recently imaged sql7.0 and NT4 on one of my servers. If
I rename the server, sql 7 stops working. Does anyone
know of a workaround besides rebuidling it and then adding
sql 7?
Thanks!
| |
| Keith Kratochvil 2002-12-16, 11:23 am |
| after you rename the server you will probably have to
drop in the SQL 7 CD...run "setup" (really just fixes some registry entries)
SQL Server should work now.
You will probably need to log in and exec
sp_dropserver 'oldname'
go
sp_addserver 'newname', 'local'
--
Keith, SQL Server MVP
"Huong Tran" <htran@genevasi.com> wrote in message
news:06a001c2a523$7dac7dd0$d5f
82ecf@TK2MSFTNGXA12...
> I recently imaged sql7.0 and NT4 on one of my servers. If
> I rename the server, sql 7 stops working. Does anyone
> know of a workaround besides rebuidling it and then adding
> sql 7?
>
> Thanks!
| |
| H Tran 2002-12-16, 11:23 am |
| It doesn't matter that there's already another instance of
SQL on the machine?
>-----Original Message-----
>after you rename the server you will probably have to
>drop in the SQL 7 CD...run "setup" (really just fixes
some registry entries)
>SQL Server should work now.
>You will probably need to log in and exec
>sp_dropserver 'oldname'
>go
>sp_addserver 'newname', 'local'
>
>--
>Keith, SQL Server MVP
>
>
>"Huong Tran" <htran@genevasi.com> wrote in message
> news:06a001c2a523$7dac7dd0$d5f
82ecf@TK2MSFTNGXA12...
>> I recently imaged sql7.0 and NT4 on one of my servers.
If
>> I rename the server, sql 7 stops working. Does anyone
>> know of a workaround besides rebuidling it and then
adding
>> sql 7?
>>
>> Thanks!
>
>
>.
>
| |
| Keith Kratochvil 2002-12-16, 12:24 pm |
| Does the other instance work?
--
Keith, SQL Server MVP
"H Tran" <htran@genevasi.com> wrote in message
news:060a01c2a526$70263e50$d7f
82ecf@TK2MSFTNGXA14...
> It doesn't matter that there's already another instance of
> SQL on the machine?
>
> >-----Original Message-----
> >after you rename the server you will probably have to
> >drop in the SQL 7 CD...run "setup" (really just fixes
> some registry entries)
> >SQL Server should work now.
> >You will probably need to log in and exec
> >sp_dropserver 'oldname'
> >go
> >sp_addserver 'newname', 'local'
> >
> >--
> >Keith, SQL Server MVP
> >
> >
> >"Huong Tran" <htran@genevasi.com> wrote in message
> > news:06a001c2a523$7dac7dd0$d5f
82ecf@TK2MSFTNGXA12...
> >> I recently imaged sql7.0 and NT4 on one of my servers.
> If
> >> I rename the server, sql 7 stops working. Does anyone
> >> know of a workaround besides rebuidling it and then
> adding
> >> sql 7?
> >>
> >> Thanks!
> >
> >
> >.
> >
| |
| h tran 2002-12-16, 12:24 pm |
| no. what i did was restore an image of a server that has
windows nt 4 and sql 7 on it. this is being used in a
test lab. for various tests, we change the computer
name. if i dont change the name, sql 7 works fine. if i
do change it, things start to get ugly.
>-----Original Message-----
>Does the other instance work?
>
>--
>Keith, SQL Server MVP
>
>
>"H Tran" <htran@genevasi.com> wrote in message
> news:060a01c2a526$70263e50$d7f
82ecf@TK2MSFTNGXA14...
>> It doesn't matter that there's already another instance
of
>> SQL on the machine?
>>
>> >-----Original Message-----
>> >after you rename the server you will probably have to
>> >drop in the SQL 7 CD...run "setup" (really just fixes
>> some registry entries)
>> >SQL Server should work now.
>> >You will probably need to log in and exec
>> >sp_dropserver 'oldname'
>> >go
>> >sp_addserver 'newname', 'local'
>> >
>> >--
>> >Keith, SQL Server MVP
>> >
>> >
>> >"Huong Tran" <htran@genevasi.com> wrote in message
>> > news:06a001c2a523$7dac7dd0$d5f
82ecf@TK2MSFTNGXA12...
>> >> I recently imaged sql7.0 and NT4 on one of my
servers.
>> If
>> >> I rename the server, sql 7 stops working. Does
anyone
>> >> know of a workaround besides rebuidling it and then
>> adding
>> >> sql 7?
>> >>
>> >> Thanks!
>> >
>> >
>> >.
>> >
>
>
>.
>
| |
| Tibor Karaszi 2002-12-17, 5:23 am |
| What version is this other instance of?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"H Tran" <htran@genevasi.com> wrote in message
news:060a01c2a526$70263e50$d7f
82ecf@TK2MSFTNGXA14...
> It doesn't matter that there's already another instance of
> SQL on the machine?
>
> >-----Original Message-----
> >after you rename the server you will probably have to
> >drop in the SQL 7 CD...run "setup" (really just fixes
> some registry entries)
> >SQL Server should work now.
> >You will probably need to log in and exec
> >sp_dropserver 'oldname'
> >go
> >sp_addserver 'newname', 'local'
> >
> >--
> >Keith, SQL Server MVP
> >
> >
> >"Huong Tran" <htran@genevasi.com> wrote in message
> > news:06a001c2a523$7dac7dd0$d5f
82ecf@TK2MSFTNGXA12...
> >> I recently imaged sql7.0 and NT4 on one of my servers.
> If
> >> I rename the server, sql 7 stops working. Does anyone
> >> know of a workaround besides rebuidling it and then
> adding
> >> sql 7?
> >>
> >> Thanks!
> >
> >
> >.
> >
|
|
|
|
|