change computer account password Active directory
- No Comments
- Jul, 26, 2013
- Angelo Schalley
- Active Directory, security, Windows-Microsoft
Twee belangrijke zaken om rekening mee te houden voor de uitvoer:
1. Admin user is op basis van DisplayName in het geval van spaties quoten gebruiken “ …”
2. Het script kijkt naar de default OU’s voor zowel user als het aanmaken van de computer in de AD. (Default OU Users OU Computers) zorg dat de Admin gebruiker daar staat.
Start nu een elevated cmd:
Cd c:\temp
C:\temp> CreateComputerAccount.vbs <nieuwe computer account> <pwd account> <FQDN> <Domeincontroller> <Admin user> <admin user pwd>
Security advies:
NTLM aanpassingen in de locale security policys op de DC: (bv: auditing en ntlmv2)
http://technet.microsoft.com/en-us/library/jj865668(v=ws.10).aspx
Read more on change computer account password Active directory…
Allow Domain Admin to Login to SQLServer & have full Access
- No Comments
- Jan, 09, 2013
- Angelo Schalley
- MS SQL, Windows-Microsoft
For some reason when SQLServer 2008 was installed/setup, admins were not added. Therefore when trying to login via SQL Management Studio, an error was obtained:
Login failed for user “username”. (Microsoft SQL Server, Error: 18456)
I also didn’t know the “sa” password which would have let me login. I also didn’t have access to another admin account to test logging in under their account.
Read more on Allow Domain Admin to Login to SQLServer & have full Access…
SQL authentication – mixed vs windows
- No Comments
- Jan, 09, 2013
- Angelo Schalley
- Active Directory, MS SQL, security, Windows-Microsoft
Microsoft SQL Server offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making the proper choice affects both the security and maintenance of your organization’s databases.
Authentication Basics
Authentication is the process of confirming a user or computer’s identity. The process normally consists of four steps:
Read more on SQL authentication – mixed vs windows…