|
Home > Archive > MS SQL Server ODBC > August 2005 > Login failed for user 'sa' on MSDE re-installation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Login failed for user 'sa' on MSDE re-installation
|
|
| Scott Lindberg 2005-08-25, 8:23 pm |
|
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.droptable.com ***
| |
| Warren Read 2005-08-31, 8:23 pm |
| 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@perkinelmer
.com>
| 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@TK2MSFTNGP14.phx.gbl>
| 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.droptable.com ***
|
|
|
|
|
|