Thursday, December 24, 2015

Change SA Password in SQL Server Using TSQL Query

-- Change SA Password in SQL Server Using TSQL Query

USE master
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewSAPassword'
GO
-- F5
-- Run this query in SQL Server.
-- NewSAPassword is your new password, you can give another password also instead of
-- NewSAPassword.

-- You might be receive the below mentioned error message as the password specified does
-- not meet windows policy requirements because it is not complex enough.

-- Error Message
-- Msg 15118, Level 16, State 1, Line 1
-- Password validation failed. The password does not meet Windows policy requirements
-- because it is not complex enough.

-- It is always a best practice to set a complex password for an SA (System
-- Administrative Account) in SQL Server to avoid unauthorized access.
-- If you still want to set a simple password for an SA account in SQL Server which is
-- not recommended; then you add CHECK_POLICY = OFF clause to the above query.

USE master
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewSAPassword', CHECK_POLICY = OFF
GO
--F5
-- There may be a scenario that once you try logging in to SQL Server using SA Password
-- you get the below mentioned error.

-- Error Message
-- Login failed for user 'sa'. Reason: The account is disabled. (Microsoft SQL Server,
-- Error: 18470)

-- Enable SA Account in SQL Server
-- In such a scenario you need to go ahead and run the below TSQL code to enable SA
-- account in SQL Server.

USE master
GO
ALTER LOGIN [sa] ENABLE

Tuesday, December 1, 2015

Making a Customize Reports Available From Search in the Windows Client MS Dynamics NAV 2015 (or) 2016

Hi all,
Today I posted an article that have some different type of requirement, where some users want to search his customize Reports in Search Field on Windows Client.

About This Article:
The Microsoft Dynamics NAV Windows client includes a Search box that lets users find pages and reports based on the objects name. The search feature finds only pages and reports that can be accessed from the navigation pane, which includes the Home button, Activity buttons, and Departments. If you want to make a Customize reports available from the Search box, then you have to follow the bellow procedures.
Step-1:           Open the Development Environment 2015 (or) 2016 with your Database and then open Object Designer. And Then Select MenuSuite and Click New After that select
Dept – partner (or) Dept – Company and then click on OK Button.
Now Right Click on any Menus from Navigation pane Designer and then click Create Menu...
See the bellow screenshot






Step-2:           After clicked on Create Menu… A “Create Menu” Form will display. Now Fill the Form and click on OK button.
                        See the bellow Screenshot.


Once you created a menu then your created menu is available on Navigation Pane Designer.
Step-3: Now select your menu and then go to [Empty Menu] and then Right Click on [Empty Menu] and select             Create Item…
            [See the bellow screenshot for better understanding].

After Clicked on Create Item… A Create Item… Form will display. Now fill the form and then click on OK Button.
[See the bellow screenshot for better understanding].


After Clicked on Ok Button your Reports will appear on your Menus.
Now Close the Navigation Pane Designer. And Save the Menu Suite.
[See the bellow screenshot for better understanding].






References: MSDN






Thursday, November 26, 2015

Microsoft Dynamics NAV 2016 Keyboards Shortcuts

Microsoft Dynamics NAV 2016
Hi! All,
Today I Posted Shortcut Keys of MS Dynamics NAV 2016.
The following table provides an overview of shortcut key combinations in the Microsoft Dynamics NAV Windows client.

Microsoft Dynamics NAV Windows client
Action
Right Arrow
Move to the next field or character
Left Arrow
Move to the previous field or character
Up Arrow
Move to the field above in the same column
Down Arrow
Move to the field below in the same column
Delete
Clear selected text
Esc
Close the window or undo the data entry
End
Move to the last field on a line
Home
Move to the first field on a line
Tab
Move to the next field on non-line FastTabs
Enter
Move to the next editable field
F1
Open Help
F2
Edit
F3
Select Type to filter (field filter)
F4
Drop-down or look up to select
F5
Refresh the active window
F6
Go to the next frame
F7
Display statistics
F8
Copy the field above
F9
Post
F10, Alt
Select the menu bar and display access keys
F12
Select the navigation pane
Shift+F1
View error message
Shift+F3
Select Show Results (FlowFilter)
Shift+F4
Open a lookup window (from an ellipsis button)
Shift+F6
Go to the previous frame
Shift+F7
Open the related card
Shift+F8
Drop-down or look up to view
Shift+F9
Post and print
Shift+F10
Display a shortcut menu
Shift+F11
Apply entries, get source documents, or get warehouse documents
Shift+F12
Open the Role Center from the navigation pane
Shift+Tab
Move to the previous field
Shift+left-click
On multiple column headers, the columns will all be sorted in the same ascending or descending direction.
Shift+double-click
If sorting on multiple column headers using Shift+left-click, use Shift+double-click on the first column that was clicked on and this will toggle ascending/descending direction of all the columns included in the sorting.
Left-click
Left-click on a column header to sort a column ascending, then left-click again to toggle between ascending and descending.
Ctrl+F1
Collapse or expand the ribbon
Ctrl+F2
Create a new document
Ctrl+F3
Select Search pages
Ctrl+F4
Look up to the related list
Ctrl+F7
View entries
Ctrl+F9
Release document
Ctrl+F10
Select the ribbon and display key tips
Ctrl+F11
Reconcile or split lines
Ctrl+F12
Select the address bar
Ctrl+C
Copy
Ctrl+G
Go to
Ctrl+E
Export to Microsoft Office Excel
Ctrl+L
Show links
Ctrl+N
Create a new record
Ctrl+O
Open the company
Ctrl+P
Print
Ctrl+T
Select sorting
Ctrl+V
Paste
Ctrl+W
Export to Microsoft Office Word
Ctrl+X
Cut
Ctrl+Z
Undo
Ctrl+Page Down
Display next document or card in a list
Ctrl+Page Up
Display previous document or card in a list
Ctrl+Up Arrow
Move up while the selected line stays selected
Ctrl+Down Arrow
Move down while the selected line stays selected
Ctrl+Left Arrow
Move to the first field on a line
Ctrl+Right Arrow
Move to the last field on a line
Ctrl+Alt+F1
Open the About this Page/Report window (Zoom)
Ctrl+Delete
Delete the selected line
Ctrl+Home
Move to the first line in a list
Ctrl+End
Move to the last line in a list
Ctrl+Enter
Save and close window (equivalent to choosing the OK button)
Ctrl+Insert
Insert new line
Ctrl+Shift+F3
Select Limit totals to (table filter)
Ctrl+Shift+A
Clear all filters
Ctrl+Shift+C
Copy Rows
Ctrl+Shift+D
Show dimensions
Ctrl+Shift+E
Edit list
Ctrl+Shift+R
View list
Ctrl+Shift+Q
Collapse/expand a line in a hierarchy
Ctrl+Shift+V
Paste rows
Ctrl+Shift+W
Open a list place in a separate window
Ctrl+Shift+Enter
Save and close the window and open a new window
Alt
Display access keys in the ribbon
Alt+F2
Toggle to display/hide FactBoxes
Alt+F3
Filter to the value in the field
Alt+F4
Close window or close program
Alt+F6
Collapse or expand the active frame
Alt+F12
Optimize space for the current page
Alt+Left Arrow
Go to the previous window in the navigation history
Alt+Right Arrow
Go to the next window in the navigation history
Alt+Enter
Move to the field below without opening the drop-down menu
Alt+Tab
Toggle between open windows

 References : Msdn Site

____________________
Thanks & Best Wishes
Binesh Singh Rajput
(MCP, MS, MCTS)

Popular Posts