Archive for 24 de maio de 2008

h1

Deinstalar Active Directory (Inglês)

24/05/2008

Uninstall Active Directory

To use the Active Directory Installation Wizard to remove Active Directory, you must know the password to assign to the local Administrator account of the server after Active Directory is removed.

Administrative Credentials

To perform this procedure, you must be a member of the Domain Admins group.

To uninstall Active Directory
1. Click Start, click Run, type dcpromo and then click OK.
2. The Active Directory Installation Wizard appears. Click Next at the Welcome screen.
3. You have an option to select This server is the last domain controller in the domain. If you select this option, the wizard attempts to remove the domain from the forest. Do not select this option. Click Next.
4. At the Administrative Password screen, enter and confirm the password that you want to assign to the local Administrator account after Active Directory is removed. Click Next.
5. At the Summary screen, verify that the information is correct and then click Next to proceed with the removal.
6. The wizard proceeds to remove Active Directory. After it finishes, the wizard displays a completion screen. Click Finish to close the wizard.
7. Click Restart to restart the domain controller.

Fonte:

http://technet2.microsoft.com/windowsserver/en/library/138fba53-b4ce-48db-87d7-97fa74b0011b1033.mspx?mfr=true

h1

Mudar login do DBO

24/05/2008

Em virtude do usuário DBO ser o dono do banco, o login mapeado para ele é o dono do banco. Para trocar então esse mapeamento, basta que você atribua um novo dono. Você poderá fazer isso através da procedure sp_change_db_owner.

Code Snippet

Use Banco

Go

sp_changedbowner @loginame = ‘Owner’

fonte: http://forums.microsoft.com/MSDN-BR/ShowPost.aspx?PostID=2878931&SiteID=21