CODEWITHSUNDEEP
c#sql-serverasp.net-coresql-server-2000
tam phan
tam phan

Reputation: 29

Connect to database Sql server database 2000

When running SQL Source Control in SSMS 2017 I'm unable to expand any of my databases in object explorer on a 2000 server, I have connected. If I open a second instance of SSMS (so SQL Source Control is disabled) it works. I want to connect database SQL 2000 from visual studio 2017, netcore 2.2, but it returns an error:

"No connection could be made because the target machine actively refused it"

This is my C# code:

using (SqlConnection conn = new SqlConnection(connectString))
{
    using (SqlCommand cmd = new SqlCommand(sqlString, conn))
    {
        if (cmdParams != null)
        {
            cmd.Parameters.AddRange(cmdParams);
        }

        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(ds);
        return ds;
    }
}

[![This is version of sql][1]][1]


Please help me ignore this issue to get data


  [1]: https://i.sstatic.net/goo7Y.png

Upvotes: 2

Views: 1103

Answers (1)

Amira Bedhiafi
Amira Bedhiafi

Reputation: 1

According to the Documentation below, it is not supported to connect SSMS 2017 to SQL Server 2000.

See SQL Server Management Studio Supported SQL Server Versions

SQL Server 2000 instances can be managed using earlier versions of SQL Server Management Studio, but SQL Server 2000 management from SQL Server Management Studio 2014 is not a supported scenario.

Upvotes: 1

Related Questions