Microsoft Dynamics RMS (Archived)

Run-time error "5"; Invalid Procedure call or argument

(0) Share

Report

Posted on by Community Member

error #-2147467259 sql server does not exists or access denied

error #-2147467259 sql server does not exists or access denied. (source: Microsoft OLE DB Provider for SQL Server)

SELECT GETDATE() AS CurrentDateTime

after that is displayed anothe error pops up

Store Operations POS

Run-time error "5";

Invalid Procedure call or argument

RMS Ver 2.0.1006

SQL 2008R2

Window 7

I am getting above error message durning a transacion ramdomly.

It happens after upgraded from SQL 2005 to SQL 2008r2.

any idea??

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

arishi 740 on at

Like (0)

Report

Hi Haemin,

if this is the only POS Station and Database server at your site

close batch, take backup and uninstall then reinstall RMS and SQL Express 2008R2 (make sure do not skip SQL 2005 Express while RMS install)

if there is a separate server for Database where you upgraded to SQL 2008R2, make sure you install SQL Express 2005 backward compatibility on POS Station

download.microsoft.com/.../SQLServer2005_BC.msi

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

HI Arif Thank you for replying.

they have 4 workstations and a server in their office.

do I have to intall SQL Express 2005 backward on server too?

Was this reply helpful? Yes No
Suggested answer

arishi 740 on at

Like (0)

Report

I assume you just upgraded SQL 2008R2 on server

Just install backward compatibility on workstation, I would also recommend update RMS to latest updates, on Server and all workstation

mbs.microsoft.com/.../20SPHF-V2

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Arif.

I have install SQL Express 2005 Backward on server and all worksatations.

and updateed RMS to Lastes ver.

but I still have the same issue.

any idea?

Was this reply helpful? Yes No
Suggested answer

arishi 740 on at

Like (0)

Report

check event logs for errors on server for SQL Server 2008 R2, may be you will get a lead from there

which OS is running on Server? if you have any spare Windows 7 Pro system try with SQL 2012 express and see if that fix the problem, make sure do not install any Anti Virus or Firewall

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

window 7

firewall is off and No anti virus installed.

how can I check event logs?

Was this reply helpful? Yes No
Suggested answer

arishi 740 on at

Like (0)

Report

click on start button --> enter in search Event Viewer --Windows Logs --> Application

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I just upgraded RMS ver from 2.0.126 to 2.1.006

I will let you know what will happen.

Thank you.

Was this reply helpful? Yes No
Suggested answer

raelhefn on at

Like (0)

Report

This issue rising from change language setting of your PC. change machine language to previous language setting from control panel. check for both POS and back office server.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ramy EL-Hefnawy

I have double checked that they did not change any LANGUAGE setting.

any other idea?

Was this reply helpful? Yes No