I upgraded a small office last night from one windows 2003 domain controller to a new Windows 2008 small business server. Since the Small Business server HAS to be the domain controller, I demoted the W2K3 server to a member server, and attached it to the new domain.
1st problem: The demoted Windows 2003 server is running an SQL database, and now the client machines can no longer connect to the sql database. Yet, if I am at the console of the server, I can run the database software just fine.
2nd problem: There is a remote office that used to use remote desktop to connect into the server and use the SQL database. Now, remote desktop does not connect to this server any longer. Could this connectivity problem have anything to do with the server being demoted, and maybe the terminal services aren't running any longer? Locally, the client machines can remote desktop the server, but we can't do it from the outside any longer. I checked the port forwarding in the router, and everything is looking appropriate. It's as if the demoted W2K3 server is no longer accepting outside remote desktop connections.