join SQL server into domain

Hi all,
I have 3 W2K3 servers running in WORKGROUP: one SQL2K5 running as the
backend database server; one Sharepoint server; one SQL Report Server web
server.
I'm going to join these 3 servers into AD domain, will it cause any problem?
Will it break the connection between the SQL server and the other 2 servers?
Anyone has experience on this? Thanks!
MliHi
If you rename the server then you will need to
http://msdn2.microsoft.com/en-us/library/ms143799.aspx and also change any
connections strings to the new name. Logins from the old workgroup may need
removing and new ones added for the domain. Service accounts may require
changing and orphaned users may need to be resolved
http://support.microsoft.com/kb/314546. If you create any new users they wil
l
need to have permissions added.
John
"MLi" wrote:

> Hi all,
> I have 3 W2K3 servers running in WORKGROUP: one SQL2K5 running as the
> backend database server; one Sharepoint server; one SQL Report Server web
> server.
> I'm going to join these 3 servers into AD domain, will it cause any proble
m?
> Will it break the connection between the SQL server and the other 2 server
s?
> Anyone has experience on this? Thanks!
>
> Mli
>
>
>|||Thanks John.
I'm not gonna change the server name, however because it will be joined a
domain, the DNS name will be changed. Is there any concern?
MLi
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:26F04787-0DB9-4C8C-8D60-1EA65E52F8E7@.microsoft.com...[vbcol=seagreen]
> Hi
> If you rename the server then you will need to
> http://msdn2.microsoft.com/en-us/library/ms143799.aspx and also change any
> connections strings to the new name. Logins from the old workgroup may
> need
> removing and new ones added for the domain. Service accounts may require
> changing and orphaned users may need to be resolved
> http://support.microsoft.com/kb/314546. If you create any new users they
> will
> need to have permissions added.
> John
> "MLi" wrote:
>|||Hi
The name of the instance will still be the name of the old servername,
SELECT @.@.SERVERNAME will still show the old one. That is why you need to dro
p
it and create the new one.
John
"MLi" wrote:

> Thanks John.
> I'm not gonna change the server name, however because it will be joined a
> domain, the DNS name will be changed. Is there any concern?
>
> MLi
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:26F04787-0DB9-4C8C-8D60-1EA65E52F8E7@.microsoft.com...
>
>