tbyrne777
Cloud Wanderer

SQL Server Compatibility Error Upgrading Client Tools to 5.2

I'm trying to uprade my development workstation to K2 5.2 - this workstation only has K2 Studio, package and deploy, and the Visual Studio Designer components from 4.7. When attempting to run the 5.2 update, it is telling me that it doesn't support my version of SQL server. I don't even have SQL server installed on this machine, so where is it getting this information from? I have K2 5.2 successfully installed on servers with correct SQL server versions - how do I let the update tool know this?

0 Kudos
Reply
6 Replies
Mikhail2
Nintex Newbie

Re: SQL Server Compatibility Error Upgrading Client Tools to 5.2

It would be super helpful if you had provided exact error message text/screenshot along with step on which you getting error (outline of the steps can be found here). If you have reached Database Configuration page and specified SQL server which hosts your K2 5.2 DB I see no reason for SQL compatibility error. But I guess presense of local SQL server installation may trigger this warning. Just share error message screenshot here that may clarify what exactly is happening.

0 Kudos
Reply
tbyrne777
Cloud Wanderer

Re: SQL Server Compatibility Error Upgrading Client Tools to 5.2

Thank you, I've attached what the installer looks like and the error that gets reported. Note that it is only the client components that are installed and being updated, there should not be any dependency on SQL Server for these as I was able to install them with the 4.7 installer without issue.


k2_update_-_1_3437.png
0 Kudos
Reply
Mikhail2
Nintex Newbie

Re: SQL Server Compatibility Error Upgrading Client Tools to 5.2

So error reports that you have SQL server build10.50.2500.0 which means SQL Server 2008 R2 Service Pack 1 (SP1) which is 100% not something that K2 Five supports.


 


Does your K2 Five database hosted on SQL 2008 R2 SP1 server? I think no, but it can be that while you have SQL Server 2012 or newer yet you not upped your database compatibility level on K2 database, so maybe check this (see screenshot below which illustrates what exactly you need to check using SSMS UI).


 


7585i0FDD4E2B71D0F1F4.png

0 Kudos
Reply
tbyrne777
Cloud Wanderer

Re: SQL Server Compatibility Error Upgrading Client Tools to 5.2

Yes. my K2 server is using SQL server 2016 correctly and I had no issues upgrading the server - that is why I a most confused. Where is it looking on my developer workstation to determine that SQL server is out of date if I don't even have SQL server installed? Does it look at K2 Servers I've connected to in the past, perhaps?

0 Kudos
Reply
Mikhail2
Nintex Newbie

Re: SQL Server Compatibility Error Upgrading Client Tools to 5.2

I would consider logging support ticket attaching installer trace. A bit difficult to comment on that without having install trace and/or ability to have a look at the environment.

0 Kudos
Reply
tbyrne777
Cloud Wanderer

Re: SQL Server Compatibility Error Upgrading Client Tools to 5.2

Yep, that's what I ended up doing. I'll report back what they discover. Thanks!

0 Kudos
Reply