[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 673
  • Last Modified:

APS login error during CE9 installation

Hi,

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......??
0
sotta12
Asked:
sotta12
  • 2
1 Solution
 
frodomanCommented:
>>> Nor does sa with a blank passowrd

Was the msde instance created with a blank sa password?  Hopefully not...

It sounds as if the authentication method for msde has been set to WinNT Authentication instead of SQL Server.  You may have to change that to get CE to work correctly.  You can check it / change it through a registry setting (I'm assuning this is sql2k): http://support.microsoft.com/default.aspx?scid=kb;en-us;285097

HTH

frodoman


0
 
sotta12Author Commented:
Thanks frodoman for the reply and link. Tried it but did not solve the problem.
Consulted with an in-house SQL server expert here who suggested re-installing MSDE at the time CE asks for the APS login. On doing that and re-starting the CE installation, the installation got through.
But I am not done yet, facing some hiccups in publishing the reports. Will be back with some more queries on CR9 reports deployment later this week.
0
 
frodomanCommented:
Re-install probably wasn't necessary unless the script used to create the msde instance by your 3rd party is hidden - otherwise you should have been able to look at the install script to find the parameters.  But, the important thing is that it works!

Cheers - frodoman

0
 
Computer101Commented:
PAQed, with points refunded (125)

Computer101
E-E Admin
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now