Remove DC from Cluster Node

We have:

A Microsoft cluster, (SQL Failover cluster) with one node as the domain controller. The cluster was built off site and the domain name used is the same as our existing domain where we eventually need to install this cluster.

We need: (At least I think we need:)

To remove node 2 from the "cluster domain", DCPROMO node 1 and eliminate the "cluster domain". We then need to join the cluster (nodes) to the existing domain. We also need to recreate the accounts and groups used during installation.

Questions:

1) What will happen to the "domain accounts" used when installing SQL2005? (Other than they will go away. I mean what adverse impact will that have on the installation?)

2) Will I have to re-install SQL 2005?

3) Is my paranoia real or imagined? (Will Elvis live?)

Any prior experience with this would be greatly appreciated. In fact, a WAG is appreciated too.

Regards,

Mike

For cluster setup issues, please use the SQL Server Disaster Recovery and Availability forum.

Thanks
Laurentiu

remote sql server is the same as local in em

Hello,
In EM under node Remote Servers I see the remote server with the same name
as a local. For example my server name is WP200 and remote server shows
WP200. It is sql 2000. The RCP is checked and map all logins to different
logins selected but there is nothing in the selection grid.
I can't figure out for what purpose it was set up this way.
Please help.
thank you very much.
JanHi Jan
Your local server will appear under the remote servers, if it doesn't then
@.@.SERVERNAME will probably return the wrong value. Reading sp_addserver in
BOL and the @.LOCAL parameter may help!
John
"Jan" wrote:

> Hello,
> In EM under node Remote Servers I see the remote server with the same name
> as a local. For example my server name is WP200 and remote server shows
> WP200. It is sql 2000. The RCP is checked and map all logins to different
> logins selected but there is nothing in the selection grid.
> I can't figure out for what purpose it was set up this way.
> Please help.
> thank you very much.
> Jan|||For remote server access to work, the 'remote access' configuration option,
which controls logins from remote servers, must be set to 1 can be done usin
g
sp_configure
refer Configuring Remote Servers chapter in BOL
Amol Lembhe
"John Bell" wrote:
[vbcol=seagreen]
> Hi Jan
> Your local server will appear under the remote servers, if it doesn't then
> @.@.SERVERNAME will probably return the wrong value. Reading sp_addserver in
> BOL and the @.LOCAL parameter may help!
> John
> "Jan" wrote:
>

remote sql server is the same as local in em

Hello,
In EM under node Remote Servers I see the remote server with the same name
as a local. For example my server name is WP200 and remote server shows
WP200. It is sql 2000. The RCP is checked and map all logins to different
logins selected but there is nothing in the selection grid.
I can't figure out for what purpose it was set up this way.
Please help.
thank you very much.
JanHi Jan
Your local server will appear under the remote servers, if it doesn't then
@.@.SERVERNAME will probably return the wrong value. Reading sp_addserver in
BOL and the @.LOCAL parameter may help!
John
"Jan" wrote:
> Hello,
> In EM under node Remote Servers I see the remote server with the same name
> as a local. For example my server name is WP200 and remote server shows
> WP200. It is sql 2000. The RCP is checked and map all logins to different
> logins selected but there is nothing in the selection grid.
> I can't figure out for what purpose it was set up this way.
> Please help.
> thank you very much.
> Jan|||For remote server access to work, the 'remote access' configuration option,
which controls logins from remote servers, must be set to 1 can be done using
sp_configure
refer Configuring Remote Servers chapter in BOL
Amol Lembhe
"John Bell" wrote:
> Hi Jan
> Your local server will appear under the remote servers, if it doesn't then
> @.@.SERVERNAME will probably return the wrong value. Reading sp_addserver in
> BOL and the @.LOCAL parameter may help!
> John
> "Jan" wrote:
> > Hello,
> > In EM under node Remote Servers I see the remote server with the same name
> > as a local. For example my server name is WP200 and remote server shows
> > WP200. It is sql 2000. The RCP is checked and map all logins to different
> > logins selected but there is nothing in the selection grid.
> > I can't figure out for what purpose it was set up this way.
> > Please help.
> > thank you very much.
> >
> > Jan

Remote Setup on cluster node fail

Hi,

I've tried to install SQL Server 2005 September CTP as the first named instance on a Windows Server 2003 Enterprise Edition Cluster.

During the setup process a scheduled task is created on the second cluster node, but this task is not able to run.

I received this error message in the scheduled task log file:
0x80070005: Access is denied

The user account I'm using to install SQL Server is member of the administrator on all cluster nodes, it has also the permission to log on as a service and as a batch job. The user is also permitted to access the computer from the network.

Thanks in advance for the help!

Regards,
ClausThis might be caused by a known Windows bug. Task Scheduler service fails to launch setup on a remote node even if Task Scheduler is running. If someone is logged into remote node, they risk of hitting this Windows bug. Thefore log off any Terminal Server sessions from all remote nodes before you start setup. |||Hi Yim,

Yes! That's it - i logged of from the second cluster node and the installation completes successful!

Thanks a lot!