Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 682
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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