Skip to main content

Posts

Showing posts from 2022

[Outlook] Can't add office365 email

If you are not able to add an Office365 account in outlook. You need to clear the Office registry.  Close all office products and rename this registry key:  HKEY_Current_User\Software\Microsoft\Office You will see cleared all outlook profiles. So you can fresh start the setup. Now try to add the Office365 account using Mail in the control panel.  Another thing to check is if you have SSO enabled with an ADsync Server. Check out this article: https://learn.microsoft.com/en-us/azure/active-directory/hybrid/how-to-connect-sso-quick-start Added the site listed in the GPO section to my intranet zone.

[Navision] Wheel is not working in Windows 10, 11

 [Navision] Wheel is not working in Windows 10, 11 Windows - Setting - Type "mouse" will show "mouse setting" and select it Scrolling - Scroll inactive windows when hovering over them This option needs to turn off

[SQL] Navision error user ID can't change

 Navision can get an error with a user ID message.  Then you need to check Navision SQL.  In Navision SQL, the user ID should have master DB access but if you don't have it. then use the below SQL code. USE master EXEC sp_change_users_login 'AUTO_FIX' , 'user ID' example )  USE   master EXEC sp_change_users_login 'AUTO_FIX' , 'T189943' result  row for user 'XXXX' will be fixed by updating its login link to an existing login. The number of orphaned users fixed by updating users was 1. The number of orphaned users fixed by adding new logins and then updating users was 0. The user's DB access will be fixed. And the user ID is updated. If you see the result with 0 to select then your Navision DB might need to check this also.  Check your SQL in Security-Logins, ensure the user ID is there, and check Property to have this "User Mapping" for the Database. It needs your master DB and Navision DB.  After you see the password ...

[Laptop] acer laptop boot takes long time to start. Or stuck in recovery prepare mode

 I upgraded our Acer laptop from Windows 7 to 10. It was successfully installed but during the windows update it has been stuck so I force it to restart and got the blue screen. After that this Acer laptop got very slow and I found it has an HDD drive issue. It was not a physical HDD drive issue. It was related to Acer BIOS. So I changed Acer BIOS from UEFI mode to Legacy Boot mode. Restart the computer and got no boot disc error then I change back to UEFI mode to reboot.  After that BIOS detects HDD and Windows detects HDD again. after that I re-install Windows and it works. 

[Windows 10] Fix Can't Select Windows 10 edition During Installation

I had an Acer laptop to upgrade to Windows 10 Pro edition. But there is no option to select Windows 10 Pro. So you have to make a bootable USB and add a file.  open the note pad and type below.  [EditionID] Professional [Channel] Retail And save as "ei.cfg" with " mark and save as type All Files(*.*)  File location is your USB's sources folder.  And boot with this usb and you will see Windows 10 pro option.

[SQL] & [Navision] user error

Below is the error This can be fix with SQL by running below code.   (08:10) Heetae Kim: EXEC sp_change_users_login 'Auto_Fix', 'L220501'

[SQL DB] Find table in procedure and find column in Table from DB

 1. find procedure  SELECT OBJECT_NAME(object_id),    OBJECT_DEFINITION(object_id)  FROM sys.procedures  WHERE OBJECT_DEFINITION(object_id) LIKE '%Name%' --change Name between %  2. Find Column in Table SELECT T.name AS table_name, C.name AS column_name FROM   sys.tables AS T        INNER JOIN sys.columns AS C ON T.object_id = C.object_id WHERE C.name = 'Column Name' --change 'Column Name' for what you look for

[Program] Visual studio 2019 error

When you have the below error message on programming.  " License error.  The project uses non-licensed premium features.  It is not allowed to enhance types with a total of more than 1000 lines of code in the solution by features not covered by the installed licenses, but 1007 lines of code were enhanced." This was caused using Postsharp. When your program uses postsharp in all your code and if you are using more than1000 times. You will have this error. You need to remove some of the line or purchase licenses from the below link.  https://www.postsharp.net/pricing

[email] Encrypt email AES

 Much important information goes with our email. And when you send it, we can encrypt that email to secure our email. We call it AES(Advanced Email Security),  Encrypt Email, or Secure email.  When you 'add on' this kind of feature to your email system.  Usually, add text '[Encrypt]' on your email subject.  Then Encrypt email will send to the receiver. Every company is using a different method. Please check with your IT dept. 

[SQL] How to determine SQL Server database transaction log usage

  To run this command issue the following in a query window: DBCC SQLPERF(logspace) This is sample output From here we can see the size of the transaction logs as well as how much space is being used.  The current log space used will tell you how much of the transaction log is being used.  If this percentage is high and the size of the log is quite big it is probably due to one of the items listed above.  Getting information about SQL Server virtual logs using DBCC LOGINFO The next command to look at is DBCC LOGINFO. This will give you information about your virtual logs inside your transaction log.  The primary thing to look at here is the Status column.  Since this file is written sequentially and then looped back to the beginning, you want to take a look at where the value of "2" is in the output.  This will tell you what portions of the log are in use and which are not in use Status = 0.  Another thing to keep an eye on is the FSeqNo column. T...