web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / error #-2147467259 sql...
Microsoft Dynamics RMS (Archived)

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

(0) ShareShare
ReportReport
Posted on by pcshopcentral 105

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

This happened when we removed the TPI from our POS Stations

And this only happends when the ingenico terminals are connected to stations...the stations that does not have ingenico terminals does not display this error.

It is POS 2.0 with SQL Server 2005...

Please help...

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    When r u getting this error message?

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,382 on at

    Make sure that the Backward Compatibility module is installed SQLServer2005_BC.msi from here;

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11988

    You really only need the SQL-DMO (second line down) but no harm to install everything.

  • Community Member Profile Picture
    Community Member on at

    Hi Jeff.

    I am getting the same error message during the transaction randomly,

    If it happens after upgrading from SQL2005 to SQL 2008r2

    what is wrong?

  • Suggested answer
    arishi Profile Picture
    arishi 740 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans