?
Solved

No SQL Server to choose in MS Dynamics Great Plains

Posted on 2006-11-22
4
Medium Priority
?
665 Views
Last Modified: 2013-11-23
New install of Dynamics 8.0 on a workstation in an established network installation (already have 6 other stations running Dynamics 8.0 connected to our server (which is SBS 2000 with SQL 2000)).

Before I installed Dynamics, I created a new ODBC System DSN named "SQL for Dynamics".  It connected & tested fine within the ODBC setup routine.

Then, when I started Dynamics, there was no SQL Server to choose from in the drop down dialog on the login screen - the one I created did not appear.  I could still input a username & password and it DID connect to my SQL server.  On the next dialog box where you shoose which Dynamice Company to load, it had "SQL for Dynamics" in the SERVER line, but the company I wanted to load did not appear in the Company drop down.  (We have about 5 companies - all the others appeared, but not the one I need!).

I checked the DSN connection, even finally deleted it & recreated another one, same result - no server listed, but could still get to all companies but one.

Trashed the DSN & recreated it AGAIN, this time giving it the same name as the name of our SQL server which is "CRICKET".  NOW, still no server listed in drop down box, but now it will NOT login as it did before.  When I enter a valid username & pw I get "Please select a SQL server to connect to".

Any thoughts are much appreciated.

cricketman
0
Comment
Question by:cricketman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 3

Expert Comment

by:DennisL
ID: 18022519
Can you outline the steps you did to create the DSN?
0
 

Author Comment

by:cricketman
ID: 18076088
SOLVED

The workstation in question was a fresh install of Win XP, and did not have Service Pack 2 installed yet.  I installed SP2 and it immediately solved the problem.
0
 
LVL 1

Accepted Solution

by:
kodiakbear earned 0 total points
ID: 18110376
Closed, 200 points refunded.
kb
Experts Exchange Moderator
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month9 days, 4 hours left to enroll

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question