Sorry Old Hand on account of the late reply,

In actual fact before I got your last message I deinstalled 2005 and installed 2000. I continued to experience the same problem...

Thanks for the response but I have already set the properties to "windows and sql authentication mode" and am still getting this message.

Thanks Old Hand,

That worked out great.