Category: Microsoft
Category Archives: Microsoft
SQL Report Server URL Access
I am using the SQL Report server URL to access the report which I created using SSRS.
When I run the URL, it prompt me to enter username and password of the Window Server where the SQL Report Server is residing. Is it possible to bypass the prompt or embedding the username and password into the url
Report URL as below
https://serverIP/ReportServer/Pages/ReportViewer.aspx?%2fIALM%20Reports/ALM%20Team%20Effort%20Time%20Lapse&rs:Command=Render
Report URL with username and password like
https://serverIP/ReportServer/Pages/ReportViewer.aspx?%2fIALM%20Reports/ALM%20Team%20Effort%20Time%20Lapse&rs:Command=Render&username=abcdef&password=password
I am using the SQL Report server URL to access the report which I created using SSRS.When I run the URL, it prompt me to enter username and password of the Window Server where the SQL Report Server is residing. Is it possible to bypass the prompt or embedding the username and password into the urlReport URL as belowhttps://serverIP/ReportServer/Pages/ReportViewer.aspx?%2fIALM%20Reports/ALM%20Team%20Effort%20Time%20Lapse&rs:Command=RenderReport URL with username and password likehttps://serverIP/ReportServer/Pages/ReportViewer.aspx?%2fIALM%20Reports/ALM%20Team%20Effort%20Time%20Lapse&rs:Command=Render&username=abcdef&password=password Read More
Outlook Login Error
I cannot login to my outlook account with the following error reported, but I stay as login status for my Microsoft account. Once I accidentally logged in to outlook successfully, but I still could not access any email nor sending any email. There’s some bug needs to be fixed.
I cannot login to my outlook account with the following error reported, but I stay as login status for my Microsoft account. Once I accidentally logged in to outlook successfully, but I still could not access any email nor sending any email. There’s some bug needs to be fixed. Read More
Workspace Feature Enhancement Suggestion: One-Click Bookmarking for Entire Tab Groups
Hello Edge development team,
Can you add a right-click menu option for workspaces called “Add to Favorites”?
Here’s why:
Sometimes my computer’s low on memory, and I want to bookmark a bunch of tabs, close the workspace, and check them out later.When I need to restart my computer, I don’t want to lose what I’m working on.Right now, I can’t save workspaces directly, which is kind of inconvenient.
Basically, I’m hoping for a one-click option to save the entire workspace, instead of bookmarking tabs one by one. It would make things a lot smoother.
What do you think of this idea? If you could add it, that’d be really handy.
Thanks!
Hello Edge development team,Can you add a right-click menu option for workspaces called “Add to Favorites”?Here’s why:Sometimes my computer’s low on memory, and I want to bookmark a bunch of tabs, close the workspace, and check them out later.When I need to restart my computer, I don’t want to lose what I’m working on.Right now, I can’t save workspaces directly, which is kind of inconvenient.Basically, I’m hoping for a one-click option to save the entire workspace, instead of bookmarking tabs one by one. It would make things a lot smoother.What do you think of this idea? If you could add it, that’d be really handy.Thanks! Read More
Expected output of supervisors
suggested outputs of supervisors to Model exemplary skills on evidence-based approaches in the evaluation of programs, projects and activities aligned with the educational development plan.
suggested outputs of supervisors to Model exemplary skills on evidence-based approaches in the evaluation of programs, projects and activities aligned with the educational development plan. Read More
Secure the approval data inside sharepoint list
We have a SharePoint list named Contracts, with these main fields:-
1) ID
2) Title
3) Number
4) Approval Status
now we granted our Operation employees + Operation managers Contribute permission on the list. then we build Power Apps that will only show the “Approval Status” field in-case you are inside the Operation Managers Teams. this will work if we guarantee that users will only use power apps, and will not modify the list using REST API or SharePoint list view UI. so to secure this process (make sure that only Operation Managers can modify the Status field), we found 2 approaches:-
1) Separate the Contract list into 2 lists, one for the contract info , while the other for the approval info. and grant the Operation team contribute on the first list and read-only on the second list. while the operation manager will have contribute on the 2 lists. this will secure the back-end.
2) second approach, is to have one contract list and set all users to have Read-Only permission, then interact with the list from power apps using a power automate flow that get called from power apps, and which runs using a service account:-
in this case we can define the business rules inside the power automate flow, and make sure that you can not modify the “Approval Status” field unless you are inside the Operation Managers group.
so my question is which appraoch to follow and why?
Thanks
We have a SharePoint list named Contracts, with these main fields:- 1) ID2) Title3) Number4) Approval Status now we granted our Operation employees + Operation managers Contribute permission on the list. then we build Power Apps that will only show the “Approval Status” field in-case you are inside the Operation Managers Teams. this will work if we guarantee that users will only use power apps, and will not modify the list using REST API or SharePoint list view UI. so to secure this process (make sure that only Operation Managers can modify the Status field), we found 2 approaches:- 1) Separate the Contract list into 2 lists, one for the contract info , while the other for the approval info. and grant the Operation team contribute on the first list and read-only on the second list. while the operation manager will have contribute on the 2 lists. this will secure the back-end. 2) second approach, is to have one contract list and set all users to have Read-Only permission, then interact with the list from power apps using a power automate flow that get called from power apps, and which runs using a service account:- in this case we can define the business rules inside the power automate flow, and make sure that you can not modify the “Approval Status” field unless you are inside the Operation Managers group. so my question is which appraoch to follow and why? Thanks Read More
Microsoft Mesh 2408 is now available
Microsoft Mesh became generally available on Jan 24 and updates frequently. Microsoft Mesh 2408 is now available in the Microsoft and Quest app stores.
Want to make your virtual events immersive? Try Microsoft Mesh, a 3D experience that lets you take your Teams avatar and walk around a virtual space either in Teams or in an app from the Microsoft Store. For more information, see www.mesh.com. Microsoft Mesh became generally available on Jan 24 and updates frequently. Microsoft Mesh 2408 is now available in the Microsoft and Quest app stores.
For more info, see Release notes for Mesh – Microsoft Mesh | Microsoft Learn
If your Mesh Windows app hasn’t updated automatically yet, open the Microsoft Store app, click Library and then click Get updates. Read More
Can removal of certain rows be automated?
Hi,
I will be getting an Excel file with some 1000 rows and 10 columns. The rows that have a value of N1 in column F and a value of N2 or N3 in column H should be removed (predicted outcome: about half the rows will remain). Can that be automated and if so, how?
Please note that I have only basic working knowledge of Excel and none of Macros if applicable, so please explain step by clear step. Thanx in advance.
Hi, I will be getting an Excel file with some 1000 rows and 10 columns. The rows that have a value of N1 in column F and a value of N2 or N3 in column H should be removed (predicted outcome: about half the rows will remain). Can that be automated and if so, how? Please note that I have only basic working knowledge of Excel and none of Macros if applicable, so please explain step by clear step. Thanx in advance. Read More
Canary crashing
I noticed a short while ago that Edge Canary had disappeared. So….. I reopened it and sure enough, a couple of minutes later it crashed. Did the cursory repair and still have the issue. Has anyone else seen this. Just started today.
I noticed a short while ago that Edge Canary had disappeared. So….. I reopened it and sure enough, a couple of minutes later it crashed. Did the cursory repair and still have the issue. Has anyone else seen this. Just started today. Version 128.0.2689.0 (Official build) canary (64-bit) Read More
Microsoft Teams in Windows 365 and Azure Virtual Desktop
We are excited to announce the public preview of the new optimization architecture for Microsoft Teams on Azure Virtual Desktop and Windows 365 is now rolled out for all users. This new architecture is designed to close the feature gap between native Teams and Teams for Virtual Desktop Infrastructure (VDI) by enhancing performance, providing auto updates, and streamlining support.
The new architecture introduces several key improvements over the existing optimization. A new client-side plug-in is responsible for establishing a virtual channel with Teams on the server and subsequently handling media engine downloads. Once the plug-in is deployed, Teams will send instructions for the specific media engine version it requires, and the plug-in will handle the rest. SlimCore, the new media engine, replaces WebRTC and offers the same quality and reliability you experience in the native Teams client for Windows. SlimCore is responsible for interactive connectivity establishment for STUN and TURN procedures, real-time media using Secure Real-time Transport Protocol (SRTP), and signaling through UDP or HTTPS.
The new optimization architecture supports a range of new features, including advanced meeting capabilities, telephony and voice capabilities, location-based routing and media bypass, quality of service, and improved supportability, as outlined in the table below.
Advanced meeting capabilities
Gallery view 3×3 and 7×7
Custom meeting backgrounds uploaded via Teams admin center
List item 3
1080p
Computer sound while screen sharing
Hardware acceleration on the endpoint
Presenter mode
Teams Premium*
Telephony and voice capabilities
Location-based routing and media bypass
Quality of Service (QoS)
Human Interface Device (HID)
Noise suppression
Better supportability
Teams admin center
Call Quality Dashboard
* For a full list of Teams Premium features that are supported/unsupported, please check out our official documentation.
For more information on the new optimization architecture and how to enable it, see New VDI solution for Teams and the Microsoft Teams blog.
Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X and on LinkedIn. Looking for support? Visit Windows on Microsoft Q&A.
Microsoft Tech Community – Latest Blogs –Read More
Sorry you don’t have access
Hello
Please i need your help on this issue.
I am the owner of our Recruitment Agency and related domains and services.
When I try to access the MS365 Admin portal I get the error that says”
“Sorry, you don’t have access to this app. The Microsoft Teams Admin Center allows admins to manage teams and Microsoft 365 for their organization, and only people with specific admin roles can access it. If you use a different user account for admin work, try switching accounts: Select the profile picture at the top of teams to switch.
In addition, I should be the sole admin for this as well as the MS Teams application.
Hello Please i need your help on this issue. I am the owner of our Recruitment Agency and related domains and services.When I try to access the MS365 Admin portal I get the error that says”“Sorry, you don’t have access to this app. The Microsoft Teams Admin Center allows admins to manage teams and Microsoft 365 for their organization, and only people with specific admin roles can access it. If you use a different user account for admin work, try switching accounts: Select the profile picture at the top of teams to switch. In addition, I should be the sole admin for this as well as the MS Teams application. Read More
X Lookup vs Index Match
Is there a situation in which X Lookup or Index Match are better than the other?
Is there a situation in which X Lookup or Index Match are better than the other? Read More
Microsoft Mesh 2408 is now available in the Microsoft and Quest app stores.
You can now have 5 broadcasters instead of 3
Event organizers in the Host room can see profile bubbles of attendees sending emojis or raising hands. Also, organizers can call on the handraisers by clicking the avatar or profile bubble.
Add text directly to your event like other objects (screenshare, image, videos)
Microsoft Mesh 2408 is now available in the Microsoft and Quest app stores.
Highlights:
You can now have 5 broadcasters instead of 3
Event organizers in the Host room can see profile bubbles of attendees sending emojis or raising hands. Also, organizers can call on the handraisers by clicking the avatar or profile bubble.
Add text directly to your event like other objects (screenshare, image, videos)
For more info, see Release notes for Mesh – Microsoft Mesh | Microsoft Learn
If your Mesh Windows app hasn’t updated automatically yet, open the Microsoft Store app, click Library and then click Get updates. Read More
Work feed feature not available
Hello there,
As an immediate help, if I’m not posting in the right platform, please let me know… Thanks.
I am a freelance and working with few customers (Microsoft tenants).
I am using 3 Work profiles synced to Microsoft 365 accounts) and 1 Personal profile (synced to my personal Microsoft account).
I used to be able to see the “Work feed” whenever I opened a new tab in Edge. I am 99% sure I managed to that without connecting/registering my device to any of my Microsoft 365 accounts. I say that because since I once did that by mistake, I was forced to change my Windows Hello PIN to 6 digits instead of 4, and some other organizational policies. I disconnected my device from that organization, and since then – every time I am signing in a Microsoft 365 account in one of my desktop apps (Outlook, Edge, Office etc.) I pay a lot of attention to choose “Only for this app” to avoid the registering of my device.
A week ago, I had to re-install Windows 11 on my device, and, as part of this, to reinstall Edge. After syncing my profiles to the different Microsoft 365 accounts, I can no longer see the Work feed, and clicking on the app launcher result in a “Something went wrong” error message. If I type one of the 365 suite apps’ URL (say https://outlook.office.com/mail), I’m taken to the app homepage and with SSO I’m automatically logged in the service. This shows you I am logged in to my account.
Reading this (“Make sure you’re signed in to your Windows device with your work or school user ID”), I understand my device should indeed be signed in this work account, but:
Signing in my device to this account automatically register it to their organization, which I want to avoid.As mentioned, I am pretty sure I was able to achieve this in the past without the need to do that.
Can anyone help me solve this issue?
I am using the latest public version of Edge and Windows 11 (as mentioned, I have just reinstalled Windows).
Hello there, As an immediate help, if I’m not posting in the right platform, please let me know… Thanks. I am a freelance and working with few customers (Microsoft tenants).I am using 3 Work profiles synced to Microsoft 365 accounts) and 1 Personal profile (synced to my personal Microsoft account). I used to be able to see the “Work feed” whenever I opened a new tab in Edge. I am 99% sure I managed to that without connecting/registering my device to any of my Microsoft 365 accounts. I say that because since I once did that by mistake, I was forced to change my Windows Hello PIN to 6 digits instead of 4, and some other organizational policies. I disconnected my device from that organization, and since then – every time I am signing in a Microsoft 365 account in one of my desktop apps (Outlook, Edge, Office etc.) I pay a lot of attention to choose “Only for this app” to avoid the registering of my device. A week ago, I had to re-install Windows 11 on my device, and, as part of this, to reinstall Edge. After syncing my profiles to the different Microsoft 365 accounts, I can no longer see the Work feed, and clicking on the app launcher result in a “Something went wrong” error message. If I type one of the 365 suite apps’ URL (say https://outlook.office.com/mail), I’m taken to the app homepage and with SSO I’m automatically logged in the service. This shows you I am logged in to my account. Reading this (“Make sure you’re signed in to your Windows device with your work or school user ID”), I understand my device should indeed be signed in this work account, but:Signing in my device to this account automatically register it to their organization, which I want to avoid.As mentioned, I am pretty sure I was able to achieve this in the past without the need to do that.Can anyone help me solve this issue?@RickTurner I am using the latest public version of Edge and Windows 11 (as mentioned, I have just reinstalled Windows). Read More
What is wrong with the following equation?
I can’t get the following formula to work
=FORECAST.LINEAR(L20,{XLOOKUP(L20,B26:B30,B26:B30,,-1),XLOOKUP(L20,B26:B30,B26:B30,,1)},{XLOOKUP(L20,B26:B30,D26:D30,,-1),XLOOKUP(L20,B26:B30,D26:D30,,1)})
I can’t get the following formula to work =FORECAST.LINEAR(L20,{XLOOKUP(L20,B26:B30,B26:B30,,-1),XLOOKUP(L20,B26:B30,B26:B30,,1)},{XLOOKUP(L20,B26:B30,D26:D30,,-1),XLOOKUP(L20,B26:B30,D26:D30,,1)}) Read More
PDF highlighter cursor is difficult to see
I regularly have to highlight PDFs that have been scanned in with light grey backgrounds. When I select the highlighter, the mouse cursor is very difficult to see and sometimes impossible. Sometimes I have to click and throw some highlight on the page just to see where the cursor is.
Maybe make it customizable or automatically contrast from the background color.
I regularly have to highlight PDFs that have been scanned in with light grey backgrounds. When I select the highlighter, the mouse cursor is very difficult to see and sometimes impossible. Sometimes I have to click and throw some highlight on the page just to see where the cursor is. Maybe make it customizable or automatically contrast from the background color. Read More
New Blog | Microsoft Entra certificate-based authentication enhancements
By Alex Weinert
Howdy, folks! Today I’m excited to share the latest enhancements for Microsoft Entra certificate-based authentication (CBA). CBA is a phishing-resistant, password less, and convenient way to authenticate users with X.509 certificates, such as PIV/CAC cards, without relying on on-premises federation infrastructure, such as Active Directory Federated Service (AD FS). CBA is particularly critical for federal government organizations that are already using PIV/CAC cards and are looking to comply with Executive Order 14028, which requires phishing-resistant authentication.
Today we’re announcing the general availability of many improvements we introduced earlier this year – username bindings, affinity bindings, policy rules, and advanced CBA options in Conditional Access are all GA! I am also excited to announce the public preview of an exciting new capability – issuer hints. The issuer hints feature greatly improves user experience by helping users to easily identify the right certificate for authentication.
Vimala Ranganathan, Principal Product Manager on Microsoft Entra, will now walk you through these new features that will help you in your journey toward phishing-resistant multifactor authentication (MFA).
Thanks, and please let us know your thoughts!
Alex Weinert
–
Hello everyone,
I’m Vimala from the Microsoft Entra PM team, and I’m excited to walk you through the new issuer hints feature, as well as the features that will go into general availability.
The issuer hints feature improves user experience by helping users to easily identify the right certificate for authentication. When enabled by tenant admin, Entra will send back Trusted CA Indication as part of the TLS handshake. The trusted Certificate Authority (CA) list will be set to subject of the Certificate Authorities (CAs) uploaded by the tenant in the Entra trust store. The client or native application client will use the hints sent back by server to filter the certificates shown in certificate picker and will show only the client authentication certificates issued by the CAs in the trust store.
Read the full post here: Microsoft Entra certificate-based authentication enhancements
By Alex Weinert
Howdy, folks! Today I’m excited to share the latest enhancements for Microsoft Entra certificate-based authentication (CBA). CBA is a phishing-resistant, password less, and convenient way to authenticate users with X.509 certificates, such as PIV/CAC cards, without relying on on-premises federation infrastructure, such as Active Directory Federated Service (AD FS). CBA is particularly critical for federal government organizations that are already using PIV/CAC cards and are looking to comply with Executive Order 14028, which requires phishing-resistant authentication.
Today we’re announcing the general availability of many improvements we introduced earlier this year – username bindings, affinity bindings, policy rules, and advanced CBA options in Conditional Access are all GA! I am also excited to announce the public preview of an exciting new capability – issuer hints. The issuer hints feature greatly improves user experience by helping users to easily identify the right certificate for authentication.
Vimala Ranganathan, Principal Product Manager on Microsoft Entra, will now walk you through these new features that will help you in your journey toward phishing-resistant multifactor authentication (MFA).
Thanks, and please let us know your thoughts!
Alex Weinert
–
Hello everyone,
I’m Vimala from the Microsoft Entra PM team, and I’m excited to walk you through the new issuer hints feature, as well as the features that will go into general availability.
The issuer hints feature improves user experience by helping users to easily identify the right certificate for authentication. When enabled by tenant admin, Entra will send back Trusted CA Indication as part of the TLS handshake. The trusted Certificate Authority (CA) list will be set to subject of the Certificate Authorities (CAs) uploaded by the tenant in the Entra trust store. The client or native application client will use the hints sent back by server to filter the certificates shown in certificate picker and will show only the client authentication certificates issued by the CAs in the trust store.
Figure 1: Enhanced certificate Picker with issuer hints enabled
Read the full post here: Microsoft Entra certificate-based authentication enhancements Read More
New Blog | Getting Started with Azure WAF REST API for Application Gateway: A Step-by-Step Guide
By David Frazee
REST API plays a pivotal role in the management of resources on Azure, offering a standardized and methodical approach for handling operations such as create, read, update, and delete (CRUD). The use of HTTP methods, such as GET, POST, PUT, and DELETE, in REST API aligns with CRUD operations, making it intuitive for administrators to manipulate resources on Azure. Additionally, REST API supports a range of data formats, including JSON and XML, providing versatility in how data is consumed and transmitted. This is particularly valuable for automating workflows and enabling continuous deployment and integration practices. Focusing on Azure WAF, we’ll examine its REST API integration for configuring rules, monitoring policies, and real-time threat response, vital for maintaining security in fast-paced cloud deployments. This seamless integration not only enhances security but also ensures that the management of security protocols keeps pace with the rapid deployment cycles inherent in modern cloud environments.
Getting Started
In the following examples, we’ll be using Postman to send our REST API requests to Azure Resource Manager to create, update, and delete the Azure WAF policy. There are other methods and tools to send REST APIs outside of Postman, such as PowerShell, Az CLI, Swagger, and more. The basics will be the same regardless of the tool or method used, just our interface will be different. To follow along, check out the prerequisites below to get started.
Prerequisites:
Link to download Postman: Postman API Platform | Sign Up for Free
Link to blog that covers how to prepare your identities and Postman tool to send REST API commands: Azure REST APIs with Postman (2021) | Jon Gallant
If you’re following along and have followed the prerequisites, you should now have your Postman Collection configured to something similar as below. Our first screenshot shows the Authorization tab in the Postman Collection. We’re going to use the Auth Type of Bearer Token and use the variable from our variables tab.
Read the full post here: Getting Started with Azure WAF REST API for Application Gateway: A Step-by-Step Guide
By David Frazee
REST API plays a pivotal role in the management of resources on Azure, offering a standardized and methodical approach for handling operations such as create, read, update, and delete (CRUD). The use of HTTP methods, such as GET, POST, PUT, and DELETE, in REST API aligns with CRUD operations, making it intuitive for administrators to manipulate resources on Azure. Additionally, REST API supports a range of data formats, including JSON and XML, providing versatility in how data is consumed and transmitted. This is particularly valuable for automating workflows and enabling continuous deployment and integration practices. Focusing on Azure WAF, we’ll examine its REST API integration for configuring rules, monitoring policies, and real-time threat response, vital for maintaining security in fast-paced cloud deployments. This seamless integration not only enhances security but also ensures that the management of security protocols keeps pace with the rapid deployment cycles inherent in modern cloud environments.
Getting Started
In the following examples, we’ll be using Postman to send our REST API requests to Azure Resource Manager to create, update, and delete the Azure WAF policy. There are other methods and tools to send REST APIs outside of Postman, such as PowerShell, Az CLI, Swagger, and more. The basics will be the same regardless of the tool or method used, just our interface will be different. To follow along, check out the prerequisites below to get started.
Prerequisites:
Link to download Postman: Postman API Platform | Sign Up for Free
Link to blog that covers how to prepare your identities and Postman tool to send REST API commands: Azure REST APIs with Postman (2021) | Jon Gallant
If you’re following along and have followed the prerequisites, you should now have your Postman Collection configured to something similar as below. Our first screenshot shows the Authorization tab in the Postman Collection. We’re going to use the Auth Type of Bearer Token and use the variable from our variables tab.
Read the full post here: Getting Started with Azure WAF REST API for Application Gateway: A Step-by-Step Guide
Read More
New Blog | Microsoft Defender for Cloud – Monthly news – July 2024
By Yura Lee
Microsoft Defender for Cloud
Monthly news
July 2024 Edition
This is our monthly “What’s new” blog post, summarizing product updates and various new assets we released over the past month. In this edition, we are looking at all the goodness from June 2024.
Read the full post here: Microsoft Defender for Cloud – Monthly news – July 2024
By Yura Lee
Microsoft Defender for Cloud
Monthly news
July 2024 Edition
This is our monthly “What’s new” blog post, summarizing product updates and various new assets we released over the past month. In this edition, we are looking at all the goodness from June 2024.
Read the full post here: Microsoft Defender for Cloud – Monthly news – July 2024 Read More
Copilot for Microsoft 365 Business Standard for Mac
I have a Microsoft 365 Business Standard subscription for my business and I use a MacBook Pro. Does Copilot integrates well on my 365 Business Apps on my Mac?
My very basic understanding is that the difference between the paid version of Copilot and ChatGPT is the integration of GenerativeAI on 365 Applications like Outlook, Teams, Office Suite – which my business use extensively…however, haven’t found anything about how well the integration is on 365 Business running on a Mac.
Would like some clarity on how best to integrate AI into my business now – considering Copilot, ChatGPT and upcoming Apple Intelligence.
Thanks in advance for you all help.
I have a Microsoft 365 Business Standard subscription for my business and I use a MacBook Pro. Does Copilot integrates well on my 365 Business Apps on my Mac? My very basic understanding is that the difference between the paid version of Copilot and ChatGPT is the integration of GenerativeAI on 365 Applications like Outlook, Teams, Office Suite – which my business use extensively…however, haven’t found anything about how well the integration is on 365 Business running on a Mac. Would like some clarity on how best to integrate AI into my business now – considering Copilot, ChatGPT and upcoming Apple Intelligence. Thanks in advance for you all help. Read More
Media Player in Taskbar above Volume Control and Internet Options
I’ve been having trouble finding the setting to turn off the media player shortcut when you click on the internet options & volume control. Does anybody know how to turn this display off?
Thank you plenty in advance!
I’ve been having trouble finding the setting to turn off the media player shortcut when you click on the internet options & volume control. Does anybody know how to turn this display off? Thank you plenty in advance! Read More