I have two machines connected via an ethernet lan - lets call one HPPAV and another COMPAQ. HPPAV has a new installation of MSDE 2000, plus the client tools from Microsoft SQL 2000 Standard (e.g., Enterprise Manager, , and a Test database. I want to enable applications I have running on the COMPAQ (which also has MSDE 2000, as well as SQL 2005 client tools, but probably not pertinent) to have data access (read only, full, whatever) to the Test database on HPPAV. The HPPAV and COMPAQ do not have common user logon accounts, if that matters. COMPAQ can access other data easily from HPPAV through the use of shared folders, but I'm having trouble setting this up.
I know this is probably SQL 101, but I haven't had much success in searching over the web - no simple answers, however.
Your help will be greatly rewarded with 500 points!