<div>
Is the server end of GP 10 on the same build number? What build number does the other PC have?<br />
<br />
Based on the build number, it looks like you installed all GP 10 updates up through the 2012 Year End Update:<br />
<a href="http://victoriayudin.com/2010/09/11/dynamics-gp-version-numbers-and-service-packs/" rel="ugc">http://victoriayudin.com/2010/09/11/dynamics-gp-version-numbers-and-service-packs/</a><br />
<a href="http://blogs.msdn.com/b/dynamicsgp/archive/2012/04/05/microsoft-dynamics-gp-10-0-mainstream-support-ending-on-october-9th-2012.aspx" rel="ugc">http://blogs.msdn.com/b/dynamicsgp/archive/2012/04/05/microsoft-dynamics-gp-10-0-mainstream-support-ending-on-october-9th-2012.aspx</a><br />
<br />
<br />
According to this thread, you need at least SP5 installed (build 10.0.1579) in order to use SQL Server 2008 R2. The 2012 Year-end update should theoretically also work, since it's a later build, but it's possible that the GP 10 server and GP 10 client have to be on the same build in order to work together, and your server isn't updated.<br />
<a href="http://blogs.msdn.com/b/dynamicsgp/archive/2012/04/05/microsoft-dynamics-gp-10-0-mainstream-support-ending-on-october-9th-2012.aspx" rel="ugc">http://blogs.msdn.com/b/dynamicsgp/archive/2012/04/05/microsoft-dynamics-gp-10-0-mainstream-support-ending-on-october-9th-2012.aspx</a>
</div>


<div>
Yes, forgot to mention, there is no server end. &nbsp;The sql &amp;&nbsp;gp in on the same w10 pc. &nbsp;Nevertheless, based on your recommendations, in order for gp to work in sql, the apps has to be on 10.0.1579. &nbsp;Ok will try.<br />
<br />
Thanx!
</div>


<div>
My understanding of how GP works is that there's a server application and a client application. You could theoretically run both the server and the client on the same PC, but you still need both. The GP server runs on the same computer as the SQL server.<br />
<br />
You mentioned another PC running GP, so I assumed there was a server running SQL server and the GP Server, and then 2 or more PCs running the client connecting back to the server. That's sorta the appeal of GP, the ability to connect multiple clients to the same server with all the accounting records.
</div>


<div>
As mention in the original question, we have prepare a standalone windows 10 box for testing purposes. &nbsp;Within the box we installed sql2008 and afterward installed gp10.<br />
<br />
FYI, we checked our GP version and its 10.00.1868 (much newer than the required for SQL, 10.0.1579 / SP5)<br />
<br />
Maybe there is a step we are missing maybe?
</div>


<div>
Did you check for both the server application and the client application? Even if running on one PC, you still need both.<br />
<br />
Did you ever check what version the PC that's currently working is using?
</div>


<div>
yes, both installed. &nbsp;The currently PC that is working is same version (yes, sound super strange).
</div>


<div>
So this is a new PC setup, yes? How did you move over the GP/SQL database from the old PC?
</div>


<div>
Not a new pc; it's been upgrade to w10. &nbsp;We just installed sql from scratch and copy a db over and attached it.<br />
<br />
Since we have installed it previously and now it has problems, most probably we are missing something. &nbsp;Maybe another EE can provide the steps of install and maybe considerations when it's sql 2008 with gp 10?
</div>


<div>
GP 10 is really old, and really isn't designed for running on Windows 10. &nbsp;The issue could be with trying to run it on Win10. Reverting back to Windows 7 may fix the issue. Did you make a backup of the PC before the upgrade? <br />
<br />
You could also upgrade GP and SQL to a more recent version if you want to run on Win10.<br />
<br />
Here's the procedure on how to move a GP database to a new computer:<br />
<a href="https://support.microsoft.com/en-us/kb/878449" rel="ugc">https://support.microsoft.com/en-us/kb/878449</a><br />
<br />
Also related, how to make a copy of a GP database:<br />
<a href="https://support.microsoft.com/en-us/kb/871973" rel="ugc">https://support.microsoft.com/en-us/kb/871973</a>
</div>


<div>
Yes we backed up the DB.<br />
<br />
Though we already have a w10 pc setup as what we need, we decided to use &nbsp;a Windows 8 pc to see what happens.<br />
<br />
(we'll let u know)
</div>


<div>
Same problem; didn't work... definitely we are doing something wrong.
</div>


<div>
What's the exact problem? Is it not connecting to the SQL database, or the database is empty (no stores)?
</div>


<div>
(maybe since we need it for testing, eventually clone the good PC... but then, wouldn't know what happened)
</div>


<div>
when you try to connect whats the message coming? is it saying wrong password?
</div>


<div>
Update: re-reading the question, we went over installation process and also see all our previous installs and effectively the problem the sql port. &nbsp;For some reason we had it pointing somewhere else.
</div>


<div>
<div class="content wysiwyg-content">
We prepare a computer windows 10 for testing some stuff we have and for some strange reason our g.p 10 (build 1068) is not connecting with the s.ql 2008 R2 installed in that PC; not seeing the companies. &nbsp;We have done this before and have a computer with similar setup. &nbsp;Please advice where to look.
</div>
</div>


We prepare a computer windows 10 for testing some stuff we have and for some strange reason our g.p 10 (build 1068) is not connecting with the s.ql 2008 R2 installed in that PC; not seeing the companies.  We have done this before and have a computer with similar setup.  Please advice where to look.

g.p 10 &amp; s.q.l 2008 R2 not working

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

The Windows operating systems have distinct methodologies for designing and implementing networks, and have specific systems to accomplish various networking processes, such as Exchange for email, Sharepoint for shared files and programs, and IIS for delivery of web pages. Microsoft also produces server technologies for networked database use, security and virtualization.

Windows Networking

Networking is the process of connecting computing devices, peripherals and terminals together through a system that uses wiring, cabling or radio waves that enable their users to communicate, share information and interact over distances. Often associated are issues regarding operating systems, hardware and equipment, cloud and virtual networking, protocols, architecture, storage and management.

Networking

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

g.p 10 &amp; s.q.l 2008 R2 not working

g.p 10 & s.q.l 2008 R2 not working