Skip to main content
To homepage To homepage

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

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


Terms and ConditionsCookie settings