BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

BO 4.2 SP8 - Incorrect syntax near ‘-‘… during install


 
Search this topic... | Search XI Server Discussion... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Author Message
KMerrills
Forum Member
Forum Member



Joined: 27 Aug 2010

Posts: 23



PostPosted: Tue May 19, 2020 6:19 pm 
Post subject: BO 4.2 SP8 - Incorrect syntax near ‘-‘… during install

I am installing Business Objects 4.2 SP8 onto a clean Windows Server 2016 standard edition environment. We are using SQL Server 2016 as well.
All prerequisites are complete including creating SQL ODBC connections to the database server, in addition, I am installing as the service account which has modify rights to a blank CMS database.
During the install, I am attempting to Configure CMS Repository Database SQL Server (ODBC), I get the following error message

“Failed to retrieve cluster name from the database. Reason: Database access error. Reason [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ‘-‘…

Any ideas are greatly appreciated.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19351
Location: Bratislava


flag
PostPosted: Wed May 20, 2020 1:35 am 
Post subject: Re: BO 4.2 SP8 - Incorrect syntax near ‘-‘… during ins

[Moderator Note: Moved from General Discussion to Server Administration, Installation, Upgrades -> XI Server Discussion]
Back to top
JohnBClark
Forum Enthusiast
Forum Enthusiast



Joined: 27 Mar 2007
ASUG Icon
Posts: 1049
Location: Appleton, WI USA


flag
PostPosted: Thu May 21, 2020 8:39 am 
Post subject: Re: BO 4.2 SP8 - Incorrect syntax near ‘-‘… during ins

I would double check your database connectivity and make sure your ODBC DSN is configured correctly. I've been working pretty extensively with 4.2sp8 as we are in the midst of an upgrade and I haven't had any issue like this.
_________________
BusinessObjects BI4.2sp4, SQL Server 2016 (CMS)
Clustered for fail over redundancy
Reporting Tools: Crystal Reports 2016sp4, Web Intelligence
Operating System: Windows 2016 running on VMWare
Reporting databases: SQL Server, Teradata, DB2, Oracle, Hive
Information Steward 4.2sp10
History: BO5, BO6, XIR2, XI3.1, BI4.1.x
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0270 seconds using 17 queries. (SQL 0.0020 Parse 0.0009 Other 0.0241)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo