Upgrade to a version of SQL that is currently supported on BarTender 2021
I have installed the BarTender Designer 2021 R2 with the SQL 2014. As SQL 2014 is no longer supported, how can I upgrade to a version of SQL that is currently supported? Thank you.
-
You would need to download a later version of SQL and once it is installed create the system database to that version.
Not exactly the same but this may help
-1 -
Hi. Were you able to successfully install a newer version of SQL and remove all 2014 components?
I have had an email from support as recent as last week telling me that “2014 local db MUST be installed for Bartender to work properly. Removing it will cause it malfunction” which I think is terrible considering 2014 has been out of support for a while…
I just want to remove outdated software…!
-1 -
Callum Emmerson Support have recently advised us that “SQL Server 2014 Express LocalDB” is the only version that will run the Bartender Licensing Service. We are on Bartender 2021 but apparently 11.4 and 11.11 licensing services are also dependant on “SQL Server 2014 Express LocalDB”. Support said "Okay, I will add this ticket to the feature request = "Update SQL Server 2014 Express LocalDB to latest supported version".
1 -
Same here. We have it running on SQL Express 2022, but it still seems to need LocalDB 2014. This is unacceptable as it's been EOL for almost 2 years now. I'm now placed once more into a situation where I have to consider whether we urgently need to migrate to a new labelling system because at present this would fail our cyber security audit.
1 -
After searching around more, I found that Bartender Integration Service is looking for:
%ProgramFiles%\Microsoft SQL Server\120\tools\binn\SqlLocalDB.exe
This appears to be hardcoded? Even if you're using your own up to date SQL Express installation. Designer throws an error but continues working. Integration service refuses to start.My workaround is to put a fake SqlLocalDB.exe there. It does need to be a valid executable so I made an empty one. You should compile it yourself so that you know for yourself that it does nothing. SqlLocalDB.cs:
class nop { static void Main() { } }Compile with c:\windows\Microsoft.NET\Framework\v4.0.30319\csc.exe /t:winexe SqlLocalDB.cs
Job done. Designer still complains, but Integration works again.
It'd be nice if this hardcoded search can be removed/updated.
I accept no responsibility if this causes unexpected issues and these messages are my own thinking, not necessarily that of my employer. Hopefully though it'd help someone else out who just needs it to work until Seagull catch up with the present.
0 -
I don't suppose version 12 fixes this? This would decide how quickly we roll it out :)
0
Please sign in to leave a comment.
Comments
6 comments