[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...

[SharePoint] Versioning Settings menu location for sharepoint 2013

https://support.microsoft.com/en-gb/office/enable-and-configure-versioning-for-a-list-or-library-1555d642-23ee-446a-990a-bcab618c7a37#OfficeVersion=2016,_2013 1. From top menu Select "PAGE" 2. Select "Library Settings" 3. Select "Versioning settings" 4. Versioning Settings are listed.

[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...

Ted Knowledge

Search This Blog