Thanks guys, i have checked everything, and it all looks fine,
i will try the suggestion to
check my sql server settings by running dcomcnfg.exe from the command prompt and add the SQL Service account to Default Access Permissions under Default Security tab
i will let you know how it went
[font="Comic Sans MS"][/font]It is what it is.