Re: Problem with MSDE 2000 Rel A.

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

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 16:26:03 +0100

hi Raymond,
"Raymond" <dfs@ddd.com> ha scritto nel messaggio
news:uEeYk4MDEHA.3236@TK2MSFTNGP09.phx.gbl...
> I have just installed the MSDE 2000 Rel A. At command prompt and type
> osql -S.\MSDE -E and I got an error message 'SQL Server does not exist or
> access denied. But if i use osql -Sservername\MSDE -E and it's work. I can
> use the . instead of server name on MSDE 2000.
>
> And my bigger problem is that I have Enterprise Manager on another PC,
tried
> to register the new SQL Server and got the same error message 'SQL Server
> does not exist'? I have tried using windows and SQL authentication, both
> also didn't work.
>

please verify that MSDE instance has network protocols enabled...
by default, up to sp3a, MSDE installs disabling network protocols in order
to grant higher security for MSDE users, but this prevent the use of the
installed instance for remote clients...
run svrnecn.exe, the Server Network Utility, and verify that the preferred
protocol is enabled.. 

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.6.0  -  DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Relevant Pages

  • Re: MSDE questions for SharePoint and Project Server
    ... "xfile" ha scritto nel messaggio ... I do think SharePoint installs it' own instance of a modified MSDE ... your own strong password for the special SQL Server account known as "sa", ... if you want to set a strong password for your "sa" login, ...
    (microsoft.public.sqlserver.msde)
  • Detecting SQL Server VB6 (specifically)
    ... The "fat" part of the application installs several tools to ... Right now, when I build the system, I manually install MSDE, the web portion ... detect a running SQL server, ...
    (microsoft.public.vb.enterprise)
  • Re: Replace MSDE with SQL2000
    ... Above implies that you have both the MSDE that came with BE installed as ... Note that service pack installs are different between MSDE and the regular ... SQL Server, as they use different setup engines. ... Moving SQL Server Databases ...
    (microsoft.public.sqlserver.setup)
  • Re: reporting..
    ... "dev_kh" ha scritto nel messaggio ... > Do you mean making sure that the MSDE is set to startup automatically.. ... > but now when the service is on the central machine then will anything ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE Install For 98/SE/ME
    ... > I understand for Win 2k and XP installs that a simple re-boot after MSDE ... Andrea Montanari (Microsoft MVP - SQL Server) ...
    (microsoft.public.sqlserver.msde)