I am trying to install CE9 on a Win2K machine with Oracle 8.1.7 DB
The CR is required as a reporting tool for a 3rd party software which is also installed on the same machine. During the installation of the 3rd party software, MSDE was installed. There is no SQL Server installed on this machine, only MSDE.
When I try to install CE9, after I select "New installation", I get a message saying -
SQL Server is detected on this machine. APS service needs a user account to startup. NOTE: The NT user must belong to System Administrators SQL Server Roles.
My NT login has admin rights. But that does not work for this APS service. Nor does sa with a blank passowrd.
Using osql I created a new user with sysadmin role in the MSDE instance. But that also does not work. I always get a message saying -
The installation is unable to identify the MS SQL Authentication mode. Make sure the server is running and the authentication info is correct.
There was a DSN created when MSDE was installed with the 3rd party software. I configured that DSN and set it to SQL Server Authentication. The new login that I created in osql works perfectly there. But not for the APS service.
I have run out of ideas. Anybody can point out what I am doing wrong......??