[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 is not matched error to Navision login then you need to update Navision DB to match as below.

Tools - Security - Database Logins -Select a user that has a password issue

Tool - Security - Synchronize Single Login (This will update the user password with SQL)

Comments

[Cisco] command and CDR log backup by FTP (gw-accounting file)

Below command has been tested with ISR4331 devices. 1. check Cisco device file size command : a. show current folder dir flash: b. show all folder and files dir flash 2. check file only start with "cdr." dir flash:cdr.* 3. Remove file (Add option [ /recursive /force] when you delete file is not recovering free space) delete /recursive /force flash:cdr.* 4. check subfolder file dir flash:\tracelogs 5. example for log back to ftp https://www.cisco.com/c/en/us/td/docs/ios/voice/cdr/developer/manual/cdrdev/cdrcsv.html#marker-1163166 enable conf t gw-accounting file primary ftp 192.168.1.51/cisco/cdr username cisco password xxxxx secondary sftp 192.168.1.52/cisco/cdr username cisco password xxxxx acct-template callhistory-detail maximum buffer-size 30 maximum retry-count 3 (note : if these setting is not working. check these area, FTP password can not be used @ and some of special characters for this command. Second, ftp location is case sensitive. Please...

[Cisco Network] connect by serial and usb & setup IP

Accessing the CLI via PuTTY with a Console Connection Step 1. Connect the switch to the computer using a standard 9-pin serial cable. The Cisco DB9 to RJ45 Console Cable also supports console connections, but only if the switch has an RJ45 Console port. An RJ45 Console port resembles an Ethernet port and is labeled CONSOLE on the back of the switch. Newer laptops don’t have Serial ports on them, so in this case you have to use a USB to Serial adapter. When plugging that into a computer it assigns a COM port number to it that is not COM1. If this is the case for you, you need to know where to look to find the correct COM port number when setting up the connection with PuTTY. Right-click on the Windows logo/Start menu and click on Device Manager to open it. In the Device Manager, you would look to see what COM port is given to the USB adapter. In this case you would need to use COM4 for the Serial line to make the connection. Step 2. Open the PuTTY application. The PuT...

vmware esxi 백업

'ESXi'의 버추얼 머신(Virtual Machine)을 옮기려면 백업파일을 받아야 합니다. 'ESXi'에서 버추얼 머신 백업(backup)하면 다운로드할 수 있습니다. 이 방식으로 버추얼 머신을 백업하고 복원하는 방법을 알아봅시다. 실행 중인 버추얼 머신을 정지시키고 진행해야 합니다. 1-1. 웹에서 다운받기 백업받으려는 가상 시스템을 클릭하고 작업 > 내보내기 를 선택합니다. 2-1. 웹에서 복원하기 가상 시스템 > VM 생성/등록 을 선택하고 '생성 유형'을 'OVF 또는 OVA 파일에서 가상 시스템 배포'를 선택합니다. 위에서 다운받은 백업 파일을 넣어줍니다. 이때 넣어줄 파일은 '*.ovf'와 '*.vmdk'입니다. 하드용량에따라 시간이 걸립니다. 5M-10M 속도로 상당히 느립니다.

Ted Knowledge

Search This Blog