Configure SQL 2000 surface area browsing
Hi we have a resource scheduler management system provided by peoplecuble (formerly meeting maker). Everything is running fine and we have this on a virtual server running SQL 2000. We want to run off reports from the underlying database. I'm OK with this but can't connect through to the server using standard ODBC links from Access because of SQL Surface Browsing isn't enabled. Does anyone know how to get this working? I don't want to upgrade to server express 2005 if possible.