i am trying to do it like this but this is not working

select Count(AnswerID) AS T

FROM answers WHERE DateDiff("hh", '2011-03-10', ReceivedOn) <=1

where Receivedon is the time wen the...

Wen i chk my error log file it gives the error that

login failed for user sam bcz an attempt to login using sql authentication...server is configured only for...

infact there is another login sam-pc/sam with windows authentication mode...wen i tried to connect with this login it gives me the same eror:(

i have enabled the sa frm sql server management->logins->sa....

but for Sa ...in usermaping SOne ise not selected and wen i tried to select it and assign it...

Hello

i hav changed my connection string like this

"Server = SAM-PC ;Initial Catalog=SOne;packet size=4096;user id=sa; password=sa; persist security info=false"

and now it is saying tht loging faile for user 'sa'....

Thank you all for your kind help, with your guidence i have resolved my issue