Failed to execute SQL command. Invalid Column name 'PrintedLabelId'.

Gabriel Fuentes

• September 02, 2020 14:13
• Edited

Hi,
using Bartender 2019 156128 x64, The "BarTender System Database Setup" wizard while creating the "BarTender" database in my SQL Server instance fails.

 after setting:

server name : myServer

Authentication: SQL Server Authentication

Login Name: sa

password: mypassword

it fails in 'Setting up the Bartender System Database' step



the logging user has all of the privileges of my SQL instance(sa user).


I tried with sql2016, sql 2017, sql2019, all of them with the same error

there is not even logs in 'history explorer'

the environment is:
windows server 2019 standard


how can we solve this problem?

0

• 

  Gabriel Fuentes

  ★ BarTender Hero ★

  • September 10, 2020 14:10

  The issue for this problem was about the Server Collation on SQL
  
  
  
  my environment was running with
  Server Collation   --  Latin1_General_BIN
  
  
  I had to rebuild the master database and modify the server collation to:

  Server Collation   -- SQL_Latin1_General_CP1_CI_AS
  
  
  
  after rebuilt the master database following the steps:
  https://docs.microsoft.com/en-us/sql/relational-databases/databases/rebuild-system-databases?view=sql-server-ver15
  https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation?view=sql-server-ver15
  
  I ran again the BarTender System Database Setup successfully
  
  
  
  

  0

Please sign in to leave a comment.