Problem with create db via setup.bat

[horkysta]

Hi
System info:
Win 2003 server SP2 ( name: mercury )
MSSQL Express 2005
Problem:
When I create db via SQL Script\setup.bat SQLServer mercury\SQLExpress sa sapassword
system generate this errors:

LansweeperPro Database Setup
------------------------------------
Copyright (C) Lansweeper. All rights reserved.
http://www.lansweeper.com

Using Windows authentication
***********************************************************
*** Create Database ***
***********************************************************
***********************************************************
*** Build Database Objects and Populate with Data ***
***********************************************************
Msg 208, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30repUnauthorizedSoft, Line 4
Invalid object name 'tblapprovedsoftware'.
Msg 208, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30repallportables, Line 4
Invalid object name 'tblportablebattery'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 5
Invalid column name 'number in use'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 5
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 5
Invalid column name 'number in use'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 5
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 6
Invalid column name 'number in use'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 6
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 6
Invalid column name 'number in use'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 6
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 6
Invalid column name 'priceperlicense'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 9
Invalid column name 'number in use'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 9
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 9
Invalid column name 'number in use'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 9
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30OSlicensecompliance, Line 9
Invalid column name 'priceperlicense'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30licensecompliance, Line 5
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30licensecompliance, Line 6
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30licensecompliance, Line 6
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30licensecompliance, Line 6
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30licensecompliance, Line 7
Invalid column name 'priceperlicense'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30licensecompliance, Line 11
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30licensecompliance, Line 11
Invalid column name 'nrlicenses'.
Msg 207, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30licensecompliance, Line 11
Invalid column name 'priceperlicense'.
Msg 208, Level 16, State 1, Server MERCURY\SQLEXPRESS, Procedure web30repNoVPNPatchB, Line 4
Invalid object name 'dbo.web30repallportables'.
INSERTING DATA INTO TABLE tblsafeguids
INSERTING DATA INTO TABLE tsysactions
INSERTING DATA INTO TABLE TsysFiles
INSERTING DATA INTO TABLE TsysRegistry
INSERTING DATA INTO TABLE tsysreports
INSERTING DATA INTO TABLE tsysreportgeneral
INSERTING DATA INTO TABLE tsysreporthardware
INSERTING DATA INTO TABLE Tsysreporthomepage
INSERTING DATA INTO TABLE tsysreportserver
INSERTING DATA INTO TABLE tsysreportsoftware
INSERTING DATA INTO TABLE TsysWaittime


Please help me
Standa

[Hemoco]

Could you take a look at the database properties.
I'm pretty sure that you are using a case sensitive collation for the database.
If so, change it to case InsenSiTive

The table is named : tblApprovedSoftware <> 'tblapprovedsoftware'
Notice the capital letters.