In response to a post I made about VS.NET 2002 failing to open connections with Sql Server, Roman says:

I have just found solvation. Installing MDAC 2.8 helps

Tony, who had been having a similar problem, found the post and thanks Roman. So, if you're having problems connecting to Sql Server, try installing MDAC 2.8.