Data Services Installation problem

[#1]

Hi Experts

My present scenario , I have to build Business objects Enterprise,Webi.Portal and Dataservices.Ou server Enviornment is

1. Windows 2003 Enterprise X64 Edition

2. SQL Server 2008.

Both BI and BO will be in same machine / server

I have installed the follwoing components and with the sequence as given.

Before installing BOE as per the guide i had created a Database (DBSID: BOB) in MS SQL Server and a user with ( OS level Adminstrator and Users group added). And created an user SERVERNAME\bobadm. and odbc DSN was cerated from c:\windows\syswow64 as well as from contraol panel also thro windows authentication which test data was successful.

Now

1. Installed BO 3.1

2. Installed SAP GUI 7.1 ( with BW and BI addon)

3. Installed Java Connector and placed the library files as required.

4. Installed Crystal Reports 2008 V1.

5. Installed Integration Kit for SAP and Configured.

Here when i check at the MS SQL Server cud see the tables were created by the CMS application and all my data were stored.And i cud do logon from CMC,InfoView,Webi to my BI SAP server. I cud able to see the roles which i have created in BI server.

HERE now my next requirement is to install BO DataServices and BO Portal. which were new to me as above.

For BO Dataservices i started installation i had given thro Windows authentication and after the Configure Metadata Integarator step i had provided the details of the Database with port number as 6400 ( CMS default port) which triggered the following error

An I/O error occurred while receiving the TDS prelogin response.

and the next err:

The database exists but the repository tables are not valid. (BODI-300032)

and the next err

(12.1) 09-07-10 14:05:41 (E) (8784:8684) CON-120302: ODBC call <SQLDriverConnect> for data source <SERVERNAME> failed: <MicrosoftODBC SQL Server DriverSQL ServerLogin failed for user 'bobadm'.>. Notify Customer Support.

(12.1) 09-08-10 14:39:16 (E) (3208:8608) CON-120302: ODBC call <SQLDriverConnect> for data source <SERVERNAME> failed: <MicrosoftODBC SQL Server DriverSQL ServerLogin failed for user 'bobadm'.>. Notify Customer Support.

(12.1) 09-08-10 14:39:26 (E) (8492:1636) CON-120302: ODBC call <SQLDriverConnect> for data source <SERVERNAME> failed: <MicrosoftODBC SQL Server DriverSQL ServerLogin failed for user 'SERVERNAME\bobadm'.>. Notify Customer Support.

(12.1) 09-08-10 14:40:16 (E) (6192:8380) CON-120302: ODBC call <SQLDriverConnect> for data source <SERVERNAME:6400> failed: <MicrosoftODBC SQL Server DriverDBNETLIBInvalid connection.>. Notify Customer Support.

I think the err is the application coudl; not loginn through the SQL Authentication. and what is the issue.

[Former Member]

Hi

Thanks for ur reply.But here while installation of Data Services itself it throws the error.Installation steps in the setup wizard it check the job server and then access server and after that the Metadata Confiuration where it throws this error. when i skip the Metadata Configurators it runs and installation successful. But our need is Metaadata Configuration where it si skipped.

Why it is giving error.

[Former Member]

Hi Bala,

Please try to manually login to SQL server with the user boadm. If it works fine, then you can try to do the metadata configuration by using the "Data services Metadata integrator" link that is available under program files--> Data services... Note that in Data services, we are not using DSN to connect to DB. We need to give your SQL server hostname and DB name.

Thanks,

Ravi