Server Name or Instance Name?

(0) Share

Report

Posted on by Community Member

Hello:

I had always heard that, when you move GP databases from one SQL server to another server that has a different name, GP user passwords will need to change.

First, on the "name", is it that the new server's name is different or that the SQL instance name is different?

I ask because, recently, we moved GP databases to a new server. But, the full SQL instance "name" (the SQL server name before and the SQL instance name after the "\" character) are the same on both the old and new servers.

Too, the new SQL server is on a different domain, even though the SQL server name before the "\" character references the name of our previous domain.

And, I did end up having to change the GP user passwords.

It's no "big deal" or emergency. I'm just curious, on all of this.

Thanks!

John

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Community Member on at

Like (0)

Report

Let’s say you have a two diff. Domains – ABC & XYZ.

On the ABC domain:

OLD

Server System Name: ABCServr

SQL Server Instance Name: ABCSql

Full SQL Server Instance name would be: ABCServr\ABCSql (ping to ABC domain)

Now on the XYZ domain:

NEW

Server System Name: ABCServr (New server with same old server name)

SQL Server Instance Name: ABCSql (New server with same old server name)

Full SQL Server Instance name would be: ABCServr\ABCSql (ping to XYZ domain)

Please let me know whether we both are on the same page or not. If we are on the same page than I hope the above details will help you to understand the diff. between the “domain name “, “Server System Name” & “SQL Server Instance Name”.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Bob!

Thanks, for the quick response!

In terms of moving does the difference in "name" reflect the server name or instance name?

Also, based on what you were saying, does that mean that IT did not move the server to a new domain?

John

Was this reply helpful? Yes No
Verified answer

Victoria Yudin 22,769 on at

Like (1)

Report

John,

If the ODBC Dynamics GP uses to connect to the SQL server is using the server name, then the answer to your question is BOTH. If either the server name or the SQL instance name changes you will run into the issue you saw with the passwords.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

John,

Hope Victoria's answer will give you more insight.

To answer your question for "....ed on what you were saying, does that mean that IT did not move the server to a new domain..."

No, It doesn't mean that. May be they have moved the server to a new domain but with the same as old server name.

Was this reply helpful? Yes No
relazmeh 115 on at

Like (0)

Report

We ran into the same issue when we moved from one SQL server to a new one with a different name using the default instance. GP uses the server name from the ODBC driver and concatenates it to the user password before encrypting it. We had to change all users passwords.

Was this reply helpful? Yes No