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
Solved

APS login error during CE9 installation

Posted on 2004-08-23
5
650 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
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying 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

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. …
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

839 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