I was asked to make a new instance of SQL Server and copy my databases to the new instance of SQL Server. The instance of SQL Server is complete and the logins are re-created. I can detach and re-attach encyclopedias from the old to the new instance (in the Professional mode). Where I am stuck is getting the Catalog Manager working. When trying to connect the Catalog Manager I keep getting an error of :
-Microsoft OLE DB Provider for SQL - Description: Valid Object name "master.dbo.spt_values"
This error also appears when I try to connect to the instance using SAEM. I can connect with Microsoft SQL Manager but not SAEM.
Somewhere there must be some kind of initialization that was skipped in setting up the new instance of SQL Server.
Any suggestions are greatly appreciated.
(I am not the dba that created the new instance, but obviously I have an interest in getting it working)