Citrix XenApp XenDesktop 7.5 – The current credentials have insufficient privileges to access the database server and perform the necessary operations

Hello fellow Admins,

We might have a workaround for installing a new Site/DDC in your XenApp/XenDesktop farm and you can’t because of this pesky error,

and also don’t want or can’t to add sysadmin permissions the database user used to install the site/DDC.
The solution is to assign to the database user the following permission sets: public and securityadmin

 

capture

 

https://support.citrix.com/article/CTX132269

 

PS: This permission set might be a setting that is not supported by Citrix!

Tagged with: ,
Posted in fixes

Van Damme does it again!

jcvd_trucks

Posted in funny, Victor

Internet!

20140223-095622.jpg

Tagged with: , , ,
Posted in funny, Victor

Error loading /tools.t00 Fatal error: 10 (Out of resources) – Cisco UCS C240 M3 server with ESXi 5.5

Hi guys (and girls),
Just wanted to let you know that if you get the error message “Error loading /tools.t00 Fatal error: 10 (Out of resources)” when trying to install VMware’s ESXi 5.5 hypervisor on a Cisco UCS C240 M3 SFF rackable server with some GPUs in it, just follow the next steps to fix it:

1. Go to System BIOS (Press F2)
2. PCI configuration > MMCFG
3. Change the value from Auto to 2 GB
4. Change the value of Memory Mapped IO above 4 G to Enabled
5. Save and reboot the system
6. Installation will complete.

2014-02-07_08-02-11_10.113.108.149 - KVM Console

Hopefully you will solve this issue by yourself, not like me, after a couple of days with help from my Cisco technical friends 🙂

Apparently, the error cannot be reproduced on the same system but with no GPUs, as i have it, or on ESXi 5.1. Cisco told me that they’re working with VMware on this one and hopefully they will create a more fashionable way on getting the systems up and running.

Good luck!

Posted in error, fixes, HowTo

Prima poza de cand vad altfel lumea, este cu Moise Guran!

MoiseGuran_VictorHomocea

Prima poza de cand nu mai am ochelari am vrut sa fie putin mai speciala asa ca l-am gasit pe Moise Guran in fata sediului si l-am deranjat (sper ca nu s-a suparat) rugandu-l sa apara intr-o fotografie cu mine 🙂

Multumesc!

Tagged with:
Posted in Victor

How to export all members of all groups in a certain OU with PowerShell

This is the script that cost me near 2h of googling on the Internet.
What does it do?
It exports a list of users with custom given attributes, members of groups in an OU you specify.
This script plus some basic Excel processing helped me to find out how many Citrix users we have in all groups we use.

Get-QADGroup -SizeLimit 0 -SearchRoot 'ww.contoso.com/OU/AnotherOU/Groups/Global/Citrix' | Get-QADGroupMember -SizeLimit 0 | select NTAccountName,AccountIsDisabled,Name | Export-Csv C:\TEMP\all_my_groups.csv

Posted in HowTo, PowerShell

How to count how many users a group has, including nested groups

I must admit that i was searching for one hour how to see how many members a given group has, so something like a count of members but also including nested groups. It’s a sweet PowerShell command for you guys making reports like i do.
Well here it is:

Get-QADGroup group_nam* -SizeLimit 0 | Select-Object Name,@{n='MemberCount';e={ (Get-QADGroupMember -Indirect -SizeLimit 0 $_ | Measure-Object).Count}}

The * (star) before -SizeLimit is telling powershell to apply the command for all groups begging with “group_nam”, so the query is valid for “group_name” but also for “group_name_in_another_location”

By removing the -Indirect statement, you get only the direct members, excluding nested ones (members of other groups, inside given group)

Posted in HowTo, PowerShell

How to export all members of a group with PowerShell

This is how you can export all members of an Active Directory group, together with some custom attributes like email address, homedirectory, office and check if their account are disabled in AD:

Get-QADGroupMember group -SizeLimit 0 | select email,homedirectory,office,AccountIsDisabled,name | Export-Csv C:\temp\exported_group.csv

The -SizeLimit 0 is inserted to remove the limit for results, so just use it in your commands.

Posted in HowTo, PowerShell

How to export in CSV all users with special attributes, members of a domain (PowerShell)

Well, this one is really simple:

Get-QADUser * -SizeLimit 0 | select name,displayname,email,company,stateorprovince,city,streetaddress,office | Export-Csv C:\temp\ExportUsers.csv

You can type Get-QADUser username | select * and all user attributes will be shown on screen. You can insert these attributes in the 1st command, as a replacement for name, displayname, email, company, stateorprovince, city, streetaddress or office 😉

Posted in HowTo, PowerShell

How to install Quest ActiveRoles PowerShell SnapIn

Well,
It’s simple. You just use the following link to download:
http://www.quest.com/powershell/activeroles-server.aspx
This “Plugin” for PowerShell is one hell of a tool for System Administrators.

In order to use it, open PowerShell or PowerShell ISE and load it with:
Add-PSSnapin *quest*

Some basic commands:

Get-Help
Get-Command
get-command Quest.ActiveRoles.ADManagement\*

Good luck!
;)

Posted in HowTo, PowerShell
Follow Victor Homocea on WordPress.com
My Gravatar