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.
Showing posts with label environnement. Show all posts
Showing posts with label environnement. Show all posts
Wednesday, March 28, 2012
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.
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
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
Subscribe to:
Posts (Atom)