Saturday, February 25, 2012

New domain name - problems connecting

I installed SQL Server 2005 yesterday on a freshly installed Windows 2003 R2
standard server. I installed with mixed-mode authentication and was able to
connect to the database.
The server was then changed to a PDC with a new forest and domain. I am now
unable to connect. What changes do I need to make to Sql Server to get back
up and running.
tia,
Bob M..Refer:
http://support.microsoft.com/kb/910228/en-us#E0WR0ABAAA
Do not change the role of the server after you install SQL Server 2005. For
example, if you install SQL Server 2005 on a member server, do not use the
Dcpromo tool to promote the server to a domain controller. Or, if you
install SQL Server 2005 on a domain controller, do not use Dcpromo to
demote the server to a member server. Changing the role of a server after
you install SQL Server 2005 can result in loss of functionality and is not
supported.
=======
--
>From: "Bob Murdoch" <ram_re_move_5@.erols.com>
>Subject: New domain name - problems connecting
>Date: Thu, 4 May 2006 12:44:16 -0400

>I installed SQL Server 2005 yesterday on a freshly installed Windows 2003
R2
>standard server. I installed with mixed-mode authentication and was able
to
>connect to the database.
>The server was then changed to a PDC with a new forest and domain. I am
now
>unable to connect. What changes do I need to make to Sql Server to get
back
>up and running.
>tia,
>Bob M..
>
>

No comments:

Post a Comment