Linked Server Not Working

Check that you selected the Select the Level Zero Only and Allow in Process options in the Provider Options window. You may have forgotten to set them when you were creating your linked server. These are the only two options that should be selected.