Versions of Visual Studio and de.NET SQL Server 2000 supported frameworks

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

You can use an App file.config

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

Refer to

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

I don't think you have 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.