Etap Knowledge Base: Sql Server Project Error

ETAP Knowledge Base

SQL Server Project Error Description: “Error inserting the revision 784 into Table Revision Control, error - Could not find server 'MACHINE_NAME\SERVER_INSTANCE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers." Category:

Error, SQL Server Project

Type:

Error, Installation

Keywords:

SQL Server, SQLEXPRESS, Database

Error: Creating new SQL Server project While processing 101402.cvt it gives an error: "Error inserting the revision 784 into Table RevisionControl, Error - Could not find server ' MACHINE_NAME\SERVER_INSTANCE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers." Cause: It appears that SQL Server Express installation was configured for a machine named OLD_NAME, so the default server name created internally was OLD_NAME\SERVER_INSTANCE. This occurs when the machine was renamed after the installation of SQL Server. The queries "print@servername" and "select * from sys.servers" should confirm this by listing the server as OLD_NAME\SERVER_INSTANCE. Solution: To repair, run the query: exec sp_dropserver 'OLD_NAME\SERVER_INSTANCE'; go exec sp_addserver ' MACHINE_NAME\SERVER_INSTANCE', local; go exec sp_serveroption ' MACHINE_NAME\SERVER_INSTANCE', 'data access', 'true' go Restart "SQL Server (SQLEXPRESS)" and "SQL Server Browser" services.

This document is confidential and proprietary to Operation Technology, Inc. and may not be reproduced, published or disclosed to others without the written authorization of Operation Technology, Inc., 17 Goodyear, Suite 100, Irvine, CA 92618, USA. © 2010 by Operation Technology, Inc. All Rights Reserved.

© Operation Technology, Inc.

Page 1 of 1

ETAPKB