2019
161 TopicsCatch Error in a SQL Server Logon Trigger
I have written a Logon trigger in a SQL Server to control logon authorization. ALTER TRIGGER [LOG_TRG_01] ON ALL SERVER WITH EXECUTE AS 'SA' FOR LOGON AS BEGIN if ORIGINAL_LOGIN() = 'sa' begin return; end; if ORIGINAL_LOGIN() = 'OMEGACAEVDEV1' begin -- not allowed to logon rollback; end; -- Insert Trail EXEC [OmegaCoreAudit].[OMEGACA].[P_ACC_UNF_TRAIL] 0, 'trail_details', 'ip', 'server', 'db', 0 ; END GO It does (as expected): OMEGACAEVDEV1 is not allowed to logon OMEGACAEVDEV2 is allowed to logon An audit event is inserted by proc P_ACC_UNF_TRAIL in a table for both users. All three above I want to stay this way ! But I need to have error handling in it, so that in case of whatever error the login is allowed to login - but keeping a record on another table named SYS_ERROR_LOG (with error details). In this trigger I have intentionally provoked an error by "select 10/0" The new trigger is: ALTER TRIGGER [LOG_TRG_02] ON ALL SERVER WITH EXECUTE AS 'SA' FOR LOGON AS BEGIN BEGIN TRY if ORIGINAL_LOGIN() = 'sa' begin return; end; --provoke error select 10/0; if ORIGINAL_LOGIN() = 'OMEGACAEVDEV1' begin -- not allowed to logon rollback; end; -- Insert Trail EXEC [OmegaCoreAudit].[OMEGACA].[P_ACC_UNF_TRAIL] 0, 'trail_details', 'ip', 'server', 'db', 0 ; END TRY BEGIN CATCH Insert into OmegaCoreAudit.OMEGACA.SYS_ERROR_LOG ([LOGIN_USER_NAME], [DB_USER_NAME], [USERHOST], [IP_ADDRESS], [OS_USER], [BG_JOB_ID], [ERROR_DATA]) values ('LOGIN_NAME', 'USER_NAME', 'USER_HOST', 'IP', NULL, NULL, 'ERROR_MESSAGE'); END CATCH END GO In the above code "if ORIGINAL_LOGIN() = 'OMEGACAEVDEV1'" represents a simplified version of a wider authorization process. Problem: CATCH is not working. Both users are not allowed to logon ("Logon failed for login '[user]' due to trigger execution") No record is written on table SYS_ERROR_LOG. I was expecting one for each user. What can I do to fix this problem? best regards AltinSolved146Views0likes13CommentsExchange Server 2019 HA & DR - Design
Hello Team, I'm asked to setup a HA & DR of Exchange Server 2019 (In-House) with only Internal Clients connecting to it. There will be no Internet or external access. There are 2 Sites, A & B connected by Dark Fibre of 10G and though users are around 3000 but their usage is very minimum as it is only for internal purposes. They are keen to have HA & DR and in current setup I had setup HA with 3 servers. I was reading about cross-site DAG and need little assistance in setting up the same. I need to design HA & DR so that if there is a site failure then automatically the DR should continue the work. I thought Active-Active would be best because if anyone of the site fails, say Site A fails, the 40-50% of the users who would have their mailboxes on them would move to Site B. 1. Is it best to setup Active-Active or Active-Passive, benefits, safety, Administrator's Tasks in failover scenario? 2. Is it better to keep even nodes on each side with Witness Server (for Site A - Witness Server will be on B) & Alternate Witness Server ? If anyone has a sample design document with key configuration to keep in mind, if you can share it, please let me know,70Views0likes3CommentsCVE-2024-49040: Mitigating a Critical Microsoft Exchange Server Vulnerability
CVE-2024-49040 is a spoofing vulnerability identified in Microsoft Exchange Server versions 2016 and 2019. This flaw allows attackers to forge legitimate sender addresses on incoming emails, potentially making malicious messages appear trustworthy. The vulnerability arises from improper verification of the P2 FROM header during email transport, permitting non-RFC 5322 compliant headers to pass through and be displayed as legitimate by email clients like Microsoft Outlook. Recommended Mitigation Steps To protect your organization from this vulnerability, consider the following steps: Apply Security Patches: Enhance Email Security: Educate Users: Implement Strong Password Policies: Monitor Network Traffic: By taking these steps, organizations can significantly reduce the risk of exploitation and protect their sensitive data. It is essential to stay informed about the latest security threats and to adopt a proactive approach to cybersecurity. These patches are available in WSUS. If the concerned team has not yet synchronized, please proceed with the synchronization and apply the latest patches. Alternatively, you can find these patches on the official Note: These patches are applicable for the following Exchange versions: Microsoft Exchange Server 2016 Cumulative Update 23 Microsoft Exchange Server 2019 Cumulative Update 14 Microsoft Exchange Server 2019 Cumulative Update 132.5KViews0likes2CommentsExchange 2019 Event ID 9042 - File Extraction Time Based Assistant skipps mailbox
Hello everyone! We only have 3 mailboxes left in our Exchange Server 2019 on-premises, the rest was already migrated to Exchange Online (we have a hybrid environment). We cannot move the other mailboxes at the moment. Since a couple of days however we receive the following warning message in the event log of our Exchange Server: Event-ID: 9042 (MSExchange Assistants) "Service MSExchangeMailboxAssistants. File Extraction Time Based Assistant for database <dbname> (<db id>) is exiting a work cycle. No mailboxes were successfully processed. 1 mailboxes were skipped due to errors. 0 mailboxes were skipped due to failure to open a store session. 0 mailboxes were retried. There are 0 mailboxes in this database remaining to be processed." Unfortunately, that's all the error messages we receive and I have no clue how to find out which mailbox is skipped. Or why... How can we find out which mailbox is causing the problem? How can we then solve it? Many thanks! Best regards, MarkusSolved344Views0likes10CommentsMicrosoft Office 2019 Now Available – Comparing 2019 vs 2016 vs 365, New Features in Access & Excel
Microsoft Office 2019 is out! Microsoft started the roll-out today of Microsoft Office 2019 for Windows & Mac – with major updates to Access, Excel, Word, PowerPoint, Outlook, Project, Visio, and Publisher – to commercial volume license customers. Microsoft is following up with Office 2019 releases to consumers and other business customers, as well as SharePoint / Exchange / Skype / Project Server 2019 releases, in the coming weeks. Office 2019 provides a subset of features Microsoft has added to Office 365 over the past three years. As Office 2019 is a one-time release, Office 365 is still the better choice with not only far more features (Co-Authoring, etc) unavailable in Office 2019, but also far earlier access to them than on-premises, non-subscription Office 2019, etc. editions. Speculation has been that Office 2019 may be the last perpetual license (on-premises / non-subscription) release of Office, so that Microsoft can focus in on its Office 365 subscription offerings. However, Microsoft has responded in one case that there is likely to be one more perpetual license release after this one. Either way, Microsoft Office 2019 product pages even describe Office 2019 as a "one-time release" with Office 365 being needed to gain access to new features after that. It may also be that there are fewer editions available for Office 2019 than for Office 2016. Whether you move to Office 2019 or 365, it's suggested you don't delay doing so, as Office 2016 cloud support will be dropped in 2020, with Office 2016 installs barred from connecting to Microsoft's cloud-based services, including hosted email (Exchange) and online storage (OneDrive for Business), after Oct. 13, 2020. New in Office 2019 Word– text-to-speech, improved inking & accessibility, focus mode, translator, Learning tools (captions & audio descriptions), @ Mentions PowerPoint – Morph transitions, Zoom, SVG, 3D model, play in-click sequence, 4k video, @ Mentions Excel – Power Query (Get & Transform) enhancements, Power Pivot included with all editions, new functions & connectors, publish to Power BI, AI-driven Excel Insights for chart suggestions, new charts, @ Mentions Excludes Co-Authoring, new Data Types like Stocks, and some other new features only available in Office 365 Outlook –@ Mentions, Office 365 Groups OneNote – OneNote for Windows 10 (Modern App included with Windows) has replaced OneNote desktop app (though OneNote 2016 will be available via Volume License Install tool) All Office apps – Ribbon customizations and roaming pencil case Microsoft Access - including the many updates we've seen recently such as: Modern Charts New Linked Table Manager Dark theme Big Int Salesforce & Dynamics connectors Other Recent Developments with Microsoft Access It's especially exciting to see all the new features, growing user base and communities, new integrations, and development team responsiveness seen with Microsoft Access of late. Inclusion on the Office templates page Which I hope will become permanent soon SQL Server Migration Assistant (SSMA) updates ODBC and OLE DB driver updates – for optimized use and new feature support for SQL Server, Azure SQL and other back-ends databases Power BI support (via On-Premises Data Gateway) Considering On-Premises Data Gateway is shared with PowerApps, hopefully that means we may see PowerApps support too in the future New & growing Access conferences and user communities: New Access Developers' Day in Amsterdam DevCon in Vienna, AEK in Germany, UKAUG in UK, PAUG in Portland, Access Day in Redmond, Access Madrid in Spain Presence at Microsoft Ignite and other conferences Access User Groups (AUG) webinars and local chapters (Chicago, Denver, Madrid, Hertfordshire, etc.) Access now included in most Office editions Included in nearly all (besides Online-only) editions Access in Office 365 Home, Personal, Business, Business Premium, ProPlus, E3, and E5 editions Access in Office 2016 Professional and ProPlus editions With MS Access having been added to most Office editions, presumably it will likewise be available with most Office 2019 editions now too. It's great to see these features available to Office 365 subscribers (or even sooner if opt-in for Insiders program) now being made available to others with Office 2019, and I look forward to the many more new advancements with Microsoft Access and Office to come. Links to More Info about Office 2019 You can find out more about Office 2019 with the following articles, FAQs and product pages: Office 365 vs. 2019 Editions Office 2019 Commercial FAQ Microsoft's Office 2019 Announcement Office 2019 and Discontinuing of Office 2016 The Verge release article ZDNet release article Endgadget release article VentureBeat release article TechSpot release article -- Dan Moorehead Founder & Chief Software Architect PowerAccess (www.PowerAccess.net) "Empower Microsoft Access – with new Tools | VBA Framework | PowerGit | Power Query-like PowerSQL | VSTO-like .NET API | CodeGen | Excel Formulas & Functions | Consulting | Excel ➜ Access ➜ SQL Conversion Tools"Solved410KViews8likes21CommentsTwo resources changing their base calendar simultaneously
Hi, I'm using Project Professional 2019. I've created some base calendar for all the projects that I have. I have two resources that when I change the base calendar of one of them, the other one is changed too, in a way that I can't choose differents base calendar for this two resource. I don't know if this is a issue or not, maybe someone experienced this and knows what is wrong... Thanks!Solved2KViews0likes9CommentsNeed help creating a template
Hello everyone, I'm new here, but not to Word. Hoping I can get some help with a problem I haven't found a solution for yet. I have some 4" x 6" C-Line photo pages that include some tearable cardstock inserts that you can write on or type on and then insert into the page (this is their product # 52564 if you are interested in seeing yourself). The inserts are on a perforated sheet 7" wide by 10" tall and there are 10 inserts per sheet, only 1 insert wide. I figured I could create a custom label template as follows and use that: When I start a new document using this label template, on screen it looks exactly like the insert sheets: The problem is that I would like to center the text vertically on each "label" before centering it horizontally. Unfortunately, every attempt I have made has been unsuccessful. All text is started at the very top of each insert/"label". I've tried typing out my text and then using Layout>Page Setup>Layout>Page Alignment to center the text, but it simply shifts everything down and prevents the use of the bottom/10th insert: Are my settings correct for the "label" template? Is there a way to set the label template as vertically centered versus top alignment? Should I be looking elsewhere to vertically center any text I type in? Any other advice on how to solve this problem? Greatly appreciated in advance.195Views0likes2CommentsAccess doesn't close properly. A remaining background process can only be terminated in task manager
Since yesterday I noticed that in all my Access databases there is a problem when I close them. When I close a database, it leaves a background process that can only be terminated in Task Manager. Without this, it is not possible to (re)open databases! I have already checked some possible causes. It also concerns databases that I have not changed at all in recent months and that worked fine until this week. Therefore, I have to assume that it is a bug in an automatic update! It seems that it has to do with a malfunction in the deallocation of allocated memory in VBA source code. Did anyone experience the same problem? Are there already fixes or solutions available?Solved88KViews8likes189CommentsExchange System Mailboxes after migration to Exchange 365
Hello all, After the migration off the mailboxes to Exchange 365, there are 2 mailboxes in our on-premise environment: extest + DiscoverySearchMailbox. Because of this 2 mailboxes, the Exchange server has the 'Mailbox Server'-role. I think this is not neccesarry. I don't understand why this 2 mailboxes are counted as normal mailbox, because other system mailboxes aren't and also not visible. Does anyone know what the function is off this mailboxes? Kind regards, Arjan5.5KViews0likes10Comments