Change Database Ownership from a restored database
Posted on 2013-11-01
I have a MS SQL 2000 server that I took the backup databases from, and restored them to a new and differently named MS SQL 2008 R2 server.
The restore went fine, and I can browse the tables and run queries.
I am installing an ERP Database Server Software (Infor Syteline 8.03) in a linked multi-site environment.
When I got to link the databases, I get the following error.
"Failed to link the database as multi-site:
[Microsoft][ODBC SQL Server Driver][SQL Server] Could not find server 'OLD SERVER NAME' in sys.servers. Verify thath the correct server name was specified. If necessary, execute the stored procedure SP_addlinkedserver to add the server to sys.servers.
[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated."
I guess I am looking for a Query to change "OLD SERVER NAME" to "NEW SERVER NAME"
The stored procedure sp_addserver 'NEW SERVER NAME', 'local'; will not work because it says the server already exists.
I did not migrate the master database to this server. could that be the issue.