Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

VS .NET Data connections error

I installed Visual Studio .net 2003, downloaded and installed MSDE 2000 (enabled network protocols). When I try to add a data connection in the server explorer I get this error: "Error
Enumerating Data Servers. Enumerator reports unspecified error".
I thought the problem was related to MDAC and downloaded the "component checker" to reconfigure my MDAC and downloaded the latest one (MDAC 2.8) but it still won't work. Even typing the Server name in the ComboBox does not give me access to my database (pubs)...
Help!
0
bakame
Asked:
bakame
  • 4
  • 4
1 Solution
 
dfiala13Commented:
Did  you install MSDE with the strong password option?

http://support.microsoft.com/default.aspx?scid=kb;en-us;814463
0
 
bakameAuthor Commented:
Yes I did, I also allowed network connections and I can access SQL Server using osql from the command prompt.
0
 
bakameAuthor Commented:
I reinstalled MSDE and now typing the Server name in the ComboBox DOES give me access to the databases ( I still can't use select from the list)... However, in the process of reinstalling it I lost the "pubs" database and when I try to reinstall with the "SampDBInstall.exe" utility (as I did b4), it gives me an error message to "insure that MSDE IS installled or the current user have sufficient priviledge..."
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
dfiala13Commented:
Hmmm.  

So you can now connect to the database server, but the pubs db is not there.

I am not familiar with SampDBInstall.exe, but are you an administrator on the machine you installed MSDE on?
0
 
bakameAuthor Commented:
Yes!
0
 
dfiala13Commented:
I can send you a zipped copy of the pubs database, if you give me an email address or an ftp site.  It's 281 KB.
0
 
bakameAuthor Commented:
I installed another instance (NETSDK) of SQL Server (from MSDE) that comes with the pubs DB already installed...
Thanks for your help dfiala13.
0
 
dfiala13Commented:
Glad you got it working.
0
 
PashaModCommented:
Closed, 125 points refunded.
PashaMod
Community Support Moderator
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now