{"id":202,"date":"2019-09-16T13:55:14","date_gmt":"2019-09-16T13:55:14","guid":{"rendered":"http:\/\/robinplomp.com\/?p=202"},"modified":"2019-09-16T14:03:00","modified_gmt":"2019-09-16T14:03:00","slug":"enable-csuser-cannot-open-database-xds-requested-by-the-login","status":"publish","type":"post","link":"https:\/\/robinplomp.com\/?p=202","title":{"rendered":"Enable-CsUser : Cannot open databasE xds requested by the login"},"content":{"rendered":"

\"AfbeeldingsresultaatIf you read the blog before you should know that I am a big fan of automating repetitive admin tasks.\u00a0 Currently I am building an Ivanti Identity Director environment. Part of onboaring a new employee in this environment is enabling Skype for this new AD account.<\/p>\n

<\/p>\n

To perform this task in Powershell I wrote the following script, which I execute in Ivanti Automation.<\/p>\n

\n
[sourcecode language='powershell'  padlinenumbers='true']\n##################################\n # Enable Sykpe User\n ##################################\n # Created by R. Plomp 20-6-2019\n # Version 1.0\n ##################################\n\n$SAM = $[UserLogonName]\n $SMTP = $[Primary E-mail address]\n $SIP = sip:+$SMTP\n $Pool = $[RegistrarPool]\n\n# Import Skype for Business Module\n Import-Module C:\\Program Files\\Common Files\\Skype for Business Server 2015\\Modules\\SkypeForBusiness\\SkypeForBusiness.psd1\n\n# Enable Skype\nIf (Get-CsUser -Identity $SMTP -ErrorAction SilentlyContinue)\n     {\n     Write-Host Skype User does exists\n     }\n Else\n     {\n     Enable-CsUser -Identity $SMTP -SipAddress $SIP -RegistrarPool $Pool\n     Write-Host Skype User created\n     }\n[\/sourcecode]<\/pre>\n<\/div>\n
When I ran this script with my standard Ivanti Admin account I received the following error:<\/p>\n
Error<\/u><\/b>:<\/b> Enable-CsUser : Cannot open database “xds” requested by the login. The login failed. Login failed for user ‘…’.<\/span><\/p>\n
The user mentioned in the error message is the Ivanti Admin that I use the execute all tasks within Ivanti Automation.
\nWhile researching this error I came to the following solution, the Ivanti Admin account should me a member of the CsAdministrator<\/em>, and the RTCUniversalServerAdministrator <\/em>AD Group.<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
If you read the blog before you should know that I am a big fan of automating repetitive admin tasks.\u00a0 Currently I am building an Ivanti Identity Director environment. Part of onboaring a new employee in this environment is enabling Skype for this new AD account.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,14,31],"tags":[],"class_list":["post-202","post","type-post","status-publish","format-standard","hentry","category-ivanti-automation","category-powershell","category-skype"],"_links":{"self":[{"href":"https:\/\/robinplomp.com\/index.php?rest_route=\/wp\/v2\/posts\/202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/robinplomp.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/robinplomp.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/robinplomp.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/robinplomp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=202"}],"version-history":[{"count":2,"href":"https:\/\/robinplomp.com\/index.php?rest_route=\/wp\/v2\/posts\/202\/revisions"}],"predecessor-version":[{"id":205,"href":"https:\/\/robinplomp.com\/index.php?rest_route=\/wp\/v2\/posts\/202\/revisions\/205"}],"wp:attachment":[{"href":"https:\/\/robinplomp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/robinplomp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=202"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/robinplomp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}