Re: MSDE Exorcism

From: Greg Low [MVP] (greglow_at_lowell.com.au)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 22:08:38 +1000

Hi Xavier,

Most likely you don't have network protocols enabled. Try running
svrnetcn.exe (from Start>Run) and check that tcp/ip is enabled. If not,
enable it and restart the MSDE/SQL service.

HTH, 

-- 
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Xavier Pacheco" <xavier@_nospam_xapware.com> wrote in message
news:%23po8a%23ZhEHA.2340@TK2MSFTNGP11.phx.gbl...
> Got some problems installing the MSDE I downloaded it from
>
> http://www.microsoft.com/sql/msde/downloads/download.asp
>
> and ran the setup with the following command:
>
> setup SAPWD="testpw" INSTANCENAME="test"
>
> It installs, however, the server is never visible by the SQL Server
> Service Manager (although I can type it in manually, but starting it
> just tells me It's already started). Nor is it visible by Enterprise
> Manager (I installed the client tools to test this). It's not visible
> from a Data Link dialog but I can type the name in and connect to it
>
> Plus, here's some additional madness.
>
> From the datalink manager, I can connect only if I use NT integrated
> security. If I try something silly like the "sa" and "testpw" which I
> passed to setup, I get the error: "Test connection failed because of an
> error in initializing provider. Logon failed for user 'sa'. Reason: Not
> associated with a trusted SQL Server connection."
>
> Trying to connect from another machine is fruitless.
>
> I've tried numerous things, reversing the parameters passed to setup,
> checking the MDAC version 2.7 Re(something or other). Reinstalling,
> rebooting, Standing on my head. prayers, Voodoo, stuffed animal
> sacrifice. Nothing works.
>
> Any pointers?
>
>
> -- xavier

Relevant Pages

  • Reporting services installation
    ... I am experiencing this error while installing Reporting Services on a Win ... SQL Server 2000 has already SP3a installed and it's working successfully. ... So, after executing this command, the setup starts and tells me that VS 2003 ...
    (microsoft.public.sqlserver.server)
  • 2005 Cluster Install Error
    ... Looking through the log files the setup ... I've trying to work around it I have tried installing from the command line. ... install SQL Server 2005 as a failover cluster, ... The domain group cannot be validated for the service SQL Server. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Problem installing MS SQL Server 2000
    ... >i tried to install SQL Server 2000 on my Windows 2000 Advanced Server and i ... > 00:20:35 Setup is installing Microsoft Distributed Transaction Coordinator ... > SQL Server configuration failed. ...
    (microsoft.public.sqlserver.setup)
  • Re: Where is Server Manager?
    ... > AFter installing Visual Studio 2005 Beta 2, I installed the SQL Server DE ... > locate the Server Manager, On line books, etc. ...
    (microsoft.public.sqlserver.setup)
  • SQL Server 2005 + SQL Server Express + VS2005
    ... is there a forum for SQL Server 2005 and SQL Server 2005 ... I just setup VS 2005 and SQL Server 2005. ... Workbench that combines EM and Query Analyzer, ... check after installing VS2005 only after installing SQL Server 2005 which I ...
    (microsoft.public.sqlserver.tools)
Loading