we have a gp 2010 (server name is gp2) running on a virtual server. I made a copy of the VM, and renamed it to gp4.
I want to install gp2010 sp3 on gp4. Installed fine except when I try to run GP Utilities, it points to gp2 (even though I have changed the data source to point to gp4).
pls help!
*This post is locked for comments
Thanks!
Varesh is correct that you need to run the following scripts:
SELECT @@servername
SELECT * from master..sysservers
sp_dropserver '<WrongSERVERNAME>'
sp_addserver '<RightSERVERNAME>', local
SQL Express is what I am using; I am using SQL Management Studio to manage SQL Express
You are using SQL Express or SQL 2005/2008.
when I execute SELECT @@SERVERNAME
I get the following gp2\SQLEXPRESS
the other statements that you gave give me an error (see below)
Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 42
The server 'GP2' does not exist. Use sp_helpserver to show available servers.
Msg 15028, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 89
The server 'GP4' already exists.
1. Update the ODBC DSN connection on Server GP4
2. When you make a copy of the VM the SQL server instance name has not been changed.
The query below will give you the SQL instance name which will be still GP2 on GP4 server
SELECT @@SERVERNAME
Login into the SQL server as sa and update the SQL server instance name
sp_dropserver GP2
GO
sp_addserver GP4, local;
GO
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,387
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
