Re: MSDE installation fails


Steve Foster [SBS MVP] wrote:
gbruntzel@xxxxxxxxx wrote:

I have always had a problem with MSDE on SBS 2003 which is now on SP1.
Whether installing Veritas Backup Exec, Microsoft SUSW, or any other
program that needs to add an instance of MSDE it bombs. Could this be
related to SBSMonitoring or Sharepoint. Both of their SQL instances
are running without errors and appear to be MSDE 2000 SP4 This is
making me crazy! I've tried adding an instance using the command line,
but no luck.

When trying to log using "osql -U sa" I get the password prompt. When
entering a blank pw, I receive the following error:

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

By default, MSDE instances are installed using Windows Authentication
only, so the SA account would be disabled.

Additionally, you must specify which instance you want to connect to when
invoking OSQL.

Try:

OSQL -S <SERVER> -E

where <SERVER> is like this:

<servername> for the default instance on servername
(local) for the default instance on this server (you can use the server
name version locally too)
<servername>\<instancename> for a selected instance on servername
(local)\<instancename> for the select instance on this server

Examples in an SBS context are:

(local) (Premium with SQL installed)
(local)\MSFW (ISA2004 MSDE instance)
(local)\SHAREPOINT (Sharepoint instance, whether WMSDE or SQL)
(local)\SBSMONITORING (Monitoring instance)
(local)\BKUPEXEC (Backup Exec instance)

--
Steve Foster [SBS MVP]
---------------------------------------
MVPs do not work for Microsoft. Please reply only to the newsgroups.

Thanks Steve. I can connect to both Sharepoint and SBSMonitoring using
your example above. However, I cannot connect to the default instance
using just <servername>. I get the exact same error message. Of
course, I can't connect to Backup Exec because it's not installed. I
tried by the SQL portion fails.

Any other ideas?

.

Relevant Pages

  • RE: Fail to install MSDE (log attached)
    ... trouble getting MSDE installed. ... Setup failed to configure the server. ... file located in the install directory where you are installing MSDE. ...
    (microsoft.public.sqlserver.msde)
  • Re: 2 Applications With MSDE
    ... > Since MSDE SP2 it just doesn't work anymore. ... I do not know what kind of service pack level hase been applied to Veritas ... upgrade tha instance yourself downloading and installing the sp3 from ... it is not mandatory that all MSDE/SQL Server ...
    (microsoft.public.sqlserver.msde)
  • Re: SBS 2003 and Great Plains problem
    ... SQL Server VSS Writer ... restarted ALL sql related services and then ran a backup ... If you think installing patches and security updates is expensive, ... They will be using MSDE ...
    (microsoft.public.windows.server.sbs)
  • Re: MSDE installation fails
    ... Whether installing Veritas Backup Exec, Microsoft SUSW, or any other ... program that needs to add an instance of MSDE it bombs. ... SQL Server does not exist or access denied. ...
    (microsoft.public.windows.server.sbs)
  • Re: Connecting to SharePoint MSDE Database
    ... the error I get when attempting to connect to the sharepoint instance ... SQL server does not exist or access denied ... I can connect to Backup Exec instance from same computer on LAN. ... TCP/IP and Named Pipes are enabled on both instances of MSDE. ...
    (microsoft.public.sqlserver.connect)
Loading