How do we change the dynamics server name for our test system?

(0) Share

Report

Posted on by Carole Collins

260

We cloned our production system and ran the scripts to change the SQL instance name and updated teh ODBC connection but when we launch the server it is still looking at the production server name. How can we change this name?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (4)

Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Assuming when you say launch the server you mean you are on the newly cloned server and launched the GP client on that server, please make sure you have changed the DSN on that server to point to the cloned server not the original. You may want to drop the DSN altogether just to make sure plus if the cloned server is 64 bit remember to do this using the 32 bit ODBC adminstrator. It sounds like your ODBC DSN is still pointing to the orignal server.

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

If you actually want to change of the SQL Server itself, try this:

1. Open SQL Server Management Studio and click New Query.

2. Type Select @@ServerName to find out the current server name. In our example, we’ll be changing the server name from RKF to REH.

3. Next, type sp_dropserver ‘RKF’

4. You are now ready to add the correct name by typing sp_addserver ‘REH’.

5. Stop sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver.

6. Restart SQL server by typing net start msssqlserver.

7. Restart SQL server agent by typing net start sqlserveragent.

8. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.

Kind regards,

Leslie

Was this reply helpful? Yes No
Carole Collins 260 on at

Like (0)

Report

We did change the SQL server name but when we launch, the server name says 'Dynamics GP 2010' and the error reads: 'Your attempt to log in to the servaer failed becasue an unknown error occurred when the user ID and password were being verified. Attempt to log in again. we changed the name of the SQL server to test-csogp2010db. How can we get the ID to point to this new name?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Two things to verify:

1. Make sure you are using SA user, as all other accounts will not work until doing password reset at the application level.

2. Make sure you changed the ODBC to point into the new server.

Was this reply helpful? Yes No
Verified answer

Vikas Gupta 2,626 on at

Like (0)

Report

we can change the server name from administrative tools-->>ODBC-->>System DSN-->>Dynamics GP -->> Click on Configure and then we change the setting for server and other settings also.

Thanks and Regards

Vikas Gupta

vikasgupta.gp@hotmail.com

Was this reply helpful? Yes No