MediaBin install/sql question

Hello,

We got our dba to create the media bin database from the sql files located in the Media Bin Directory. However, when I attempt to configure the database to use with media bin it still asks me for the SQL superuser name (SA) and password. Here are the step I performed:

1. Ran the installation program. When prompted for the database connection information I hit cancel.
2. DBA created database and prepopulated tables using the following scripts:
- default_mbsettings.sql
- schema.sql
- sp.sql
3. A system DSN was set up.
4. The Media BIn Admin Console (MBPAdminConsole.exe) was ran and I selected "use an existing database" when prompted. I provided the correct username and password.

Then the following dialog box appears:

"In order to configure the MediaBin database on <SQL SERVER IP>, <SQL USER> must be a member of the Database Creators role.

To have the installer add <SQL USER> to the Database Creators role, please speify a SQLServer System Administrator login such as 'sa'"

Is there a way to by-pass this as the database and all tables have already been created? Why does this user need to have permission to create databases? Will it need to create a new database as part of its normal operations?

Find more posts tagged with

Comments

lyman

What version of MediaBin are you trying to install? I take it from context that this is a SQL Server (not Oracle) install.

Thanks,

Lyman Hurd
MediaBin Server Team

MediaBin Server Team
Interwoven, Inc.

CBCOperations

This would be version 4.5 SP1 and yes MSSQL Smiley Happy

lyman

Aha! Our install guru will be adidng to the thread shortly, but basically there has to be a user MBSQLUser and that user must have dbo privileges for the MediaBin database. You should be prompted for sa only to create a user if the installer thinks such a user does not currently exist. In ongoing operation (i.e., post-install) there is no requirement for MediaBin to have sa privileges.

Cheers,

Lyman

MediaBin Server Team
Interwoven, Inc.

CBCOperations

Thanks for your reply ! Smiley Happy

So does the username *have* to be MBSQLUser? Currently (and the user/password that I typed into the install dialog box) is "EPTZERO".

Also, if a user named MBSQLUser with dbo privleges is created.. can it be deleted after the install is complete? or is it needed during the operation of Media Bin?

Thanks again!

lyman

The name does not matter. Dbo permission does.

Cheers,

Lyman

MediaBin Server Team
Interwoven, Inc.