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

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