Microsoft SQL Server
Posted on 2011-02-28
Hi Experts Exchange,
A client of ours is using a third party application on an old server. I have installed a new SBS 2003 Server and installed Microsoft SQL Server 2000. I have copied the database from the old Server to the new Server, but when I try and connect to the database from the third party application I get an error (open method OLEAuth object failed).
I have installed the Microsoft SQL Server 2000 in mixed mode authentication as the application will only work in mixed mode. From the error message this indicates a authentication issue. It is using the SA account which is correct.
Please can somebody help me with this issue.
Thank you Experts Exchange.