SQL 2005 Standard & RMS HQ v1.2

have you enabled remote connections in SQL 2005??

"Bruce Straughan" wrote in message news: snipped-for-privacy@microsoft.com...

The problem is you need a little bit of extra software to access the databses on the computer you are getting the error message on. Google SQL management objects and you'll be able to download it. I got the same error message when I tried using SO Administrator on a backoffice computer to access the server. Installing this fixed the problem.

I know that some people have posted here that they have used SQL2005 with RMS 1.2, but remember that MS doe NOT support it. RMS 1.3 is the first version to officially support SQL2005...

Glenn Adams Tiber Creek C> Has anyone had any problems getting RMS HQ (v1.2) admin to connect to an RMS

Hi Glen,

Yes I was aware that V1.2 did not support SQL 2005. We will indeed upgrade RMS to V1.3/1.4 in due course but in the meantime we still wish to run V1.2.

I did however manage to resolve the issue by installing the SQL Server 2005 Backward compatibility msi file (located on the SQL Server 2005 install disc

RMS HQ V1.2 can now see our HQ Db running on SQL 2005 server.

Regards Bruce

"Glenn Adams [MVP - Retail Mgmt]" wrote: