VC 6.0 on MSDE

[Former Member]

Hi,

I'm trying to install VC 6.0 on XP SP2 with MSDE 2000A installed. I've created a VCDB on MSDE and also changed the authentication method to "Mixed". The connection tests using MSDE admin tools works without any problem. But when I run VC setup, it tries to connect to DB with SA user but fails with error :

[DBNETLIB]SQL Server does not exist or access denied.

[DBNETLIB]ConnectionOpen (Connect()).

I even tried creating a new user on DB level who has all rights but it still cannot connect.

Is it not possible to install VC on MSDE or is there a solution to my error ?

[jack_graus2]

Just solved the same problem.

To configure your MsSQL server you have to install the MsSQL client tools. Then go to your MsSQL server properties -> General -> Network configuration and add the TCP/IP protocol. I think this is default disabled in MSDE.

regards Jack