Solved

Cannot read objects from SQL server - Undetermined SQL Server version during read of source schema

  • 7 April 2021
  • 8 replies
  • 103 views

Hi

I am connecting to a SQL database.

I can browse the database through SSMS and i can "Test connection" successfully.

The problem is that i cannot read objects from the database. I get the following error:

If you need assistance, please submit this with your ticket.

Undetermined SQL Server version during read of source schema

Location: Business Unit 'test', Data Source 'test'.

Details:

Undetermined SQL Server version during read of source schema
Module: timeXtender
System.Exception
at TimeXtender.DataManager.DataSource_Sql.get_IQuery()
at TimeXtender.DataManager.SSISEngineBase`1.CreatePackage_InformationSchema(IInformationSchemaProvider informationSchemaProvider, IDataSource_Sql dataSourceSql, ReadInformationSchemaType readInformationSchemaType, Guid sourceId, Boolean deleteExistingRecords, String queryOverride)
at TimeXtender.DataManager.DataSource.RefreshInformationSchema()
at TimeXtender.DataManager.ReadDataSourceObjectsCommand.Read()
at TimeXtender.DataManager.ReadDataSourceObjectsCommand.<>c__DisplayClass6_0.<ExecuteCommand>b__0()
at TimeXtender.DataManager.ConnectingThread.ExecuteConnectingThread(Object dummy)

Undetermined SQL Server version during read of source schema
Module: timeXtender
TimeXtender.DataManager.ExceptionWrapperException
at TimeXtender.DataManager.ConnectingThread.HandleError()
at TimeXtender.DataManager.ConnectingThread.Execute(String title, Int32 progressSteps, List`1 actions)
at TimeXtender.DataManager.ReadDataSourceObjectsCommand.ExecuteCommand()

Time: 2021-04-07 12:34:55
UTC: 2021-04-07 10:34:55
Title: test - Discovery Hub 19.9.1.64
Application: 19.9.1.64
Repository: 19.9.1.64
SQL Server: Microsoft SQL Server 14.0.3281.6 NT x64
User: moso
Domain: FIN
OS: Microsoft Windows Server 2012 R2 Standard
OS version: Microsoft Windows NT 6.2.9200.0
Machine name: AS-FIN-HOTEL
CPU count: 4
Build: 64 bit

icon

Best answer by jens.mikkelsen 7 April 2021, 15:23

View original

8 replies

Do you have read rights on the database you are reading from?

Regards Jens Jørn

Yes, and i can read from SSMS.

My own AD-user has rights and the service-user i will be using for executions later on.

Are there specific rights that i might need?

Yes you need to have READ (Datareader) rights.

SQL Server version you are reading from?

Regards Jens Jørn

I am reading from SQL Version 2019. That's probably the problem, since i am on TX version 19.9.1.64

Hi Morten.

Try to use the latest version instead, (10.15.x.x)

Regards Jens Jørn

I would really prefer not to update, since that would require upgrade of existing projects.

Is there a way of avoiding this? Upgrade of SQL-connector/driver?

Hi Morten.

No - but you could install the new version of timextender together with the existing just to verify that this solves the problem.

REMEMBER to use a different repository for the new version.

PS. Please call me if you want to talk about this.

Regards Jens Jørn

 

 

Dear Jens

Thanks for the quick support.

I am not ready to update, instead I have decided to use a combination of LINKED SQL SEVER and a QueryTable as source.

Thanks :)

Reply