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

Gabriel Fuentes

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?

1 意見

Gabriel Fuentes
評論操作 永久連結

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:

I ran again the BarTender System Database Setup successfully