Skip to main content
Solved

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


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

Best answer by jens.mikkelsen

Hi Morten.

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

Regards Jens Jørn

View original
Did this topic help you find an answer to your question?

8 replies

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

Regards Jens Jørn


  • Author
  • Starter
  • 4 replies
  • April 7, 2021

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


  • Author
  • Starter
  • 4 replies
  • April 7, 2021

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


  • Author
  • Starter
  • 4 replies
  • April 8, 2021

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

 

 


  • Author
  • Starter
  • 4 replies
  • April 8, 2021

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 :)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings