User Profile
PhilFancyAndMe
Iron Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Azure Web App - Connect to Azure Managed Instance SQL DB
Hi there, need ideas how to let a Azure Web App connect to a Azure SQL DB (managed by Azure Managed Instance). Web App has public network access but no private endpoint: SQL Managed Instance is added to Azure virtual network/subnet. So, Web App is facing to the internet only. SQL Server is connected to the internal network only. Web App cannot connect to sql instance. I tried to create a private endpoint on the managed instance to get it work. But without success. As I am not too deep into the networking part of Azure I hoped to get help how to approach this. I need to be able to connect the web app to the managed instance. Just creating a private endpoint on the Web App ressource shows a warning that this undermines security. So I am looking for a secure way how to achieve connection from Web App to SQL instance/database. Thanks in advance. Additional information: The sql instance and databases are reachable from in Azure running virtual machines that have network adapters in the virtual network where the sql server is running. It's only the web app that is not able to connect (most likely because of missing internal network connection). Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - An attempt was made to access a socket in a way forbidden by its access permissions.) ---> System.ComponentModel.Win32Exception (10013): An attempt was made to access a socket in a way forbidden by its access permissions.Self Service Password Reset without being forced to have MFA enabled
We have enrolled MFA for parts of our company (Guests, IT department, parts of the administration) so far and are slowly pushing forward. MFA is controlled by a Conditional Access policy where users or groups are added manually. At the same time we are currently implementing SSPR for our company. SSPR is set to "selected" and not to "all". That means we have a group where we add users to get SSPR enabled for them. This is how it is set up: If we enable SSPR for a user that has not being enabled for MFA by conditional access yet then this user is facing issues to set up his Self Service Password Reset questions. He is forced to register MFA what we do not want at this point (that is why we have not added him to the MFA Conditional Access policy at this point). Is there a way to make the users register SSPR for their account but not being forced to register MFA yet?Is it even possible to enable SSPR without MFA? We know that MFA is highly recommended. We are working on the full rollout. But there are users that are not ready yet. This is what the user is facing when SSPR is enabled for him but MFA is not yet enforced by conditional access: Says: Protect your account. Microsoft Authenticator. Get the app first.Provide Company Contacts in Teams (for Teams Phone)
Is there a way to provide centralized contacts for the whole company in Microsoft Teams? This could be such phone numbers like non-Teams landline phones somewhere in the facility or important external PSTN contacts. If there was no "centralized" way to do this maybe there is a workaround like creating users with this line phone numbers attached in Entra ID or something like that? Thanks.SharePoint Online Custom Search on OnPrem SQL Server
Hi, within our SharePoint 2016 on prem environment we connected local SQL servers via BCS then added a search content source for that and used custom search templates to visualize this SQL data in SharePoint search. Recently Microsoft provided PnP Search Web Parts Version 4.0 after they showed how to use custom search in SharePoint Onlinein 2020. As it is possible to use BCS with Azure SQL in SPO as well, I see a way how to show SQL based data in modern SharePoint sites. As the data I want to use in on prem and I have no chance of getting them to Azure I wonder if it was possible to connect External Content Type in SharePoint Online to local SQL over the "On Premises Data Gateway" that Power Bi and Power Apps use easily. Or do you see another way of getting lots of local SQL data to be shown in modern SharePoint Search? Would be pleased to hear your opinion about how to do that or if it was possible. Thanks in advance! PhilippSearch for "Office Location" in M365 - shows up in Delve
Lots of our users have set their office location (property physicalDeliveryOfficeName in Active Directory) and/or Microsoft Delve profile. See red mark: This shows up fine in any Delve profile. Is there any way to see this in other locations than the delve profile? (Teams or SharePoint maybe?) Is there any way to search this property? Delve is a product that exists somewhere in the M365 universe. It is not a product that is used by the majority of our users. So the office location which is important for us (lots of branches) is something the users would like to see and search.Searchable App/List with 65000 Contacts - Power Apps? SharePoint? something else?
Hi, we got a contact search with 65000+ contacts in a SQL table that can be searched on SharePoint 2016 on premise search. This works fine. As we have switched to modern SharePoint Online, Teams, Lists and stuff we would like to get rid of the SharePoint 2016 on premise search. Therefore I need to enable the users to search this database in the modern world. The SQL table in on Azure. Items in this contact list are kept up to date from SAP data every night. Microsoft E3 plans are standard. What could be a way to achieve this? PowerApps? Has limitations when searching. As far as I experienced this limit is 2000 items - not suitable for my problem? Microsoft Lists? Views in SharePoint lists have 50k item theshold (as far as I experienced). In addition Lists would have problems to keep the list up to date as the contact data is from SAP and changes every day - at least some of the items. Has anyone an idea how to solve my problem? Maybe again some search driven solution? Thanks in advance! PhilippGPO RestoreOnStartup not working - shows edge://apps/
We are preparing to roll out the brand new Edge Chromium. Therefore we have created a GPO that works pretty well except of one thing - we are not able to set the URL for the site to load on startup. The policy for RestoreOnStartup and RestoreOnStartupURLs is loading correctly from GPO toedge://policy/. But if you hitedge://settings/onStartup the page URL to start with Edge is set to "edge://apps". This is annoying. Has anyone experienced this behavior and has a solution? Version 80.0.361.32 (Official build) beta (64-bit) Version 81.0.389.2 (Offizielles Build) dev (64-Bit) Version 79.0.309.65 (Offizielles Build) (64-Bit)Cannot Login with Office 365 Work Account to Edge Profile
I got a user that is not able to login to Edge with his Office 365 work account. Current build is "Version 80.0.334.2 (Offizielles Build) dev (64-Bit)" but he has this issue since we tried with the official release candidate approx. 2 weeks ago. We tried to uninstall Edge and reinstall it with different versions. We cleared all AppData files related to Edge after uninstall. All versions seem to have this issue related to this user. For screenshot see attached file. Translated to English it means something like "Action required" - "Hmm... we got problems validating your account". When I create a second profile and try to log in with my account it works fine. Seems to be account related. The account of that user is Azure AD based and has full Office 365 E3 license. The account works fine with all O365 services. He can login to portal.office.com within edge without any issues. It is just the profile in edge that seems to hate his user. Any ideas? OS is Windows 7 at this point.
