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]

Issue not yet resolved.but i m closing the thread

[Former Member]

Hi

Yes i selected "Windows Authentication" but it gave the following error.

that is the start of my issue.

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

errorlog.txt:

(12.1) 09-08-10 14:39:16 (E) (3208:8608) CON-120302: ODBC call <SQLDriverConnect> for data source <SERVERNAME> failed: <[Microsoft][ODBC SQL Server Driver][SQL Server]Login 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: <[Microsoft][ODBC SQL Server Driver][SQL Server]Login 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: <[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.>. Notify Customer Support.

repoManBatch.txt:

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

TestDbConnectionErr.txt:

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

TestDbConnectionLog.txt:

09/08/2010 14:38:22 [ SEVERE ] Unable to create connection factory for Informix:com.acta.db.ActaInformixConnectionFactory. null (BODI-3013019)

09/08/2010 14:38:22 [ INFO ] Delaying the loading of DB2 JDBC driver classes. (BODI-3013011)

09/08/2010 14:38:54 [ SEVERE ] Unable to create connection factory for Informix:com.acta.db.ActaInformixConnectionFactory. null (BODI-3013019)

09/08/2010 14:38:54 [ INFO ] Delaying the loading of DB2 JDBC driver classes. (BODI-3013011)

09/08/2010 14:39:43 [ SEVERE ] Unable to create connection factory for Informix:com.acta.db.ActaInformixConnectionFactory. null (BODI-3013019)

09/08/2010 14:39:43 [ INFO ] Delaying the loading of DB2 JDBC driver classes. (BODI-3013011)

09/08/2010 14:40:42 [ SEVERE ] Unable to create connection factory for Informix:com.acta.db.ActaInformixConnectionFactory. null (BODI-3013019)

09/08/2010 14:40:42 [ INFO ] Delaying the loading of DB2 JDBC driver classes. (BODI-3013011)

09/08/2010 14:40:53 [ SEVERE ] Unable to create connection factory for Informix:com.acta.db.ActaInformixConnectionFactory. null (BODI-3013019)

09/08/2010 14:40:53 [ INFO ] Delaying the loading of DB2 JDBC driver classes. (BODI-3013011)

09/08/2010 14:50:41 [ SEVERE ] Unable to create connection factory for Informix:com.acta.db.ActaInformixConnectionFactory. null (BODI-3013019)

09/08/2010 14:50:41 [ INFO ] Delaying the loading of DB2 JDBC driver classes. (BODI-3013011)

regards

bala

[Former Member]

Hi

I checked the bobadm user in the SQL server where it is in disable mode.i coud no change also , now what i can prefer to do it

Regards

Bala

[Former Member]

Hi Bala,

Even if the authentication type radio buttons are in disabled mode, any one authentication radio button will be already checked.

In your case, i guess "Windows authentication" radio button is already selected. So in Data services, wherever you need to login to SQL server, please select windows authentication. It will work.

Regards,

Ravi

[Former Member]

Hi

I have tried to login with bobadm to MS SQL Server in SQL Authentication which fails.in my first query itself i told i had created the database BOB and user id in bobadm in OS and as well as in MS SQL Server Security also. When i trying to login with Windows Authentication it works and ithe setup wizard of BOE,Crystal rpeorts and other applications created tables there in the BOB database in MSD SQL server. but when i am trying to login thro SQL Authentication fails. So where should i give the authorization for the user bobadm in the MS SQL SERVER and what are all the permissions.

[Former Member]

Hi Bala,

As per my understanding, you have created a user boadm and its in windows. You are able to login to MS SQL by using windows authentication. But not able to login to SQL server management studio by using SQL server authentication for the user boadm. Since a user can not have both authentication types, you can not grant SQL server authentication to boadm (Login to SQL server management studio by using windows authentication--> click on security --> login --> boadm. right cick and go to properties. Here you can see that windows authentication is selected for this user). So in Data services, while creating metadata integrator you can select the "windows authentication" checkbox.

Regards,

Ravi

[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

[Former Member]

Hi Bala,

Please check that whether you have configured the Data Services repository during Data services installation? (Please note that Data services has its own repository to store the Data services jobs). If not, configure it by using repository configuration link (if Data services is already installed, then you can find it under Program Files --> Data services... Then you need to configure the job server. In the job server configuration wizard, point it to the newly created Data services repository. Then restart the job server.

Now you can successfully launch the Data services. In the Data services login screen, you need to give the information

of the respository that you have created in the previous step.

Regards,

Ravi