Configuring database while Installing MediaBin server

Installing Media Bin 8.0.3 on window 2008 R2 standard enterprise.

We are getting following error while configuration of database.

Have attched screen shot for reference. We have already created new empty database into SQL Server database. Are not able to configure same while installation. Current getting following issue.

Please, get us know if we need to uninstall software or we can mention database details again just like page 36 of "Virage_MediaBin_8.0.3_Install_rev0_en.pdf" document.

We have create ODBC DNS while doing installtion.

INSTALLATION CONFIGURATION RESULT: Fail

____________________
Task: MediaBinAsset Server Settings
Description: Executed database scripts
Result: Fail
Details:
Fail: System.Data.Odbc.OdbcException: ERROR - 08001 - - Microsoft - - ODBC SQL Server Driver - - Shared Memory - SQL Server does not exist or access denied.
ERROR - 01000 - - Microsoft - - ODBC SQL Server Driver - - Shared Memory - ConnectionOpen (Connect()).
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at MediaBin.Configure.Tasks.MediaBinAssetServerSettingsTask.DoTask()
at MediaBin.Configure.TaskBase.Run()

____________________
Task: MediaBin Server Service command line
Description: Stopped and started MBPServer service
Result: Fail
Details:
In DoTask(): Fail: Windows Service NOT found: MBPServer
In DoTask(): Fail: Windows Service NOT found: MBPServer

Find more posts tagged with

Comments

Rick Poulin

Fail: System.Data.Odbc.OdbcException: ERROR - 08001 - - Microsoft - - ODBC SQL Server Driver - - Shared Memory - SQL Server does not exist or access denied.

What steps have you taken to troubleshoot the quoted line?

mishravik

We had permission issue with user for SQL database.

But now we are not sure how we can go back to SQL database configuration screen and mention details for database configuration.

We can mention database details again just like page 36 of "Virage_MediaBin_8.0.3_Install_rev0_en.pdf" document.

birt-aggregation-workaround.png

Reji Varghese

Did you manage to fix this issue ?

There are some tools which you can use to fix this :

\MediaBin Server\utils\Tools

You can re-run the .exe as an Administrator and try.

Migrateduser

Looks like the MediaBin Database is not configured by the installer and the MediaBin Server service is also not created by the installer.

Check Windows services panel of MediaBin Server service exists. Also check if MBSettings table on the database if it is updated with ImageDB and Internal Server Name rows. The same can be confirmed by verifying [HKEY_LOCAL_MACHINE\Software\Wow6432node\MediaBin, Inc.\MediaBin\Platform\CurrentVersion\]

If the above exists, you can run the MBPAdminConsole.exe (will be under ...\MediaBin Server\ installation folder) as an administrator and see if you are getting Upgrade existing, Create New MediaBin instance and Do Nothing options. If you see these options, you can run Upgrade existing MediaBin server to get the MediaBin Service recreated.

If MBDataDirectory path and installation folder paths screen are displaying in MBPAdminConsole.exe screen, the server is not configured and you need to proceed further in the same MBPAdminConsole.exe screen finish the configuration.

Is SQL Server running locally on MediaBin Server machine?

Thanks,
Ravi

Migrateduser

Realized that this is an old thread and I hope the issue was fixed long time back.