Cannot Access SQL Server Databases from VS .NET 
Author Message
 Cannot Access SQL Server Databases from VS .NET

I have a very interesting problem.  I am unable to access
ANY SQL Server databases from my installation of
VS .NET.  This happens in the designer (i.e. Configure
SqlDataAdapter), in code, and in Server Explorer.  In all
cases, I get a connection failed message.  I am 100% sure
that I am using a valid username/password, and I am
attempting to connect using SQL Server Authentication.

I have verified that I can access these databases
correctly from another machine where VS .NET is
installed.  Both machines are running Windows XP Pro.

The most interesting thing is, when trying to set up a
new connection in Server Explorer, for example, the Test
Connection button reports success, but then clicking the
OK button results in the connection failed message.

At this point, I am at a loss for how to proceed.  I
suspect that there is a problem with my MDAC components,
but I cannot figure out how to fix it.  I downloaded the
Component Checker from the microsoft web site, but it
refuses to remove the current version of MDAC because two
DLL's are reported in use.  This is even true when I
reboot without processing system.ini, win.ini, system
services, and startup items.  The two DLL's in question

Any help would be greatly appreciated!

Christopher S. Peet
Senior Software Engineer
EdMicro Inc.

Fri, 01 Jul 2005 21:48:07 GMT
 [ 1 post ] 

 Relevant Pages 

1. Cannot access cube after installing VS.NET

2. Setting up Local SQL server and use to debug

3. Setting up Local SQL server and use to debug

4. Cannot access SQL Server 6.5 SP4 databases via Access 97

5. Cannot create SQL Server linked server using a secured Access database

6. Access vs SQL Server vs Sybase vs Oracle

7. Newbie needs code pages for SQL Server 2000 access from page using

8. SQL*Net V2 vs SQL*Net V1

9. ODBC Intersolve 3.0/Access 97/Ingres net 1.2 Vs Ingres 2.0 server

10. [ODBC SQL Server Driver][SQL Server]Cannot open database

11. cannot connect to a SQL server through a firewall with multiprotocol net lib

12. SQL Server vs. Access BackEnd Split Database

Powered by phpBB® Forum Software