?
Solved

APS login error during CE9 installation

Posted on 2004-08-23
5
Medium Priority
?
659 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 11869146
>>> 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
ID: 11878886
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
ID: 11879477
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
ID: 12108461
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

752 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