When running the upgrade of Messagestats OCS Report Pack 3.0.0 an error occurs at the stage of "Adding necessary tables to the MessageStats database"
Failed to execute the database creation script
Error code = -2147217900
Error Message = Idispatch error #3092
Error Source = Microsoft OLE DB Provider for SQL Server
Error Description = OLE Data Provider "SQLSERVERNAME" for Linked Server "OCS LINKED SERVER" returned message "login timeout expired".
If the Messagestats OCS Report Pack has been linked to multiple OCS Front End servers over the cause of using OCS Report Pack and there are multiple "Linked Servers" showing in the SQL management Console this error is generated.
An example of multiple Linked servers being visible would be an old linked server created for an old decommissioned OCS 2007 environment, and a new OC 2007 R2 CDR server linked and currently in use.
Delete the old Linked Server using SQL Management Studio:
1) Login to SQL management studio
2) Navigate to Server Objects | Linked Servers node
3) Confirm a legacy Linked Server exists under this location and delete if safe to do so using Right Click "Delete"
** Do not delete the current OCS Front End Server which is Linked and being used for Messagestats OCS Report Pack Gatherings. ** If in doubt contact Quest Support via support@quest.com
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center