CANNOT CONNECT TO MDE DATABASE : MIGRATION

Can Not Connect To MDE Database

After Restore MDE Backup into Migration Server it may show the error message as cannot connect to MDE Database.

Solution

• Download attached Tool from PoTools.(MDE Dcl Fix included.)
• Enter Login Credentials of SQL Server in this Tool.
• Execute the Tool using "Auto Fix for DCL " Button.

DCL User Auto Fix will Fix for BPRO, BPLOG, POST,SIGN, PROJECT, SOSB, NREGAEMO, MDE and MDE_SIGN databases.

Download

Download

Solution : Method 2

Fix MDE Login Issues Using DB Analyzer ( Thanks To Rajesh H)

Follow these steps

1. Open management studio. Right click on mde database. Rename as offline.

2. Open DB analyzer > DB utilities > Update to SQL 2005. Select database offline and update.

3. Re name offline database as MDE management studio.

Do same steps for mde_sign also.                 

Read More

ACCOUNTS MODULE UD REGISTER ERROR AND SOLUTION

Solution For Account UD Register Generation Error

While Generate Report for UD Register in Account Module  under Other Bill option it may show the below error message

Solution

• Download Duplicate Delete Executor from PoTools.
• Enter Accounts Server Name, then Execute to delete duplicate records.

Download

Download

Read More

R NET COMMUNICATION ROOT ELEMENT IS MISSING

Root Element Is Missing : R Net Communication

R Net Communication configuration file may corrupt due to HDD issues or System may Suddenly down. while execute R Net Communication 

While Click on OK. Additional error may Show like below

Unhandled exception has occurred in your application. If you click continue the application will ignore this error and attempt to continue. If you click Quit,the application will close immediately.

Root element is missing

Solution

• Download Configuration file generator.
• Enter SQL Server name and Point of Sale Server Path.
• Select R Net Communication path to Generate Config File on same location.

Download

Read More

SQL SERVER QUERY ANALYZER SHORTCUTS : SQL 2005 / 2008

SQL Server Query Analyzer Shortcuts

Shortcut	Function		Shortcut	Function
ALT+BREAK	Cancel a query		CTRL+SHIFT+F2	Clear all bookmarks
ALT+F1	Database object information		CTRL+SHIFT+INSERT	Insert a template
ALT+F4	Exit		CTRL+SHIFT+L	Make selection lowercase
CTRL+A	Select all		CTRL+SHIFT+M	Replace template parameters
CTRL+B	Move the splitter		CTRL+SHIFT+P	Open
CTRL+C	Copy		CTRL+SHIFT+R	Remove comment
CTRL+D	Display results in grid format		CTRL+SHIFT+S	Show client statistics
CTRL+Delete	Delete through the end of the line		CTRL+SHIFT+T	Show server trace
CTRL+E	Execute query		CTRL+SHIFT+U	Make selection uppercase
CTRL+F	Find		CTRL+T	Display results in text format
CTRL+F2	Insert/remove bookmark		CTRL+U	Change database
CTRL+F4	Disconnect		CTRL+V	Paste
CTRL+F5	Parse query and check syntax		CTRL+W	Window selector
CTRL+G	Go to line		CTRL+X	Delete
CTRL+H	Replace		CTRL+Z	Undo
CTRL+I	Index Tuning Wizard		F1	Help for Query Analyzer
CTRL+K	Display/hide execution plan		F2	Move to next bookmark
CTRL+L	Display execution plan		F3	Repeat last search
CTRL+N	New query window		F4	Object Search
CTRL+O	Connect		F5	Execute a query
CTRL+P	Print		F6	Switch between query and result panes
CTRL+R	Show/Hide results pane		F8	Show/hide Object Browser
CTRL+S	Save		SHIFT+F1	Transact-SQL help
CTRL+SHIFT+0	Show options		SHIFT+F2	Move to previous bookmark
CTRL+SHIFT+C	Comment out code		SHIFT+TAB	Decrease indent
CTRL+SHIFT+DEL	Clear the active Editor pane		SHIFT+F6	Switch panes
CTRL+SHIFT+F	Save results to file		TAB	Increase indent

Read More