GP 2013 on Server 2008 R2 will not connect to SQL Server 2008 instance

(0) Share

Report

Posted on by Community Member

I have installed GP 2013 on a Server 2008 R2 server & created a instance on a separate SQL 2008 R2 server. When I go into DB Maintenance on the GP server and try to connect to the instance on the SQL server it is telling me "Dynamics GP was not found on the SQL Server." Does Dynamics GP need to be installed on the SQL Server or am I doing something wrong. I have gone through the Installation PDF of both GP and SQL and have installed verbatim to what it is saying. I have the OBDC connector set up on the GP server and TCP/IP & Named Pipes are enabled for the \GP instance. What am I doing wrong?

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (1)

Suggested answer

Howard Swerdloff 845 on at

Like (0)

Report

If the server is 64 bit, be sure you are setting up a 32 bit odbc. Go to run and choose C:\Windows\SysWOW64\odbcad32.exe

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the reply Howard. I have done this process as the PDF requested. ODBC Tested successfully with sa credentials.

Was this reply helpful? Yes No
KirkLivermont 5,985 on at

Like (0)

Report

Have you ran GP Utilities yet?

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

Like (0)

Report

Check your firewall setting. SQL uses port 1433 as a default. Perhaps this port is not open. Does this work if you on the same server as GP and SQL?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Benp,

it Supports SQL Server Native Client 11.0 and above

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

if it is 64 bit machine,it Supports SQL Server Native Client 11.0 and above or set 32 bit odbc. Go to run and choose C:\Windows\SysWOW64\odbcad32.exe

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have ran the GP Utilities and was able to log in but go the following errors then it exited.

"Error message 35100 doesn't exist"

"Failed upgrading table: DB_Upgrade."

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Natarajan- I have ran on the GP server should I set up another OBDC on the SQL server as well pointing to the GP server?

Richard - I opened these ports still no go.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Does GP need to be installed on the SQL server? That's what the error I originally posted seems to indicate...

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

Like (0)

Report

1) Install SQL on the server

2) Install GP on the server

3) Launch GP Utilities on the server

This way all company databases will be created on the server and all initial database setup work is done on the server. Once the server is complete you move onto the workstations. I also create the GP package file on the server and store it in a share on the server poiting it to another common share for the forms,reports, letters and notes.

Was this reply helpful? Yes No