Installation BODS 4.1 issue

[Former Member]

Hello Community,

while trying to install BODS 4.1 I get an error message defining the repository database connection:

"unable to check connection to the repository

Login failed for user <sa>"

Following configuration parameters and environment. This is the same machine.

• MS Windows Server 2008 SP2
• BOE 4.0 SP05 Patch5
• MS SQL Server 2008 SP2. The Database <BOE140> has been created automatically by the installation of the BOE 4.0.

I tried to define the connection using the sa user and the new created account:

BOE repository is in the same Server and is working fine. I created another Database <BODS41> on the same SQL Server and granted the owner permission for a new created <bodsuser> exactly in the same manner as I have done it for the <boeuser>.

I always tried to use the Windows Authentication. The same error message... My Windows account is always granted as owner in the Database. Logon to the MS SQL Server directly works fine.

Any ideas?

Regards

Stan

[DayaJha · Accepted solution]

Hi Stan,

Issue is not with the Installation of SAP Business Objects Data Services 4.1, its regarding rights & security for accessing SQL Server that you applied on "BODSUSER" .

Please refer the below URL for Create a SQL Login User in SQL Server 2008:

Links:

http://www.c-sharpcorner.com/uploadfile/dhananjaycoder/create-a-sql-login-user-in-sql-server-2008/

http://databases.about.com/od/sqlserver/ht/Creating-A-Sql-Server-2008-Database-Account.htm

http://stackoverflow.com/questions/1719399/sql-server-2008-cant-login-with-newly-created-user

http://blog.sqlauthority.com/2008/12/27/sql-server-add-any-user-to-sysadmin-role-add-users-to-system...

Links for Installation & Configuration of SAP Business Objects Data Services:

Note: You can deploy SAP Business Objects Data Services with SAP Business Objects Business Intelligence Or SAP Business Objects Information Platform Services.

Links:

http://sapbods-knowledgeshare.blogspot.com/2012/06/sap-bods-4o-installation.html?zx=ddffaf1b58fc4831

http://guozspace.wordpress.com/2012/04/28/sap-business-objects-bi-4-0-installation-steps/

Hope this will help you as well.

Thanks,

Daya

[Former Member · Accepted solution]

Hi Daya,

thank you for reply! But it cannot be the SQL Server security issue, because as I wrote:

Login failed always for the sa user.

Any other ideas? 🙂

Regards,

Stan

[Former Member · Accepted solution]

For better comparison:

[DayaJha · Accepted solution]

Hi Stan,

Please Check the Following Points:

• Problem is not with the login, you are giving the Instance name along with the hostname,you need to give only the hostname (W2KB-SAP) not (W2KB-SAP\BOE140)

If Still you are facing the Same Issue then  Use the "IP Address" of "SQL Server 2008 R2" Instead of Name.

Hope this will help you as well.

Thanks,

Daya

[Former Member · Accepted solution]

Stan,

Issue is with the SQL PORT you are using. 

Yes by default SQL Server uses PORT 1433, However you are using a named instance in SQL server and each named instance will be assigned a unique PORT.

See KBA 1530972 -  How to use a Microsoft SQL Server 2008 Express database for a local repository

Not sure if you are using the SQL express or not but the issue would be the same as is the resolution.  You need to know what PORT the named instance is on…

A-     Identify the port number used by Microsoft SQL Server

1-      Navigate to Start > All Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager

2-      Click SQL Server Network Configuration

3-      Click Protocols for BOE140

4-      Double-click TCP/IP

5-      Click the IP Addresses tab

6-      Locate the IPAll section

7-      Make note of the port number listed for TCP Dynamic Ports. You will need this number later.

8-      Exit SQL Server Configuration Manager

Hope it helps

Mike

[Former Member · Accepted solution]

Hi Mike,

this was the great hint! Thank you very much! It works now.

Kind Regards,

Stan