I was working with a vendor for some specialty software, they could install the software but were not able to configure SQL… though the software is heavily integrated with SQL.
I have to admit, I am not too familiar with SQL so troubleshooting it, I have to utilize my Google fu…
“Error: Test connection to the database server has failed because of network problems:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.”
1. Login to the server -> Start -> All Programs -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> right click “TCP/IP” and select “Enable”.
2. Start -> Run -> type “services.msc” -> Restart SQL service.
Also check a service called ‘SQL Server Browser‘ and make sure it is running…
We have a Terminal Server and need to install Office without a Volume License.
According to THIS, that is allowed with E3 licensing.
So, a couple of things to note here:
1. RDS is not permitted for Small Business premium
2. RDS IS permitted for M, E3 and E4
3. There are no caveats or foot notes as there used to be
Now the actual question, HOW do you do it?
Here the answer:
1. Start by downloading the “Office Deployment Tool for Click-To-Run” and extract it in a shared directory.
2. Navigate to your extracted folder (in our example \\server\o365) and edit the ‘configuration.xml’ file following the Microsoft guidelines:
<Add SourcePath="\\<path>\O365" OfficeClientEdition="32" >
<Language ID="en-us" />
<Updates Enabled="TRUE" />
<Display Level="Full" AcceptEULA="TRUE" />
<Property Name="SharedComputerLicensing" Value="1" />
3. Open CMD, navigate to the extraction folder (e.g. C:\O365) and run:
setup.exe /download \\server\O365\configuration.xml
Let it run it will download the installer, it will create a new folder called ‘Office’ and should be about 1GB once it finished.
4. Run the installer from CMD
\\server\o365\setup.exe /configure \\server\o365\configure.xml
Once that is done you should have O365 installed and it can be activated with individual O365 (E3) licenses. :o)
Since managing it remotely in anon domain environment is a pain in the neck and I’ll have to setup quite a few servers in the next couple of weeks, here a quick ‘how to’ mange Hyper-V Server 2016 remotely.
2. Configure Remote Management + ping (Opt. 4 -> Opt. 4 -> Opt. 1)
3. Enabled Remote Desktop (Opt. 7 -> e -> Opt. 2)
4. Run this command to allow RDP through the server’s firewall:
netsh advfirewall firewall set rule group="remote desktop" new enable=Yes
5. Launch Powershell and execute this command:
Install-WindowsFeature –Name Hyper-V –IncludeManagementTools –Restart
1. Add an entry to the hostfile as you can not add a Hyper-V server via IP
(e.g. 192.168.1.1 HOSTSRV01.WORGROUP HOSTSRV01)
2. Run -> dcomcnfg, right-click on ‘My Computer’ -> Properties -> COM Security Tab -> Access Permissions -> Edit Limits -> Anonymous Logon -> Allow ‘Local & Remote’ Access
cmdkey /add:<HostServerName> /user:<AdminUsername> /pass:"<Password>"
4. Install the RSAT Tools for your Operating system. Open the Server Manager and add the Hyper-V host as a server.
5. You should get a permission error, run the following command:
Set-Item wsman:\localhost\Client\TrustedHosts <HostServerName> -Concatenate -Force
Now you should be able to remote manage / create / edit your Hyper-V Server.
Alright so one of our customer’s shared drive broke, we were able to restore it and such, however the needed rights were gone. I found a cool nifty tool called “SubInACL” to help me out. The default install is in
C:\Program Files (x86)\Windows Resource Kits\Tools
The syntax for SubInCAL is like so:
SUBINACL /<service> \\MachineName\FOLDER\* /GRANT=[DomainName\]UserName[=Access]
So in my case I used:
subinack /file D:\Data\* /grant=system=F
subinack /file D:\Data\* /grant=<domainname>\<username>=F
The <access>parameter follows this list:
F : Full Control
R : Generic Read
W : Generic Write
X : Generic eXecute
L : Read controL
Q : Query Service Configuration
S : Query Service Status
E : Enumerate Dependent Services
C : Service Change Configuration
T : Start Service
O : Stop Service
P : Pause/Continue Service
I : Interrogate Service
U : Service User-Defined Control Commands
To get all the sub-directories you can use the switch ‘/subdirectories‘
Such an easy command saved the day!