web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) I CAN'T CONNECT TO...

Microsoft Dynamics GP (Archived)

I CAN'T CONNECT TO SQL

(0) Share

Report

Report

Posted on by Mayela Pereda

30

Hello!

I have a Windows Server 2003 with Microsoft Dynamics GP 10.0

The last week I had problems with the NIC of that server.

I had to change the IP address of the server.

I tried to change the IP address in the ODBC of the clients.

But, they haven't be able to connect. Now, they're working by remote desktop.

What do I have to change in the server to allow the SQL connections?

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (7)

Answers Img

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

What was the internal IP address of the server and what is it now? This sound like a network issue and may require the use of the SQL configuration manager.

Was this reply helpful? Yes No
Mayela Pereda 30 on at

Like (0)

Report

The IP was 10.10.10.160. Now, it's 10.10.10.165.

I had to change it, because the network didn't recognize the same IP.

The server has the SQL Server 2005.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Have you rebooted the server? On the server if you go into SQL 2012 Configuration Manager are you using Alias'?

If you go into your 32 bit ODBC administrator can you perform successful connections?

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

My mistake, what version of SQL are you running? SQL 2008 R2?

Was this reply helpful? Yes No

Mayela Pereda

30 on at

Like (0)

Report

Report

It's SQL Server 2005.

**Information**
Microsoft SQL Server Management Studio	9.00.1399.00
Herramientas cliente de Microsoft Analysis Services	2005.090.1399.00
Microsoft Data Access Components (MDAC)	2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML	2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer	7.0.5730.13
Microsoft .NET Framework	2.0.50727.3082
Sistema operativo	5.2.3790

Was this reply helpful? Yes No

Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi Mayela,

As a general practice, it's not recommended to enter fixed IP Adresses in GP client configuration (ODBC setup), because of that kind of situation where you have to change the network address of your server's NIC.. You always use a server name (or even better, an ALIAS entry in the DNS) that points to the IP address.. this way your GP client won't have to be reconfigured and the user's password reset if the IP Address changes..

The GP client does encrypt the user password based on the ODBC entry that is used to connect the GP server by the name. Name change = pwd reset for all users, and you have to go around on each GP client and update the ODBC connexion.. not a good idea.

Was this reply helpful? Yes No
David Musgrave MVP ... 14,093 Most Valuable Professional on at

Like (0)

Report

Hi Mayela

I would say you need to recreate the passwords of all GP users except sa.

The issue is the encryption includes the Server Name / Address from the ODBC settings.

see the following article I wrote about this topic.

https://blogs.msdn.microsoft.com/developingfordynamicsgp/2008/10/01/why-does-microsoft-dynamics-gp-encrypt-passwords/

David

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Community Member 2

#2

Victoria Yudin 1

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans