Hi Brian,
It seems it is complex issue, the issue may be related to some system
component. To troubleshooting the issue, we can try:
1. Try to connect to other SQL Server, if all is the same, it seems the
issue is related to the specific computer. You can apply Jet SP8 on the
machine: (we can also try to connect to the same SQL Server from other
computer to make sure the issue is machine specific)
Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en
2. Reboot the system in Safe mode with Networking, check to see if the
issue occurs.
3. Reinstall Office by using Windows Installer cleanup utility
1). Download the Windows Installer cleanup utility and install it. For how
to download this utility, please click the link below:
http://support.microsoft.com/support/kb/articles/Q240/1/16.ASP
2). Run Windows Install Clean Up. The steps are as follows:
a. Click Start->Programs->Windows Install Clean Up.
b. A Windows Installer Clean Up Window appears, click Microsoft Access
2002, and then click remove.
c. Click Exit.
For more information about Windows Installer Cleanup Utility, please see
the article below:
ID: Q238413 OFF2000: Windows Installer CleanUp Utility
http://support.microsoft.com/support/kb/articles/Q238/4/13.ASP
3). Go to C:\Program Files. (I assume you installed Office in the default
Drive C.)
4). Rename the "Microsoft Office" folder as "Microsoft Office Old" (without
the quotation marks).
5). Insert your Microsoft Office CD to the CD-ROM.
6). Install Microsoft Office.
Please feel free to reply to the threads if you have any questions or
concerns.
Sincerely,
Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <
www.microsoft.com/security>
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "Brian Morris" <
[email protected]>
|
| Yesterday evening, I installed MSDE on my WINxp workstation (default
| instance).
|
| I also develop some with VB.Net and ASP.net...So I tried to establish a
| connection to my default instance of SQL on my machine and I still get the
| same error. This happens when I am setting up the connection with the
| connection dialog box. I am unable to see any servers listed in the
| "Server" drop down list. When I click refresh, I get an "Error
Enumerating
| servers".
|
| I have verified installation of MDAC 2.7. It seems to me that I am having
| trouble in a much more basic fashion than something with Access.
|
| Again, all help is appreciated.
| -brian
| | > Hi Brian,
| >
| > Based on the post, I have the following suggestiosn besides the firewall
| > suggestion:
| >
| > 1. Perhaps you run into a known issue: if you connect to nondefault
named
| > instances of SQL Server 2000, you will encounter such issue. The
| resolution
| > is to upgrade your MDAC to 2.6 or later.
| >
| > ACC2000: Cannot Connect to Instance of SQL Server 2000
| >
http://support.microsoft.com/?id=274383
| >
| > 2. If you specify a nonexistent server in the connection information
for a
| > Microsoft Access project (ADP), you will receive such errors.
| >
| > Error When You Specify a Nonexistent Server Name in ADP Connection
| >
http://support.microsoft.com/?id=275118
| >
| > 3. Make sure there is no changes on the S QL Sever side, the specified
| user
| > account has sufficient permissions to log onto the SQL Server database
| that
| > you are trying to connect to.
| >
| > Logon Errors Occur When You Connect to a SQL Server Database from
| >
http://support.microsoft.com/?id=297373
| >
| > Please feel free to reply to the threads if you have any concerns or
| > questions.
| >
| >
| >
| > Sincerely,
| >
| > Alick Ye, MCSD
| > Product Support Services
| > Microsoft Corporation
| > Get Secure! - <
www.microsoft.com/security>
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| >
| > --------------------
| > | From: "Brian Morris" <
[email protected]>
| > | Subject: Server Connection Catastrophic Failure
| > |
| > | I have an ADP that used to work. But now for some reason I cannot get
| it
| > to
| > | connect to my SQL server. I have tried everything and cannot find an
| > | answer. I get an error message like this:
| > |
| > | error enumerating data servers. Enumerator reports 'unspecified
error'
| > |
| > | then when I test the connection, I get this error:
| > |
| > | Test connection failed because of an error in initializing provider.
| > | Catastrophic failure.
| > |
| > | Any help is greatly appreciated.
| > | -brian
| > |
| > |
| > |
| >
|
|
|
