Database migration admin tool run error

Usage and Config Platform
1

2018-12-05

Dear all,

I have followed below given steps for database migration.

1.  Stop all BES Server services
2.  Detatch the BFEnterprise and BESReporting databases from the current SQL Server instance databases
3.  Move the BFEnterprise and BESReporting databases to the new SQL Server instance
4.  Attach the BFEnterprise and BESReporting databases to the new SQL Server instance
5.  Modify the ODBC System DSNs (bes_BFEnterprise, bes_EnterpriseServer, enterprise_setup, and    LocalBESReportingServer) to point to the new SQL server instance. This modification will allow you to avoid re-installing the BigFix Server application.

*Use ODBC connection wizard to test connection
*For 64-bit Windows systems, use the 32-bit version of the ODBC tool (C:\Windows\SysWOW64\odbcad32.exe) to configure the System DSNs.

I have migrated database to another new Bigfix server where only SLQ is installed. I need to open Admin tool, attached image showing error.

Kindly support regarding Admin tool.

1 Like
2

Are you trying to migrate your server to a new machine, or just trying to test a database upgrade?

The error says you are missing a stored procedure which has existed for quite a while, so either the stored procedure didn’t come over with the database for some reason, or you don’t have permission to see the stored procedure. You can check in SQL Mgmt Studio whether you see the sp under the Programmability section of the BFEnterprise db. If it’s there, then make sure you are a dbowner in the new SQL Server.