Ok I havent used great plains at all and its been a _long_ while since ive setup! This might just be a step in the right direction but it might just do it. This is for setting up an ODBC........without a MSSQL server running. Wooooo, here we go!
On the workstation goto control pannel then to Administrative Tools
Double click/open 'Data Sources'
In the first tab 'System DSN' click add
Scroll down to SQL Server then finish
Enter the Name, Desc, Server IP
Check the authentication if you only have one default user i.e. sa/<pass> [DONT LEAVE THE SQLADMIN[SA] ACCOUNT WITH A DEFAULT PASSWORD OR NO PASS! I DONT KNOW HOW MANY WAREZ SERVERS ARE RUNNING OUT THERE IN THE WORLD BECAUSE OF THIS! SA HAS EXEC PERMS!]
Thats all I can remember without having an MSSQL server right here for testing.
Also take a look at this. http://support.easystreet.com/hosting/win2k/sql.htm
Hope this helps!