Re: SQL Server does not exist or access denied (after XP SP2)

From: Vincent Verheul (Email_at_nospam.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 14:09:47 +0100

Re-installing SQL Server 2000 resolved the problem.

"Vincent Verheul" <Email@nospam.com> wrote in message
news:cq8qia$fu1$1@reader08.wxs.nl...
> Hello,
>
> I use MsAccess 2002 on a Windows XP platform, together with SQL Server
> 2000. I installed SQL Server on my XP machine prior to installing Service
> Pack 2 for XP. Everything worked fine: could use the Upsize Wizard, ADP
> etc.
>
> After installing Service Pack 2, I can no longer get a connection to SQL
> Server from Access 2002. Using the upsize wizard I get the messages:
>
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.
> The Upsizing Wizard only works with Microsoft SQL Server (versions
> 6.50 SP5 or higher). Please log in to a SQL Server data source.
>
> SQL Server is running, and I can see the tables etc. via the SQL Server
> Enterprise manager. I switched off the firewall, but no effect.
>
> Any ideas?
>
> Thanks!

Relevant Pages

  • Re: SBS Monitoring reinstall fails
    ... -- SharePoint instance on SQL Server 2000 SP4 ... Microsoft Data Engine. ... Rerun Setup, and retry installing ...
    (microsoft.public.windows.server.sbs)
  • Re: There was a problem loading data: Generating user instance in SQL Server is disabled.
    ... When I installed VBExpress and C# Express 2008, using the default settings with only one exception it was the path for the installation since there is nothing else than the OS on C: so everything else is on D: ... Yes, I talk SQL Server and SQL Server Express without dsitinguashing them because in most cases, there is not differece in the regards of inexperienced users. ... USER INSTANCE, however, is only available to SQL Server Express. ... Since you have already get it installed into a setting that is not meet the default requirement for those sample apps, you need to learnto reconfigure the system, or you could try to uninstall and then re-install, so you have chance to studybefore installing and configuring your OS to meet the all requirements and to get the installation right. ...
    (microsoft.public.vstudio.general)
  • Help desperately needed! Struggling to re-install SQL server.
    ... I've had great trouble installing SQL server 2000 on Windows XP. ... 15:09:43 End Action ShowDialogsHlpr ... 15:10:10 End Action DialogShowSdSetupType ...
    (microsoft.public.sqlserver.setup)
  • SQL Server 2005: setup problem
    ... Could you help me please with installing SQL Servera 2005 Express ... SQLEXPR.EXE - Microsoft SQL Server 2005 Express Edition ... WMI Service Requirement (Success) ... Operating System Minimum Level Requirement ...
    (comp.databases.ms-sqlserver)
  • Re: Reporting Services DISABLES DEFAULT Transaction Isolation Level!!!
    ... installing RS specifically, while I see it without such install. ... Tibor Karaszi, SQL Server MVP ... > Server when run pre- and post- Reporting Services install. ... > It's like the Reporting Services team removed the read committed isolation ...
    (microsoft.public.sqlserver.server)