Re: Cannot Connect to Server

From: Mike C (anonymous_at_discussions.microsoft.com)
Date: 04/30/04


Date: Fri, 30 Apr 2004 02:26:50 -0700

I guess I should have specified that I am working from my
own computer, I am not working on a network. I tried the
DIABLE NETWORKPROTOCOLS=0, no help I'm afraid. I'm not
at all sure that the Microsoft Article is relevant. If
it helps any, I installed the first time from the Office
XP CD, and after that using the file from the website,
not the upgrade. I don't think that this is the problem,
as it worked the first time I installed from the website
file. It only started noy working when I uninstalled and
reinstalled the website file.
>-----Original Message-----
>I just ran into this the other day. The installer for
MSDE with SP3 does not
>enable the network libraries by default. You have to
specify
>DISABLENETWORKPROTOCOLS=0 in the setup command line to
make them install.
>Otherwise you can only access the DB engine from the
machine its installed
>on.
>
>There's also an issue described here that has to do with
upgrades.
>
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;827204
>
>Tom Spitzer
>EC Wise
>www.ecwise.com
>
>"Mike C" <anonymous@discussions.microsoft.com> wrote in
message
>news:623201c42e46$60cb9680$a401280a@phx.gbl...
>> I am trying to come to grips with SQL Server 2000
Desktop
>> Engine. My latest problem is that I can't get anything
>> to connect to the server, including the Northwind
>> Project. When I try to open an existing project, the
>> project opens, but it says it is disconnected, and
there
>> are only forms to be seen. If I try to use the
upsizing
>> wizard, when you click next on the window where you
>> identify the SQL Server, I get an error window that
>> says "[DBNETLIBRARY][ConnectionOpen (Connect().] SQL
>> Server does not exist or access denied." When I
>> click "OK" on this dialogue box, I get another error
that
>> says"The upsizing wizard only works with Microsoft SQL
>> Server (Versions 6.50 SP5 or higher). Please log in
to a
>> SQL Server data source." If I try to open a new
project,
>> I get the same error message. The version of SQL I
have
>> installed is 8.00.760. It seemed to go awry after I
>> unistalled and reinstalled the Desktop Engine. I
>> installed from the downloaded sql2kdesksp3.exe I did
>> notice it won't let me install it without setting a
>> strong password, where it did not need one before. I
am
>> setting the password in the setup.ini pad.
>> Thoughts?
>
>
>.
>



Relevant Pages

  • Re: Mixing SQL Server and MSDE and authentication
    ... and specify a password for 'sa'. ... > I recently had someone install it on a system that already had SQL Server ... all other ubsequent instances will pass throught UDP port 1434 if they have ...
    (microsoft.public.sqlserver.msde)
  • Re: SP4 Installation Problem on Win2000/SQL Enterprise Edit.
    ... Jasper Smith (SQL Server MVP) ... Check your network documentation. ... >> your install location). ... I can't find any log entries. ...
    (microsoft.public.sqlserver.setup)
  • Re: No Local instance with SQLServer2005 Dev. Ed.
    ... On a 2nd test box I have Sql Server 2005 Developer Edition ... Server box successfully on our network. ... thought I could install SQLServer Express to get my local databases to ...
    (comp.databases.ms-sqlserver)
  • Re: Service pack MSDE problem
    ... You may be running the SP install on computer that does not have a default ... there could be a typo if you did specify an instance using the ... MSDE 2000? ... Do not attempt to start setup by clicking on or otherwise ...
    (microsoft.public.sqlserver.security)
  • Re: Cisco VPN: cannot access network resources
    ... Whilst looking at the update history I noticed that new updates where available - SQL Server 2005 SP1 being one. ... will probably have to take them all out and install them one at a time till failure. ... Last week, my Cisco VPN allowed me access to corporate DBs (using MS SQL Server or VB/ADO) and Remote Desktops. ... When I am attached to the network, all works fine. ...
    (microsoft.public.windows.vista.general)