problem connection from installation to the repository

[Former Member]

Hi ,

i am trying to install Data Services and i have problem with the repository as part of the installation.

first in install the IPS 4 on Windows 64 bit , i choose to create new database as part of the repository

and it's create 2 database in Sql Server (BOE140 & BOE140_Audit)

and the installation complete successfully and i can open the url of cms.

then i try to install the data sevices 4.1 , first i create new database for data services (bo_ds_repo)

and when i choose "Use Exsisting data base server " for repository

i choose Sql server and fill the following:

registration name of CMS - BOE140 (the ips database)

database server name - MIKEBO-SRV-HZ\BOE140

port - 1433

database name - the new database that i create for data services ( bo_ds_repo)

user name - sa

password - password of user sa

and when i click on Next button i receive the following error:

unable to check connection to repository

can not open database "bo_ds_repo" requested by the login. the login failed.

there is no problelm to connect to the database in Sql Server

what i am doing wrong?

regards,

Ilan Haik

[Former Member · Accepted solution]

The database created would not have sufficient privileges. Did you create with SQL authentication?

Arun

[Former Member · Accepted solution]

Hi,

Make sure you are using default the  port 1433. May be you  have a dynamic port.

It's a possibility! so ask your dba to verify this or :

Check that in Start> Microsoft SQL Server 200x > Configuration Tools, and then click SQL Server Configuration Manager.

Expand SQL Server Network Configuration,  <instance name>,   then TCP/IP.

You should see the port somewhere at the end of the list.

Else check what it says in the setupengine.log in the %temp%

Let me know if this helps.

regards

Nawfal Tazi

[DayaJha]

Hi Haik,

Please refer the below SNotes From SAP Market place.

1530972 - How to use a Microsoft SQL Server 2008 Express database for a local repository - Data Services 4.0

Links:

https://service.sap.com/sap/support/notes/1530972

Hope this will help you as well.

Thanks,

Daya

[former_member200473]

Hi Haik,

As Nawfal has suggested for TCP/IP, i would like add here one more to check for Shared Memory also.

Both should be Enabled and active(as per my knowledge)

Regards,

Shiva Sahu