We have SBS 2003 functioning as our domain controller, active directory and exchange server. SQL Server 2000 MSDE installed with quite a few instances one of which to serve a SharePoint Team Portal and the other is for enterprise backup purposes. I am certain that all instances are functional. I have tested the SharePoint administrator, creation and editing of contents which I discovered to be saved successfully which led me to believe that the database part is working as it should.
The problem comes when I try to connect to the server from my development client machine via LAN using Data Link features of Access project. Access can see the instance name of the BackupExec but not of the SharePoint. With some searching I think I have narrowed the answer to something to do with Network untilies i.e. TCP/IP not originally installed. Would this likely be the case, the server is a production server therefore would it be possible to add networks tools without rebooting. Do I need to re-patch once these tools are installed.