Can't open tables in Enterprise Manager

From: MCSD Student (anonymous_at_discussions.microsoft.com)
Date: 06/20/04 

Date: Sat, 19 Jun 2004 23:12:09 -0700

I have SQL Server 2000 Developer Edition and Windows XP
Professional O/S. I installed SQL Server 2000 as the
default server, a typical installation, Local system
account, with Windows authentication.

The problem is that when I try to open any table in
Enterprise Manager, I get a "catastrophic failure" (OBDC
error). However, I have no problem opening a table in
Query Analyzer. Anybody have any ideas?

I also had a problem trying to import data from an Access
database table into a SQL Server 2000 database table
using DTS Import Wizard. I have a feeling that the two
problems are related.

Any help will be greatly appreciated, thanks!

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
    ... Your backup is from a different version of Windows SharePoint Services and ... SQL Server 2005 is available. ... The advantages of the embedded version ("Windows Internal Database") over ...
    (microsoft.public.sharepoint.windowsservices)
  • IIS / SQL Server impersonation
    ... I am attempting to implement impersonation from a windows application ... I have configured the host virtual directory in IIS to require windows ... the database permits Windows Authentication. ... When I try and open a connection to SQL Server: ...
    (microsoft.public.dotnet.security)
  • Re: User setup problem.
    ... login permissions for SQL Server. ... have access to SQL Server and the database through their ... windows group role membership which has the permissions.. ...
    (microsoft.public.sqlserver.security)
  • Re: BizTalk 2004 MSDTC
    ... On my Windows XP, dev machine, I set ... and it still errors out when updating a remote SQL Server database running ... BizTalk 2004 Server, Visual Studio.Net, and local SQL Server DB ... The problem I am having is that with MSDTC ...
    (microsoft.public.biztalk.general)