Category: Windows Server

Windows PowerShell: New-ItemProperty HKLM:SystemCurrentControlSetControlLsa -Name "DisableLoopbackCheck" -Value "1" -PropertyType dword
El fichero de hosts sigue estando en la misma ruta, solo que la carpeta “etc” ya no es visible, pero podemos acceder igualmente escribiendo la ruta. C:WindowsSystem32driversetc
En ocasiones no podemos añadir una Vista de SQL Server a nuestro modelo de Entity Framework y nos dice que es porque la vista no contiene ninguna “Key”. Para resolver este problema debemos tener en cuenta que No se pueden crear Primary Keys en Vistas. La solución para por crear una columna nueva autonumérica. Seguiremos […]
1. Go to Control Panel and System and Security 2. Go to Windows Firewall 3. From the left menu, select Turn Windows Firewall on or off 4. Check all options with Turn off Windows Firewall (not recommended) 5. All options should be red now
1. Go to Administrative Tools 2. Open Active Directory Users and Computers 3. Go to Builtin and you will see some Groups, like Administrators 4. Double-click on Administrators group 5. Go to Members Tab and click on Add… to insert users as administrators 6. You will see new users in the Members List
1. Add Role from Server Manager 2. Role-based or feature-based installation 3. Select a server from the server pool 4. Select Active Directory Domain Services and DNS Server. 5. Once installed, from Notifications Menu, select Promote this server to a domain controller 6. Add a new Forest 7. Write a password 8. Next 9. Check […]
1. Execute your Query with “Results to Grid” option selected (You can select this option with its icon or by menu “Query – Results To – Results to grid”). 2. Once your Query has finished, right-click on the results grid and select the option “Save results As…“. 3. Save as Type: CSV.
Basically: Password must not contain the user’s entire Account Name. Password must contain an Uppercase character, a Lowercase character and a number (0 through 9). More info: http://technet.microsoft.com/en-us/library/cc786468%28v=ws.10%29.aspx
Si tenemos el nombre de una columna de nuestra base de datos pero no sabemos en que tabla está, podemos buscarlo a mano si tenemos un pequeño proyecto, pero cuando la base de datos contiene una cantidad considerable de tablas y cada tabla bastantes columnas es muy engorroso buscarla a mano. En SQL existe una […]