Visual Studio and .NET Framework versions supported by SQL Server 2000

You just have to make the connection to the database. .NET Framework Data Provider for SQL Server

You can use an App.config file

<connectionStrings>
   <add name="default" 
        connectionString="Data Source=.;Initial Catalog=DBPrisma;User ID=sa;Password=xxx"/>
</connectionStrings>

Make references to

using System.Data;
using System.Data.SqlClient;

I do not think you have any problems connecting to SQL 2000

internal class Conexion
{
    public static SqlConnection Conectar(string cnStr)
    {
        try
        {
            string conn = ConfigurationManager.ConnectionStrings["default"].ToString();
            SqlConnection cn = new SqlConnection(conn);
            cn.Open();
            return cn;
        }
        catch (Exception ex)
        {
            throw new ArgumentException("Error de conexión", ex);
        }

    }
}

This is an example, I hope it helps you.