-2

I am, !!!finally!!!, migrating my windows ecosystem to windows 11 and sql latest versions. But meanwhile I already have pcs with windows 11 and sql 2000 is still around and they don't like each other :-/

Excel to SQL, Excel to analisys Services, access to SQL all work great in up to windows 10 but fail in windows 11.

I get all sort of errors related with, I suppose, encryption. Any way to solve this?

I know that odbc 18 changed the default encryption to YES, but, as far as I can see, odbc 11 is installed.

access connect error

I already tried activating SSL 3 and TLS 1 in control panel, but doesn't work.

thanks, Cláudio

Cláudio Tereso
  • 7
  • 3

2 Answers2

0

after battling the same problem today, I figured out that it was related to Windows 11 Update 2022H2, which I had installed on my machine last week. Microsoft lists a known issue in regards to TLS/SSL handshakes, which was presumably fixed in an optional update here: https://learn.microsoft.com/en-us/windows/release-health/status-windows-11-22h2#2924msgdesc

I was unable to install the patch, which is supposed to fix the problem (https://support.microsoft.com/en-us/topic/october-25-2022-kb5018496-os-build-22621-755-preview-64040bea-1e02-4b6d-bad1-b036200c2cb3) and thus opted to just revert to the previous build for the time being. It instantly fixed the issue.

I hope this helps

fm51
  • 1
0

Connect from Windows 11 to mssql 2000 get list database get driver version get version mssql 2000

  1. Get Driver from Directory \LIB from this archive https://www.akadia.com/download/documents/sqlsrv_jdbc.tar.gz
  2. Text APP.java
  3. Good Luck

package org.example; import java.sql.*; /** * Microsoft SQL Server 2000 JDBC test program FROM WINDOWS 11 * public class App { public App() throws Exception { // Get connection DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); Connection connection = DriverManager.getConnection( "jdbc:microsoft:sqlserver://IPMSSQLSERVER2000:1433", "LOGIN", "PASS"); if (connection != null) { System.out.println(); System.out.println("Successfully connected"); System.out.println(); // Meta data DatabaseMetaData meta = connection.getMetaData(); System.out.println("Driver Information"); System.out.println("\tDriver Name: "+ meta.getDriverName()); System.out.println("\tDriver Version: "+ meta.getDriverVersion()); System.out.println("\nDatabase Information "); System.out.println("\tDatabase Name: "+ meta.getDatabaseProductName()); System.out.println("\tDatabase Version: "+ meta.getDatabaseProductVersion()); // Select some data - database name list Statement select = connection.createStatement(); ResultSet result = select.executeQuery("use master\n" + "\n" + "\n" + "create table ##dbtable(dbname varchar(100),tablename varchar(1000))\n" + "\n" + " \n" + "\n" + "exec sp_MSforeachdb 'USE [?]; declare @dbid int;set @dbid= db_id(); if @dbid not in(1,2,3,4) insert into ##dbtable select TABLE_CATALOG dbName,TABLE_NAME from INFORMATION_SCHEMA.TABLES '\n" + "\n" + "select dbname from ##dbtable group by dbname"); while (result.next()) { System.out.println(result.getString(1)); } } } public static void main (String args[]) throws Exception { App app = new App(); } }

user21527790
  • 1