If you try to run an executable and you receive this dialog box:
"Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item."
Here is the fix. Right click on the executable, and click on the Unblock button.
Done! 🙂
Here is how to enable it:
To enable Lockdown mode via console:
Log in directly to the ESXi host.
Open DCUI on the host.
Press F2 for Initial Setup.
Toggle the Configure Lockdown Mode setting.
To enable Lockdown mode via vSphere:
Log in to vSphere
Click on the Home->Inventory->Hosts and Clusters
Click on the host you want to manage
Click on the Configuration manager
Click on "Security Profile" on the left side
Click the Edit... link next to Lockdown Mode
Enable it!
Here is the command!
TRUNCATE TABLE mytableIf you are installing VMware vCenter5 and you notice that their are no connectors for connecting to a remote msSQL database, here is how to add a new ODBC connector to get things up and running.
--You should see "TESTS COMPLETED SUCCESSFULLY!"
Here is how to enable remote SQL connections for Server 2008:
Open up SQL Server Configuration Manager
Click on SQL Server Network Configuration
--Enable Named Pipes
--Enable TCP/IP
Protocols for SQLEXPRESS (OR YOUR INSTANCE)
-Double click on TCP/IP
Find the IP addresses with your IP and IP of 127.0.0.1
--TCP Dyanmic Ports (Remove the 0 and leave empty)
--TCP Port 1433
Open up Windows Firewall with Advanced Security
-Click on Inbound Rules
--Create the following rules
SQL
1433 - TCP - Check if you want Domain, Private, and Public Access
SQL
1434 - UDP - Check if you want Domain, Private, and Public Access
Transact-SQL debugger (Used for Visual Studio)
135 - TCP - Check if you want Domain, Private, and Public Access