User Profile
StigJ
Copper Contributor
Joined Feb 05, 2020
User Widgets
Recent Discussions
Re: Analysis Server Roles from Entra workstation
Hi, many thanks for the reply. Good to get confirmed that it is not just us that have this issue. We did indeed end up by creating a hybrid joined machine to work around the issue. Not ideal, but.... Strange thing is that the quick fix do not work for us. And in Visual Studio Data Tools it will not even open the dialog window when clicking Add in Membership. But I guess that is another issue. We do have the workaround now.51Views1like0CommentsAnalysis Server Roles from Entra workstation
We have Analysis Server solution, maintained and deployed from Visual Studio, where the roles defined use AD groups. This worked perfectly as long as long as the machine used was on the same domain as the groups or was hybrid joined. On a new laptop that is Entra-only joined we do see a curious issue. The AD where the groups are located is a fully trusted domain. In SSMS (version 20.2) we now see this behavior in the Object Explorer: Connect to SQL Server Database Engine On-premise server A Navigate to Security -> Logins -> Right-click and select New Login Click on Search Click on Locations Full list of available domains to search is available Connect to SQL Analysis Services On-premise server A (so the same server) Navigate to Databases -> {Database name} -> Roles -> Right-click and select New Role Click on Membership and Add Click on Locations Only the local computer is available This prevents us from creating new roles with an AD group membership. Please note that everything else is working fine. Browsing as another AD user in any way works perfectly. Any ideas to why it behaves differently when connecting to database engine versus analysis services or what we can do to resolve this issue? PS! We see similar issues in Visual Studio if we try to edit roles in a Analysis Services Project. The assumption is that these both rely on the same underlying services to lookup objects on the AD domain. Thus if we resolve the SMSS issue we hope that also resolves the VS AS project issue. Regards, StigSolved132Views0likes2CommentsRe: New Edge: How to unblock specific file types in specific locations
Deleted Many thanks for the responses to this. It is now clear that the correct way forward would be to set a group policies for those sites that we internally deem safe. And if not the workaround provided by Eric_Lawrence is the best option. Thanks and have a nice day, Stig9.7KViews1like4CommentsNew Edge: How to unblock specific file types in specific locations
Just installed the new Edge browser and so far I am very, very happy with it. It seems faster and more reliable (couple of hiccups) than most other browsers and it does not use GBs of memory. It takes time to learn of course and set the correct policies. One thing that is very important for us is to be able to open specific log-files in txt-format from specific locations. We have a web page that contains the links to this so that our IT users can quickly open the necessary log-file. Some of these are checked every morning. At the moment Edge just blocks the file://{server}/{share}/{folder}/{filename}.txt (even though you can use file://{server}/{share}/{folder} and then open the file from the list of files in that folder. I have studied all the available policies for Edge, but I cannot find the right one for unblocking this. Is this at all possible and if so how? Thanks and regards, StigSolved10KViews0likes9Comments
Recent Blog Articles
No content to show