RE: Login failed for user 'sa' on MSDE re-installation

Tech-Archive recommends: Fix windows errors by optimizing your registry

I ahven't heard of this issue before, but I did run into a similar issue
when updating a server with a Service Pack. When installing an SP it's
fairly easy to skip the window where the user needs to type in the 'sa'
password.

Perhaps there's something similar in your situation?
--------------------
| From: Scott Lindberg <scott.lindberg@xxxxxxxxxxxxxxx>
| X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
| Subject: Login failed for user 'sa' on MSDE re-installation
| Mime-Version: 1.0
| Content-Type: text/plain; charset="us-ascii"
| Content-Transfer-Encoding: 7bit
| Message-ID: <uLWfdXaqFHA.3352@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.odbc
| Date: Thu, 25 Aug 2005 11:50:28 -0700
| NNTP-Posting-Host: 67.41.129.85
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2618
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
|
| The situation is as follows:
|
| We have developed an application which uses SQL. Our installer
| (InstallShield 10.5) installs MSDE as part of the normal install. The
| MSDE is a passive install, i.e.,
| no user intervention to alter MSDE settings. We are using SQL Server
| authentication. After running the install, MSDE has been properly
| installed and our application runs as desired. After uninstalling our
| application and manually uninstalling MSDE from the control panel, I got
| an unknown MSDE installation error when attempting to install our
| application again. I attemted to install MSDE directly from the
| stand-alone installation and during this I was able to view the login
| failed message.
|
| Any ideas as to what is causing MSDE to abort the installation? I know
| the error would appear to indicate that the sa password is incorrect,
| but this is set in the installer and has not changed between
| installations. It would seem as though something is being left behind
| during the uninstall of MSDE, but I'm not sure what.
|
| *** Sent via Developersdex http://www.developersdex.com ***
|

.

Relevant Pages

  • Re: SBS 2003 and Great Plains problem - NOT SOLVED :(
    ... It doesn't matter if the new instance of MSDE is ... It did before the reboot. ... install a new instance the install quit with an error. ... server for the customer before they install it on their server. ...
    (microsoft.public.windows.server.sbs)
  • RE: MSDE Uninstall Doesnt
    ... but I had a problem uninstalling it because I did not ... Try to do a very basic install with the default instance first. ... > install program that will install my app and a named instance of MSDE. ...
    (microsoft.public.sqlserver.msde)
  • Re: Wrong MSDE installed
    ... That is the command line to install a new default instance. ... This will upgrade the existing instance but do nothing to get SBS Monitoring and Sharepoint installed. ... They use WMSDE not MSDE. ... those folders are as you say on my SBS 2003 server that has been upgraded to SP1. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Great Plains problem - NOT SOLVED :(
    ... It doesn't matter if the new instance of MSDE is ... but I now have a new instance of MSDE working and the SBS backup also ... install a new instance the install quit with an error. ... server for the customer before they install it on their server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Wrong MSDE installed
    ... those folders are as you say on my SBS 2003 server that has been ... The setup wizard will not run because of the older version of MSDE. ... If I need to install an MSDE instance I always do it from the ...
    (microsoft.public.windows.server.sbs)