We have two FoxPro applications running on multiple systems in a single domain. SQL Server is the backend DB. UNC networked printer share names stored in a SQL table are queried from the FoxPro applications. The FoxPro app is set to the printer share name and sends the print job.
The query "SELECT PrinterName FROM Printers WHERE PrinterNumber='1' " returns the share name "\\Server01\Printer1" where Server01 is the 2003 server and Printer1 is a shared printer on that server. This has worked for years on the Windows 2003 Server print spooler.
We added a Windows Server 2008 system to the domain.
The query "SELECT PrinterName FROM Printers WHERE PrinterNumber='2' " returns the share name "\\Server02\Printer2" where Server02 is the 2008 server and Printer2 is a shared printer on that server. This does not work. Server02 is a HyperV guest OS where the host OS is Server 2008 Enterprise. (This is NOT R2). Server02 has been set up as the print spooler for the domain and is working as such for all purposes other than the FoxPro print jobs.