Re: MSDE on XP running, but not recognized in ODBC

From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 02/11/05


Date: Fri, 11 Feb 2005 10:52:08 +0100

hi JRaub,
JRaub wrote:
> I installed an MSDE instance for a user running XP with an
> admin Windows account. The MSDE Server icon appears in
> the notification area, but without the green arrow. Task
> manager shows that it is running. Trying to start it up
> manually doesn't do anything. When I go to add the Data
> Source in ODBC, System DSN (MDAC 2.8 is installed), when
> we go to pick the MSDE Server, it doesn't appear in the
> drop down when picking a server. Any thoughts or ideas
> would be great. Thanks, JRaub.

please have a look at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;814132
if you want to modify the networkprotocols setting, please run the Server
Network Utility (svrnetcn.exe) and enable the desired protocol

-- 
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm        http://italy.mvps.org
DbaMgr2k ver 0.10.0  -  DbaMgr ver 0.56.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: Connect with alias
    ... My progam installed an instance of MSDE on their "Server" (just an XP ... connect to their MSDE Server ... connect to their MSDE Server with alias set up WITH PORT# specified ... Connect to MSDE Server with alias with DYNAMIC PORT # ...
    (microsoft.public.sqlserver.msde)
  • Re: sa account - hpw to reset a compromised pw
    ... Try connecting to your MSDE server with a Administrator account and then ... Addtional Information ... Manage the SQL Server Desktop Engine by Using the Osql ...
    (microsoft.public.sqlserver.security)
  • Re: Login Failed
    ... James Goodman "Murphy" wrote in message ... >> to access the server I am denied access. ... >> need to login as administrator in order to connect the MSDE server machine ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE 2000 SP3a on a Windows 2003 server
    ... Apperently my ports are setup correctly, but MSDE server ... 2004-02-20 15:35:12.26 server SQL server listening on ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE on XP running, but not recognized in ODBC
    ... >hi JRaub, ... >> I installed an MSDE instance for a user running XP with ... The MSDE Server icon appears in ... >> we go to pick the MSDE Server, ...
    (microsoft.public.sqlserver.msde)