Solved

APS login error during CE9 installation

Posted on 2004-08-23
5
641 Views
Last Modified: 2007-10-18
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
Comment
Question by:sotta12
  • 2
5 Comments
 
LVL 42

Expert Comment

by:frodoman
Comment Utility
>>> 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
 

Author Comment

by:sotta12
Comment Utility
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
 
LVL 42

Expert Comment

by:frodoman
Comment Utility
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
Comment Utility
PAQed, with points refunded (125)

Computer101
E-E Admin
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now