on 04-11-2013 10:27 PM
Hi everyone,
I'm installing a test system with Information Platform Services 4 , SAP Data Services 4.1 and Information Steward 4.1
I have successfully installed SAP IPS 4.
My issue is with the integrated database : i have selected the packaged database during the installation and have Microsoft SQL Server 2008 installed.
But now i'd like to install SAP Data Services and have to create a Schema , User and rights to create my repository.
But there is no tools available. I've tryed to install SQL management studio but i have incompatibility : what are the best practice to deal with this issue ? Install another tool ( Toad, ... ) ?
In the Data Services 4.1 install guide there is mention of a bundled DB2 Workgroup database ? Should I use this ?
Where should I download the media ?
Thanks a lot for your inputs.
Guillaume
Guillaume,
There is a KBA 1530972 - How to use a Microsoft SQL Server 2008 Express database for a local repository - Data Services 4.0 that details the steps to use SQLCMD to create the database.
KB can be found at http://service.sap.com/xsearch.
Hope this is helpful.
Thanks,
Paula
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guillaume,
Please share the exact "SQL Server error" in SAP Business Objects IPS Server.
Thanks,
Daya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The bundled package does not have SQL Server Management Studio, you need to install it separately. Or what you can do is install the full version of SQL Server 2008 R2 and configure with DS 4.1 during the installation.
After installing SQL Server Management Studio, you need to setup a user or retain the default 'sa' user and create a database. While installing SAP DS 4.0, you have to choose this database as the default repository which has the admin privileges.
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guillaume,
First of all, you have to check what is the incompatibility when you install SQL Server management studio. Is your machine 32 bit or 64 bit. Is management studio the right version. If your machine is 32 bit then install the right version of management studio. Once you fix it then you will be able to create schema, repository etc. as long as you have enough privileges. BTW, Are BODS server is Linux or Windows...just wanted to know because if you fix the above what i said you should be good.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.